CIS 146 Microcomputer Apps Final Exam

Question 1

A filter is used to

Answer 1

view only those records that meet specified criteria.

Question 2

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

Answer 2

database

Question 3

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

Answer 3

Record Navigation bar.

Question 4

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

Answer 4

Records

Question 5

By default, Access prints a table on

Answer 5

legal size paper in portrait orientation.

Question 6

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

Answer 6

Field Width

Question 7

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

Answer 7

Home

Question 8

Each _____ in an Access database represents a field.

Answer 8

column

Question 9

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

Answer 9

Ctrl + Home

Question 10

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

Answer 10

the Tab key

Question 11

Records for fields containing text can be sorted by specific values using the _____ option at the filter drop-down list.

Answer 11

Text Filters

Question 12

The Ascending button can be found in the

Answer 12

Sort & Filter group on the Home tab.

Question 13

The first object you create in an Access database is a

Answer 13

table.

Question 14

The Landscape button is in the _____ group on the Print Preview tab.

Answer 14

Page Layout

Question 15

The object at the left side of the Access screen that displays the objects in the
database organized into groups is the

Answer 15

Navigation pane.

Question 16

What does Access do if two records contain the same data in the primary key field?

Answer 16

displays an error message and does not allow the record to be saved

Question 17

What does it mean when a pencil icon appears in the record selector bar?

Answer 17

The record is being edited.

Question 18

What happens when you open an Access 365 database from outside a trusted location?

Answer 18

A security warning appears in the message bar.

Question 19

Where are the Print and Print Preview options located in Access?

Answer 19

at the Print backstage area

Question 20

You are sorting a table by the contents of a field in ascending order. The records listed first will be those in which the field value is

Answer 20

empty.