Exam 1: Microsoft Access Basics

Themes add borders and colors to forms.

A(n) ____________________ control lets you use functions to add a calculation to a report.

You can add controls to a form that display the results of a calculation.

To add a control to a report, click the button in the Controls group.

You double-click ____ in the New Query dialog box to display the Crosstab Query Wizard dialog box.

In the Database Tools tab ____________________ group, click the Database Documenter button to open the Documenter dialog box.

You would use the ____ form event to run an embedded macro when a form is closed.

The data in a report is ____________________, which means that you can view it but you cannot change it.

____ mode allows several users to open and use the database at the same time.

A form field has three parts.

You can add a(n) _____ to a report.

To help protect your data from the corruption caused by a virus hidden in a macro, you can set one of ____ macro security levels in Access.

When opening a database, an available AutoExec macro runs before any other tasks are performed.

If you are creating a document from scratch, the first step is to select the type of document you are creating. For a form letter, choose the ___________________ option button.

By adding basic formatting to a report before you apply a(n) schema , the theme formats are enhanced.

A combination of numbers and text is also called alphanumeric data.

After you have added all of the fields to your table, the last column in the table contains the Click to Add field selector in case you need to add another field later.

To create a filter using the Filter and Sort dialog box, use the Field list arrow to select the field to filter, use the Comparison list arrow to choose the filter operator, and then type a value in the ____ text box.

Case AC 7-1 Ed Brown is the chief financial officer of a medium-sized business distributing geological surveying meters and associated equipment to engineering companies and government agencies. Ed has noticed that the company sales and receipts are not matching properly, and he suspects inadvertent human error in Access database data entry. For the date issue of immediate concern, you decide to use ____ to increase accuracy and efficiency of data entry.