Question 1

Match between columns
                        Premises: Places the database in an unintelligible format.

Accepted Answer

The Answer of Open Exclusive mode and password and encryption is...

Question 2

Validation text is entered in the Field Properties pane.

Accepted Answer

A) True 
 B)False

Question 3

Basing a report on a parameter query is useful if you need to run multiple reports that display unique information.

Accepted Answer

A) True 
 B)False

Question 4

Access performs startup options when the splash screen is opened.

Accepted Answer

A) True 
 B)False

Question 5

Case AC 5-1 Monica is using the Label Wizard to help her in creating mailing labels. Monica wants to insert a space between the first and last name. What should she do before double-clicking the Last Name in the Available fields box?

Accepted Answer

A)  insert a semi-colon 
B)  press the spacebar 
C)  press the tab key 
D)  insert a comma

Question 6

You can add merge fields individually at the location of the insertion point by clicking the Insert Merge Field button in the Write & Insert Fields group on the ____ tab.

Accepted Answer

A)  Mail Merge 
B)  Form Letter 
C)  Mailings 
D)  Insert

Question 7

You can use Filter By Selection when you need to display records that contain one or more values based on the values stored in one or more fields.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: Should be entered in a logical order

Accepted Answer

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

Question 9

The database object called query stores all the data in the database in a format called a datasheet.

Accepted Answer

A) True 
 B)False

Question 10

Describe the various security and documentation features Microsoft Access offers to protect a database from losing important information.

Accepted Answer

The answer of Describe the various security and documentation features...

Question 11

FIGURE AC 2-1  Figure AC 2-1 above, you would access this Field Properties screen in ____ view.

Accepted Answer

A)  Datasheet 
B)  Design 
C)  Edit 
D)  Table

Question 12

Typically when you open a database, you use the Open mode.

Accepted Answer

A) True 
 B)False

Question 13

To display the Query Design window, click the ____ tab and then click the Query Design button in the Queries group.

Accepted Answer

A)  Open 
B)  Insert 
C)  Create 
D)  Query

Question 14

When a database is password protected, users cannot open the database unless they provide the correct login ID.

Accepted Answer

A) True 
 B)False

Question 15

You can select all of the records in a table by clicking the ____________________, which is the box in the upper-left corner of a datasheet.

Accepted Answer

The answer of You can select all of the records...

Question 16

What does the Field Size property do? What is the default field value for Text fields, and why would you want to change it? What is the default field value for Number fields, and why would you want to change it?

Accepted Answer

The answer of What does the Field Size property do?...

Question 17

The Query window is divided into three parts. The middle part of the window contains a navigation pane that allows you to specify the fields to include in the query datasheet.

Accepted Answer

A) True 
 B)False

Question 18

The default setting for a mail merge is to print one record in the data source.

Accepted Answer

A) True 
 B)False

Question 19

By selecting an option from the combo box list, instead of typing lengthy text, you ____.

Accepted Answer

A)  increase the accuracy of the information 
B)  increase security 
C)  increase color combination brightness 
D)  can link to other subforms for more options

Question 20

You assign specific functions to the parts of a control in the Control Sheet.

Accepted Answer

A) True 
 B)False

Exam 1: Microsoft Access Basics

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

Validation text is entered in the Field Properties pane.

Basing a report on a parameter query is useful if you need to run multiple reports that display unique information.

Access performs startup options when the splash screen is opened.

Case AC 5-1 Monica is using the Label Wizard to help her in creating mailing labels. Monica wants to insert a space between the first and last name. What should she do before double-clicking the Last Name in the Available fields box?

You can add merge fields individually at the location of the insertion point by clicking the Insert Merge Field button in the Write & Insert Fields group on the ____ tab.

You can use Filter By Selection when you need to display records that contain one or more values based on the values stored in one or more fields.

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

The database object called query stores all the data in the database in a format called a datasheet.

Describe the various security and documentation features Microsoft Access offers to protect a database from losing important information.

FIGURE AC 2-1 Figure AC 2-1 above, you would access this Field Properties screen in ____ view.

Typically when you open a database, you use the Open mode.

To display the Query Design window, click the ____ tab and then click the Query Design button in the Queries group.

When a database is password protected, users cannot open the database unless they provide the correct login ID.

You can select all of the records in a table by clicking the ____________________, which is the box in the upper-left corner of a datasheet.

What does the Field Size property do? What is the default field value for Text fields, and why would you want to change it? What is the default field value for Number fields, and why would you want to change it?

The Query window is divided into three parts. The middle part of the window contains a navigation pane that allows you to specify the fields to include in the query datasheet.

The default setting for a mail merge is to print one record in the data source.

By selecting an option from the combo box list, instead of typing lengthy text, you ____.

You assign specific functions to the parts of a control in the Control Sheet.