CIS 146 Final Exam Study Set

A filter is used to

view only those records that meet specified criteria.

A _____ is a collection of data that has been organized so that the data can be easily stored, sorted, extracted, and reported.

database

Add a new record to a table in Datasheet view by clicking the New (blank) record button on the

Record Navigation bar.

Add a record to a form with the New button in the _____ group on the Home tab.

Records

By default, Access prints a table on

letter size paper in portrait orientation.

Display the Column Width dialog box by clicking the More button in the Records group on the Home tab and then clicking the _____ option at the drop-down list

Field Width

Display the Find and Replace dialog box by clicking the Find button on the _____ tab.

Home

Each _____ in an Access database represents a field.

column

Press _____ to make the first field in the first record active.

Ctrl + Home

Press _____ to make the next field in the current record active.

the Tab key

A table should have a _____, or a field used to store a unique value for each record.

primary key field

A _____ field is used when you want to restrict the data entered into the field to a list of values.

lookup

A(n) _____ displays a pattern in a table or form indicating how data is to be entered into the field.

input mask

Access is called a relational database management system because of the relationships that can be established between

tables.

Each field has characteristics associated with it called

field properties.

How do you start the Input Mask Wizard?

Click the Build button in the Input Mask property box for the desired field.

If referential integrity is turned on in a one-to-one relationship, what displays at each end of the join line?

the number 1

In a one-to-many relationship, a common field is used to join tables. On the “one” side of the relationship, the field is called the _____, while on the “many” side of the relationship, it is called the

primary key; foreign key.

In Design view, on which tab will you find the button used to add rows to a table?

Table Design

This property stores descriptive titles for fields and is useful if you abbreviate a field name or want to show spaces between words in a compound field name.

Caption

To provide documentation of the relationships established between tables in a database, create a

relationship report.

A selected slide displays with this color border in the slide thumbnails pane.

orange

During a slide show, how do you toggle the screen display from a black screen to the current slide?

Press the letter B key.

In _____ view, an individual slide displays with any added notes displayed below it.

Notes Page

One method for changing the zoom in a presentation is to use the Zoom slider bar located at the right side of the

Status bar.

PowerPoint’s spelling checker compares words in your slides with

words in its dictionary.

Print PowerPoint presentation handouts with up to _____ slides per page.

9

Save a PowerPoint presentation by clicking the Save button on the

Title bar.

The Layout button is in the _____ group on the Home tab.

Slides

The mouse pointer changes to a red, hollow, glowing circle when you select _____ from the Pen button on the Slide Show toolbar.

Laser Pointer

The _____ is located toward the right side of the Status bar and contains buttons for changing the presentation view.

view area

Capture all or part of the contents of a screen as an image with the _____ button.

Screenshot

Format a screenshot image with options on the _____ tab.

Picture Format

Text that is formatted as a bulleted list in a slide can have

multiple levels.

The bottom row of the _____ group on the Home tab contains buttons for applying font effects such as bold, italic, and underlining.

Font

The button in the Font group on the Home tab that displays an uppercase I applies this font effect.

italic

The Format Painter button will remain active after you have used it to apply formatting if you initially _____ the Format Painter button to activate it.

double-clicked

This feature allows you to copy the formatting from one location in a presentation to another location.

Format Painter

This is the default slide size for PowerPoint.

16:9

To insert an image from a file, begin by clicking the Pictures button in the _____ group on the _____ tab.

Images; Insert