Exam 1: Microsoft Access Basics

A query is a database object that lets you ask the database about the data it contains.

An easy way to create a query is to use the ____, which asks you what data you want to see by letting you select options in dialog boxes.

Point to a button in the Controls group to display its name in a ____.

When creating a report, you add a currency format before you apply themes.

Aligning controls in a form is a complicated process.

Parameter queries increase efficiency.

AC Case 12-1 Taylor needs to display a splash screen when users open an inventory database. She knows VBA has a macro to help with this task; however, Taylor is unsure of how to use the macro. Taylor asks for your assistance. You suggest that Taylor use the _____ macro.

When you enter an improper field value, a(n) ____ message appears and tells you what to do to correct your mistake.

FIGURE AC 3-1 You use the Tables/Queries arrow in the dialog box shown in Figure AC 3-1 above to select the ____ that contains the data you want your new query to display.

Case AC 10-2 Stella Maroon owns the Stellar boutique in Malibu. Every month she must reconcile her inventory and take note of customer purchasing trends. One of her Paris suppliers is insisting that a blue cashmere shawl is going to be the latest trend over the next three months. Stella has some doubts, and would like to see some additional boutique sales reports to see if her clients are indeed trending towards shawls. She asks if you could assist her in creating these reports. What type of report would you suggest Stella run against her data to see trends in customer purchases?

Row level locking is turned on by default.

When you encrypt a database, data within the database is made unusable.

An AutoNumber field automatically adds a unique number to the primary key field for each record in the table.

Case AC 14-2 Ted recently finished creating a supplier database. The internal auditors are currently reviewing Ted's project and would like to see the properties of all the objects as well as their relationships. One of Ted's junior database designers questions the usefulness of the auditor's request. Ted explains that documenting the database design is considered a(n) ____ feature.

When you create a blank database, Access creates the first table in the database for you and names it ____.

An append query is a form of a(n) ____ query.

When a form is selected in the Form window, the Form Selector box appears with a ____.

When a report is based on a parameter query, each time you open the report, the ____ box appears.

You can open a table directly in Design view from the Navigation Pane. ____ the table name in the Navigation Pane, and then click Design View on the shortcut menu.