Question 1

Match between columns
                        Premises: Section is printed once at the top of the first page of the report, and usually includes the report title.

Accepted Answer

The Answer of Page Header and Report Header and Detail is...

Question 2

In the Form Wizard, the ____ layout displays fields with the labels at the top of a column that contains the field values.

Accepted Answer

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

Question 3

The first step in creating a database is to create the file that will store the data.

Accepted Answer

A) True 
 B)False

Question 4

FIGURE AC 10-17  In Figure AC 10-17 above, the expression categories area is referenced by ____.

Accepted Answer

A)  Item 1 
B)  Item 2 
C)  Item 3 
D)  Item 4

Question 5

You use ____ forms to design and implement user-friendly menus so that users can work with only those parts of the database they need.

Accepted Answer

A)  splash screen 
B)  startup 
C)  navigation 
D)  macro

Question 6

Match between columns
                        Premises: The macro actions formatted in easy-to-read sentences

Accepted Answer

The Answer of comment and arguments and filter and code is...

Question 7

Match between columns
                        Premises: Has tabs that let you select the lower-level forms.

Accepted Answer

The Answer of main menu form and hierarchical and lower-level is...

Question 8

After you delete a record, you can use the Undo command to restore it.

Accepted Answer

A) True 
 B)False

Question 9

Case Access 7-2 Andrew is an accountant with a large investment firm in New York. He keeps an Access database of travel expenditures for all of the auditors within the Oversight and Supervision Division. His database is updated nightly as part of the Computer Operations critical path runtime workload. For Andrew to compute the multiplication and division operations on two fields in his table, he would use the ____ operators.

Accepted Answer

A)  * and -- 
B)  * and ~ 
C)  * and \ 
D)  * and /

Question 10

When you insert a merge field in a Word document, the field name is enclosed in double ____.

Accepted Answer

A)  angle brackets 
B)  parentheses 
C)  quotation marks 
D)  none of the above

Question 11

To remove one or more selected controls from a control layout, ____ the control to open the shortcut menu, point to Layout, and then click Remove Layout.

Accepted Answer

A)  right-click 
B)  single-click 
C)  double-click 
D)  select

Question 12

Case AC 5-1 Monica is using the Label Wizard to help her in creating mailing labels. The first thing Monica does is to double-click First Name in the Available fields box. The First Name field is added to the Prototype label section. If the First Name field is enclosed in curly brackets, what does this mean?

Accepted Answer

A)  This is how Access indicates a field name used in a label 
B)  This is how Access indicates an error in spacing 
C)  This is how Access indicates a data entry error 
D)  None of the above

Question 13

To remove database encryption, you must enter the password in the ____ Database Password dialog box.

Accepted Answer

A)  Remove 
B)  Unset 
C)  Relinquish 
D)  Reverse

Question 14

To add background color to a splash screen, you click the ____ tab on the Design tab ribbon.

Accepted Answer

A)  Fill 
B)  Background 
C)  Color 
D)  Format

Question 15

Case AC 9-2 The Phantastic Photo Human Resources department requested an easier, consistent way to enter new employee data. The AAA Database Design consulting firm was hired to provide a new system based on Access database forms. The AAA team provided a prototype of the system, and then handed it back to Phantastic Photo to finish themselves. A consistent place for the logo still needs to be determined. To delete the border around the small logo, you select it and press the ____.

Accepted Answer

A)  CTRL and the Delete keys 
B)  SHIFT and Delete keys 
C)  Delete key 
D)  ALT and Delete keys

Question 16

If you select the option for Access to create a primary key, Access will create a field named ID at the beginning of the table and assign it the AutoNumber data type.

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: Means that when you change values in a record in an encrypted database, only the changed record will be encrypted.

Accepted Answer

The Answer of password and row level locking and encryption is...

Question 18

FIGURE AC 5-1  In the header of the report shown above, the date of January 29, 2013 is listed. This is the ____.

Accepted Answer

A)  date the report was first viewed 
B)  date the report was created 
C)  current date 
D)  default date for computer system

Question 19

Forms in the lower level of the hierarchy are produced first.

Accepted Answer

A) True 
 B)False

Question 20

In order to test a function, you type a(n) ____ before the function name and the variables.

Accepted Answer

A)  pound sign (#) 
B)  question mark (?) 
C)  asterisk (*) 
D)  apostrophe (')

Exam 1: Microsoft Access Basics

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

In the Form Wizard, the ____ layout displays fields with the labels at the top of a column that contains the field values.

The first step in creating a database is to create the file that will store the data.

FIGURE AC 10-17 In Figure AC 10-17 above, the expression categories area is referenced by ____.

You use ____ forms to design and implement user-friendly menus so that users can work with only those parts of the database they need.

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

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

After you delete a record, you can use the Undo command to restore it.

When you insert a merge field in a Word document, the field name is enclosed in double ____.

To remove one or more selected controls from a control layout, ____ the control to open the shortcut menu, point to Layout, and then click Remove Layout.

To remove database encryption, you must enter the password in the ____ Database Password dialog box.

To add background color to a splash screen, you click the ____ tab on the Design tab ribbon.

If you select the option for Access to create a primary key, Access will create a field named ID at the beginning of the table and assign it the AutoNumber data type.

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

FIGURE AC 5-1 In the header of the report shown above, the date of January 29, 2013 is listed. This is the ____.

Forms in the lower level of the hierarchy are produced first.

In order to test a function, you type a(n) ____ before the function name and the variables.