Exam 1: Microsoft Access Basics

In the Mail Merge Recipients dialog box, the ____ section provides options for sorting and filtering data, finding duplicate records, locating a specific recipient, and validating addresses.

In Design view, you can add, delete, and make changes to the way that fields store data .

When you create lookup properties in the Lookup pane, your selections are limited.

Case AC 9-1 Sandy is the owner of a bakery specializing in healthy baked goods. As a new service for her customers, Sandy has decided to provide a public, interactive customer kiosk within her store that will allow all customers to gain information about her products. Sandy will use an Access database and present various forms on the kiosk window from which customers can select information. Due to your extensive knowledge in Access database form creation, Sandy has asked for your help in developing the forms. If all the forms in Sandy's database share the same ____, her customers will have an easier time using the forms.

Press the ____ to indent a line of code.

You can add a password to a database, which encrypts, or ____________________, the data.

Case AC 4-2 Zack wants to create a custom form to match a paper form that he uses everyday in the office. Zack has opened the Field List pane and wants to add a field to the form. What should he do?

Using the ____ data type, open the Expression Builder dialog box, which lets you specify fields and operators to use in calculations.

If a password is needed to open a database, the ____ dialog box appears.

Themes are available in the Features gallery on the Ribbon.

FIGURE 13-3 In Figure 13-3 above, item 1 points to ____.

A ____ can be used to perform calculations on the values in other fields.

When you export the data to Excel, it will be saved in Excel format, with each field in the table stored in a worksheet column and each record in the table stored as a row in the worksheet.

The Text fields have the default properties as well, which includes a default Field Size property of 385 characters.

Case Access 8-2 Betty is an assistant at the local pet shelter. She uses an Access database to store information about people who have adopted a pet, dropped off pets, or those who have contributed money and supplies to the shelter. While preparing for a fundraising event for the shelter, she recalls a donor whom she would like to contact but cannot recall the donor's name. However, she is certain it ends in the letters "son". By using ____, Betty will be able to enter only the criterion that she is certain of in a provided message box.

When viewing a table in Design view, the bottom half of the Table window is called the Field ____ pane.

In the Query Design window, you build and change the query using the query design grid.

Figure AC 8-1 In Figure AC 8-1 above, item 1 points to the area illustrating ____.