Exam 1: Microsoft Access Basics

Within a navigational form, a Forms Menu is at the higher level of the hierarchy.

After you create and save a macro, you need to ____________________ the macro in order to have it perform the recorded steps.

You access the Report Wizard by clicking the Create tab on the Ribbon.

When you are navigating in Datasheet view, pressing Shift+Tab ____.

To create a(n) ____________________ between two tables, you must design the tables so they contain a common field.

After you create a Text Box control in a form, you can press and hold down the ____ key and then use the arrow keys to move the text box to a desired location.

A computerized DBMS is ____ than using file folders.

The Property Sheet ____ displays all of the properties for a selected object.

Case AC 8-1 Eric runs a small computer repair service. He decides to reduce prices by 5% to see if he can obtain more clients. Eric quickly creates and runs an update database query against his price table to lower the prices displayed on his Web site and then decides to take a lunch break. In the meantime, Eric begins receiving many client emails and calls inquiring on the 50% price drop advertised on his Web site. What should Eric have done before running his query?

You can run a query by ____.

You can create a macro in the Macro window and then attach it to the object.

You can click the Data Type arrow in the ____________________ group to display a list of data types for fields.

When creating an AutoExec macro, it must be saved using the name ____.

To add a title to a form, which adds an unbound control to the form, click the ____ button in the Header/Footer group on the Design tab.

As you type VBA code, ____________________ appears to assist you in creating the function.

The ____ tool creates a simple form that includes all the fields in the selected table or query, uses a simple format, and includes a title with the same name as the record source.

When you change the row height of a datasheet, the change ____.

A(n) mirror field is a field that appears in both tables, has the same data type, and contains the same values.