Exam 1: Microsoft Access Basics

Validation text is entered in the Field Properties pane.

Basing a report on a parameter query is useful if you need to run multiple reports that display unique information.

Access performs startup options when the splash screen is opened.

Case AC 5-1 Monica is using the Label Wizard to help her in creating mailing labels. Monica wants to insert a space between the first and last name. What should she do before double-clicking the Last Name in the Available fields box?

You can add merge fields individually at the location of the insertion point by clicking the Insert Merge Field button in the Write & Insert Fields group on the ____ tab.

You can use Filter By Selection when you need to display records that contain one or more values based on the values stored in one or more fields.

The database object called query stores all the data in the database in a format called a datasheet.

Describe the various security and documentation features Microsoft Access offers to protect a database from losing important information.

FIGURE AC 2-1 Figure AC 2-1 above, you would access this Field Properties screen in ____ view.

Typically when you open a database, you use the Open mode.

To display the Query Design window, click the ____ tab and then click the Query Design button in the Queries group.

When a database is password protected, users cannot open the database unless they provide the correct login ID.

You can select all of the records in a table by clicking the ____________________, which is the box in the upper-left corner of a datasheet.

What does the Field Size property do? What is the default field value for Text fields, and why would you want to change it? What is the default field value for Number fields, and why would you want to change it?

The Query window is divided into three parts. The middle part of the window contains a navigation pane that allows you to specify the fields to include in the query datasheet.

The default setting for a mail merge is to print one record in the data source.

By selecting an option from the combo box list, instead of typing lengthy text, you ____.

You assign specific functions to the parts of a control in the Control Sheet.