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