Question 1

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.

Accepted Answer

A)  Update recipient list 
B)  Import recipient list 
C)  Refine recipient list 
D)  Change recipient list

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Match between columns
                        Premises: The common field in the related table is called a(n) ____ when it is used in a relationship.

Accepted Answer

The Answer of Expression and Calculated field and Total row is...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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.

Accepted Answer

A)  font 
B)  font size 
C)  title 
D)  design

Question 6

Press the ____ to indent a line of code.

Accepted Answer

A)  TAB key 
B)  SHIFT key 
C)  CTRL + SHIFT keys 
D)  CTRL + TAB keys

Question 7

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

Accepted Answer

The answer of You can add a password to a...

Question 8

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?

Accepted Answer

A)  Double-click a field in the Field List 
B)  Click Create Field on the Ribbon 
C)  Both a. and b. 
D)  Neither a. nor b.

Question 9

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

Accepted Answer

A)  Calculated 
B)  Math 
C)  Accounting 
D)  Monetary

Question 10

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

Accepted Answer

A)  Password 
B)  Password Required 
C)  Password Needed 
D)  Password Necessary

Question 11

Match between columns
                        Premises: When you click the Find button in the Find group on the ____ tab, the Find and Replace dialog box opens.

Accepted Answer

The Answer of Tools and New and Home and File is...

Question 12

Themes are available in the Features gallery on the Ribbon.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  data types 
B)  data names 
C)  variable names 
D)  procedure names

Question 14

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

Accepted Answer

A)  link 
B)  combo box 
C)  tab 
D)  calculated control

Question 15

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.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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.

Accepted Answer

A)  a crosstab query 
B)  only wildcards 
C)  only parameters 
D)  both parameters and wildcards

Question 18

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

Accepted Answer

A)  Queries 
B)  Forms 
C)  Properties 
D)  Data Type

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  multiple tables in a query 
B)  parameters for the criteria field 
C)  the results from the query 
D)  the relationship with Employee ID fields

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 .

Identify the letter of the choice that best matches the phrase or definition.

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

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.

Identify the letter of the choice that best matches the phrase or definition.

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.

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 ____.