CIS 147 final exam
To create a new source for your document, which of the following options should you click?
Add new source
To apply the same formatting to multiple controls at the same time, press _______ as you click each control.
Ctrl
It is best to adjust print settings from
Print preview
To add an index to a document, click the _______ tab and then click the Insert Index button.
References
A(n) _______ field stores a true/false value as a ¿1 or 0.
Yes/No
You can sort _______ by text, by date, or by values.
alphabetically
You can use the _______ key(s) on your keyboard to navigate through fields in a record or between records.
arrow
A(n) _______ field can include images, Word documents, or almost any other type of data file.
attachment
A control that displays data from a table or query is called a(n) _______ control.
bound
To change the order of your slides, select a thumbnail and _______ until the slide appears where you want it in the slide order.
click and drag
To add a new field to a table in Datasheet view, click the arrow in the _______ column to expand the list of available field types.
click to add
Click and drag the _______ to make a control wider or narrower.
cursor
Click _______ in the Clipboard group to copy the slide to the Office Clipboard and remove it from its current location in the presentation.
cut
Fields can be inserted at the end of the field list in Design View by typing a new field name, and selecting a ________ type.
data
display data values for each data marker.
data labels
The _______ property allows you to add a preset value to a field.
default value
To apply a theme to a presentation, click the _______ tab of the Ribbon.
design
The _______ animation animates the object on the screen.
emphasis
The keyboard command for exiting your presentation is _______.
escape
The _______ allows you to select any color from your screen and apply it to an object.
eyedropper
Each column in a table represents a specific data value called a(n) _______.
field
A(n) _______ displays data from an underlying table and allows database users to enter, edit, and delete data in a user-friendly format.
form
Forms open in _______, which provides a user-friendly interface for entering data.
form view
A(n) _______ is the gradual transition of one color to another.
gradient
A(n) _______ is a printout of your presentation with anywhere from one to nine slides per page and with areas for taking notes.
handout
To switch to another view, click the _______ tab and then select your view from the View button arrow.
home
In Datasheet view, the number next to the attachment icon in each record tells you _______,
how many attachments there are
You should add transitions to a presentation only where they will _______ your presentation.
improve
To add a simple bibliography, click the _______ command at the bottom of the Bibliography gallery.
insert bibliography
A(n) _______ control displays the field name on the left.
label
If you want to see the last slide you viewed, but it is not part of the slide order, right-click the presentation and select _______ on the menu.
last viewed
Forms and Reports also offer _______ where you can modify some (but not all) structural elements.
layout view
charts show the movement of values over time. They work best when data trends over time are important.
line
Which of the following is the process of referring to data in another workbook"
linking
To sort or filter the category data in a PivotChart, click the button in the _______ corner of the PivotChart with the name of the field you want to sort or filter.
lower left
To create a Single Record form based on a table or query, you must first select the table or query in the _______.
navigation pane
In a new form there is(are) _______ record(s).
no
Select _______ when you want to print a text outline of your presentation.
outline
You can customize the weight and style of _______ for drawing objects from the Drawing Tools Format tab.
outline
The Tabs dialog is found in the _______ group on the Home tab.
paragraph
A(n) _______ is a geometric pattern that repeats across the background of the slide.
pattern fill
to apply a theme to a presentation, click _______ on the Ribbon.
picture effects
To apply a picture Quick Style to a picture, click the _______ tab.
picture tools format
To preview the mail merge, click the _______ button in the Preview Results group.
preview results
the _______ is the field that contains data unique to that record.
primary key
Reports include _______, which shows how the report will look when printed.
print preview
Clicking and dragging to resize controls can be imprecise. Use the _______ if you need to specify an exact width or height.
property sheet
are a combination of formatting that give elements of your presentation a more polished, graphical look without a lot of work.
quick styles
Each row in a table contains all the data for a single _______.
record
A(n) _______ database is a group of tables related to one another by common fields.
relational
To remove duplicate data that are not formatted as an Excel table, use the _______ command from the Data tab, Data Tools group.
remove duplicate
A(n) _______ displays data from a table or query in a format suitable for printing.
report
Click the _______ button to remove the changes you made and return the background to its original state.
reset background
Click the _______ button on the SmartArt Tools Design tab to restore the SmartArt diagram to the original state.
reset graphic
To delete a field in Datasheet view, one method is to _______ the field name at the top of the column and select Delete field.
right click
To delete the relationship between two tables you can _______ the relationship line and select Delete.
right click
A(n) _______ is a bubble with text that appears when the mouse is placed over a link.
screen tip
The _______ page color option in Read Mode displays black text on a light brown tone background.
sepia
Background gradients are comprised of _______.
shades of the same color
Background Styles include all of the following except _______.
shapes
A _______ is a visual representation of filtering options.
slicer
o hide slides, click the Hide Slide button on the _______ tab of the Ribbon.
slide show
You can control the order in which records appear in a table, query, or form by using the _______ feature.
sort
After you have added a new _______, it appears on the Insert Citation menu.
source
The top pane of the Design view window lists the _______ fields.
table
Access _______ are the essential building blocks of the database.
tables
The database ________ store all the data.
tables
The Slide Number button is located in the _______ group of the Insert tab.
text
A(n) _______ is a group of formatting options that you apply to a presentation.
theme
A(n) _______ is a unified color and font scheme.
theme
Background styles acquire their colors from the presentation''s _______.
theme
In Presenter view, you can use _______ monitors to display your presentation.
two
The Design view window is divided into _______ panes.
two
If you make changes to your document after you have inserted a table of contents, you should click the _______ button in order to keep the information in your table of contents accurate.
update table
Your choices for when an animation will start to play include all of the following except _______.
when triggered
You cannot create a _______ in a shared workbook.
worksheet
Another method to open the Tabs dialog is to _______ a tab stop on the ruler.
double click
If you want the copy of the slide to appear directly after the slide you are copying, click the arrow next to the Copy button and select _______.
duplicate
You can change a field name by modifying the _______ properties.
field
In Design view, the bottom pane is the _______ pane which displays details about the selected field.
field properties
allow users to input data through a friendly interface.
forms
slides allows you to prevent slides from being seen without permanently removing them.
hiding
The record navigation commands can be found in the Find group in the ______ tab.
home
A(n) _______ field stores a Web address or email address.
hyperlink
A(n) _______ is text or a graphic that, when clicked, takes you to a new location.
hyperlink
To change formatting for forms, you find the commands on the _______ tab.
Form Layout Tools Format
applies a fill color to alternating rows or columns, making the table easier to read.
banding
A(n) _______ is a reference to source material.
citation
The _______ Database command eliminates unnecessary database objects for optimum efficiency.
compact and impair
To begin a new Access database from scratch, you must first _______.
create the database file
Tab leaders can consist of all but _______.
number signs
Although you create and work with a single Access database file, inside the file, there are multiple
objects
In the _______ you can specify which pages to print and how many copies to print.
print preview view
rearranges the rows in your worksheet by the data in a column or columns.
sorting
A(n) _______ form combines the convenience of a continuous Datasheet form with the usability of a Single Record form displaying one record at a time.
split
To change the reference style for a document, click the arrow next to _____________ in the Citations & Bibliography group.
style
Click the _______ button to apply the custom background to all the slides in the presentation.
Apply to all
A(n) _______ field is automatically assigned its value by Access. Database users cannot edit or enter data in this field.
Auto number
The keyboard shortcut for opening the Insert Hyperlink dialog is
Ctrl+K
To open the Print page in Backstage view, you can use the keyboard shortcut _______.
Ctrl+P
To save a database object, you can use the keyboard shortcut _______.
Ctrl+S
The _______ animation animates the object coming on to the slide; starts with the object not visible and ends with the object visible.
Entrance
Which of the following is true of a SmartArt graphic''s position in a worksheet"
It rests on an invisible, transparent layer in the worksheet.
To create labels, click the _______ tab.
Mailings
To add a reference to every instance of a word to the index, click the _______ button in the Mark Index Entry dialog.
Mark All
If you need a version of one of your database objects, particularly reports, to look exactly like it would when printed from Access, consider exporting the object to a(n) _______.
PDF file
_______ apply combinations of fonts, line styles, fills, and shape effects.
Quick Styles
You can open the Edit Relationships dialog by clicking the Edit Relationships button on the _______ tab, in the Tools group.
Relationship tools design
To apply a theme to a report, click the Themes button in the _______ tab.
Report Layout Tools Design
To delete a field in Design view, select the field you want to delete by right-clicking the ______ to the left of the field name, and select Delete Rows.
Row selector
To add a Total row to a table, click the Total Row check box in the _______ tab.
Table Tools Design
To set the primary key in a table, click the Primary Key button in the Tools group of the _______ tab.
Table Tools Design
To update an index, first select the index and then click the _____________ button in the Index group.
Update Index
A(n) _______ is a compiled list of sources you referenced in your document.
bibliography
If the printed report will result in _______ page(s), Access will display a warning message when you switch to Print Preview view.
blank
A _______ is a brief description of an illustration, chart, equation, or table that usually appears above or below an image.
caption
The _______ type you select affects the story your chart tells.
chart
charts are similar to pie charts, but they can display more than one series of data.
circle chart
To remove filtering, click the _______ button.
clear filter
You can adjust the gradient stops by _______ to adjust how quickly the gradient blends from one shade to another.
clicking a slider tab and dragging it to the left or right
A(n) _______ is a set of colors that complement each other and are designed to work well in a presentation.
color theme
charts work best with data that are organized into rows and columns like a table.
column
A _______ displays a table of the data point values below the chart.
data table
provide a quick what-if analysis of the effects of changing one or two variables within a formula.
data tables
The Lookup Wizard is accessible after expanding the _______ in Table Design view.
data type list
Microsoft Access is a powerful _______ program that allows you to enter, store, and organize large amounts of data.
database
Tables open in _______ where you can enter, sort, and filter data.
datasheet view
The _______ animation animates the object leaving the slide; starts with the object visible and ends with the object not visible.
exit
To preview and print a presentation, click the _______ tab to open Backstage view and then click Print.
file
The _______ view allows you to modify how the printed version of your presentation will look.
handout master
To mark an entry, click the Mark Entry button in the _______ group of the References tab.
index
Some fields require a specific input format called a(n) _______.
input mask
The _______ tool turns the mouse pointer into a red dot that you can use to call attention to important parts of your slides.
laser pointer
The chart _______ provides a key so you know which data point or data series is represented by each color in the chart.
legend
When you enter data in a table, Access saves it each time you _______ a new field or begin a new record.
move to
All of the database objects are organized in the _______ Pane, which is docked at the left side of the screen.
navigation
If the field you want to change to a lookup field uses the Date/Time or Currency data type, you will need to change the data type to ____________ before you can modify it to be a lookup field.
number
A Single Record Form can be based on either a Table or Query and it displays _______ record(s) at a time.
one
PowerPoint¿s _______ feature allows you to copy and package all the elements of your presentation to a folder.
package for CD
Data in the _______ section appears at the bottom of every printed page in a report.
page footer
Data in the _______ section appears at the top of every printed page in a report.
page header
In Datasheet view, attachment fields are designated by a(n) _______ icon.
paperclip
charts represent data as parts of a whole.
pie
A _______ is a graphic representation of a PivotTable.
pivot chart
_______ is a special report view that summarizes data and calculates the intersecting totals.
pivot table
A slide background can be any of the following except _______.
placeholders
Click the _______ button during a presentation to select among the Arrow, Pen, and Highlighter.
pointer options
o check a presentation for spelling errors, click the Review tab and then click the Spelling button in the _______ group.
proofing
To insert a table of contents, start by clicking the _______ tab.
references
You can display all the database relationships at once by clicking the All Relationships button on the _______ tab.
relationship tools design
display database information for printing or viewing on-screen.
report
Data in the _______ section appears at the very end of the report.
report footer
Data in the _______ section appears at the very beginning of the report.
report header
Clicking the _______ button on the Quick Access Toolbar will prompt you to name and save a newly-created table.
save
After you have modified a theme, you can save it as your own custom theme by clicking the More button in the Themes group and selecting _______.
save current theme
To navigate to a specific slide during your presentation, right-click and point to _______ and then select the slide.
see all slides
In PowerPoint, the _______ command analyzes your entire presentation for spelling errors.
spelling
The Spelling command presents any errors it finds in the _______ task pane, enabling you to make decisions on how to handle each error or type of error in turn.
spelling
To create a new, blank table in Datasheet view, click the _______ button on the Create tab.
table
When you use a form to enter data, you are actually adding data to the underlying _______.
table
Use the check boxes in the _______ group to customize the table formatting by adding or removing banding for rows or columns.
table style options
A _______ is a document with predefined settings that can be used as a pattern to create a new file.
template
A(n) _______ is a file with predefined settings that you can use as a base to create a new database of your own.
template
Some _______ include fully formed documents with sample text for you to replace with your own information while others are empty shells based on a certain design
templates