Exam 1: Microsoft Access Basics

Case AC 11-1 The Accounting department manually runs queries every Monday morning to verify the reconciliation of salesperson salary. They have asked the Information Technology (IT) department for some assistance in saving time with this repetitive task. Because the report involves salary and private personnel information, security is an utmost priority. As the senior IT database analyst, you volunteer to help out with this request. The account manager insists that no changes should be made to the report query form when it is opened. You assure her that this can be accomplished by ____.

If a database file gets damaged or corrupted, you should be able to look at the documentation produced by the Back Up Database Command and fix the database or re-create it.

A(n) ____________________ query lets you summarize relevant data, such as adding the field values in a column that stores price data.

As you create a command button in an existing form with form operations, Access will add an event that is applicable to the object.

____ macros have events that run the macro.

The Before Update form event is triggered when the user begins to delete a record, but before the record is deleted.

The Back Up Database command uses the same filename as the file that was backed up.

A function can contain errors even though the statements have the correct syntax .

When a field name in the data source contains a space, the merge field in Word replaces the space with a question mark.

After you set the lookup properties for a field, a drop-down ____ will appear in the field when it is selected.

When revising current database options, a message box appears stating that the current database needs to be ____ before the options can take effect.

A ____ can add consistency to a form.

Because the primary key field in a table must contain a value, its Required property is set to Yes automatically. You must enter a value in a primary key field or Access ____.

After the input mask is created, placeholders appear in the ____ until the values are entered.

Just as with forms, the tables or queries that contain the data used in a report are called the controls .

A completed ____ query displays the data in a spreadsheet-like format.

The filter in a macro is typically based on a ____ in the database.

To reopen the Navigation pane, you can click the ____ button.

To begin increasing a text box width in Layout view, you place the pointer over the left side of the control until the pointer turns into a ____.

One way to make forms easier to use is to ____.