Question 1

The Form Wizard provides four form layouts from which to choose. The ____ layout displays fields in a stacked column format, with labels to the left of their controls.

Accepted Answer

A)  Columnar 
B)  Stacked 
C)  Controlled 
D)  Tabular

Question 2

After verifying that your form letters are correct, click the ____ link at the bottom of the Mail Merge pane.

Accepted Answer

A)  Merge 
B)  Next: Complete the merge 
C)  Complete 
D)  Next

Question 3

To freeze columns, select the field selectors for the columns that you want to freeze, click the More button in the Layout group on the File tab, and then click Freeze Fields.

Accepted Answer

A) True 
 B)False

Question 4

VBA requires the use of specific syntax so that the procedure performs actions ____.

Accepted Answer

A)  repeatedly 
B)  efficiently 
C)  correctly 
D)  quickly

Question 5

A(n) ____________________ is used to search for and retrieve data from tables using conditions.

Accepted Answer

The answer of A(n) ____________________ is used to search for...

Question 6

After you create a database, to run the AutoExec macro, you need to close the database and then reopen the database.

Accepted Answer

A) True 
 B)False

Question 7

When you click a control in ____ view, an orange border appears around the text box and a dotted border appears around its attached label to indicate that the control is selected.

Accepted Answer

A)  Layout 
B)  Query 
C)  Design 
D)  Print

Question 8

When you open a database, Access assumes that the database might contain something that could damage your computer.

Accepted Answer

A) True 
 B)False

Question 9

____________________ errors occur when the procedure produces incorrect results.

Accepted Answer

The answer of ____________________ errors occur when the procedure produces...

Question 10

Case AC 7-1 Ed Brown is the chief financial officer of a medium-sized business distributing geological surveying meters and associated equipment to engineering companies and government agencies. Ed has noticed that the company sales and receipts are not matching properly, and he suspects inadvertent human error in Access database data entry. Which of the following expressions can Ed define as a valid expression meaning the date entered needs to be after June 30, 2014?

Accepted Answer

A)  >#6/30/2014# 
B)  #6/30/2014# 
C)  6/30/2014

Question 11

When you relate tables, Access uses a set of rules to ensure that there are matching values in the common field used to form the relationship, both at the time you create the relationship and as you enter data in the tables after you create the relationship. This set of rules is called ____.

Accepted Answer

A)  referential integrity 
B)  security rules 
C)  match conditions 
D)  field rules

Question 12

Procedures include ____ that indicates where the procedure begins.

Accepted Answer

A)  colors 
B)  code 
C)  indents 
D)  arrows

Question 13

Match between columns
                        Premises: Each record is made up of one or more of these.

Accepted Answer

The Answer of fields and record and field value and is...

Question 14

By adding a calculated control in the report ____, the total of the sales will be displayed at the end of the report.

Accepted Answer

A)  base 
B)  footer 
C)  record 
D)  expression builder form

Question 15

A(n) ____________________ is a group of statements written in VBA code that can include several functions.

Accepted Answer

The answer of A(n) ____________________ is a group of statements...

Question 16

A database management system does not need to be computerized.

Accepted Answer

A) True 
 B)False

Question 17

You cannot sort data in a report using a field that is already used to group records.

Accepted Answer

A) True 
 B)False

Question 18

Avg is one of the functions available in a summary report.

Accepted Answer

A) True 
 B)False

Question 19

A backup copy of a database is created when you ____ the file using the Back Up Database option.

Accepted Answer

A)  close 
B)  save 
C)  open 
D)  create

Question 20

The database object called Macro displays data from one or more tables or queries in a format that might be similar in appearance to a paper form.

Accepted Answer

A) True 
 B)False

Exam 1: Microsoft Access Basics

The Form Wizard provides four form layouts from which to choose. The ____ layout displays fields in a stacked column format, with labels to the left of their controls.

After verifying that your form letters are correct, click the ____ link at the bottom of the Mail Merge pane.

To freeze columns, select the field selectors for the columns that you want to freeze, click the More button in the Layout group on the File tab, and then click Freeze Fields.

VBA requires the use of specific syntax so that the procedure performs actions ____.

A(n) ____________________ is used to search for and retrieve data from tables using conditions.

After you create a database, to run the AutoExec macro, you need to close the database and then reopen the database.

When you click a control in ____ view, an orange border appears around the text box and a dotted border appears around its attached label to indicate that the control is selected.

When you open a database, Access assumes that the database might contain something that could damage your computer.

____________________ errors occur when the procedure produces incorrect results.

When you relate tables, Access uses a set of rules to ensure that there are matching values in the common field used to form the relationship, both at the time you create the relationship and as you enter data in the tables after you create the relationship. This set of rules is called ____.

Procedures include ____ that indicates where the procedure begins.

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

By adding a calculated control in the report ____, the total of the sales will be displayed at the end of the report.

A(n) ____________________ is a group of statements written in VBA code that can include several functions.

A database management system does not need to be computerized.

You cannot sort data in a report using a field that is already used to group records.

Avg is one of the functions available in a summary report.

A backup copy of a database is created when you ____ the file using the Back Up Database option.

The database object called Macro displays data from one or more tables or queries in a format that might be similar in appearance to a paper form.