Question 1

FIGURE AC 9-12  In Figure AC 9-12 above, Item 1 points to ____.

Accepted Answer

A)  Record Navigation options 
B)  Field Navigation options 
C)  Tab Navigation options 
D)  Form Navigation options

Question 2

You can start a mail merge from Word, but not from Access.

Accepted Answer

A) True 
 B)False

Question 3

When data is formatted using comma separators, the comma is called a limiter .

Accepted Answer

A) True 
 B)False

Question 4

Click the Design tab, and then click the Themes button ____ in the Themes group to display the Themes gallery.

Accepted Answer

A)  check box 
B)  arrow 
C)  square 
D)  icon

Question 5

FIGURE AC 2-1  Figure AC 2-1 above shows Field properties for a(n) ____ field.

Accepted Answer

A)  Text 
B)  Memo 
C)  Number 
D)  AlphaNumeric

Question 6

Match between columns
                        Premises: A symbolic name that you assign to a value

Accepted Answer

The Answer of variable name and period (.) and comment is...

Question 7

Match between columns
                        Premises: Identifies the purpose of the form.

Accepted Answer

The Answer of text box and form title and form is...

Question 8

When you use a wizard to create a report, the report opens in Layout view.

Accepted Answer

A) True 
 B)False

Question 9

To make editing records easier, Access includes navigation buttons on the Ribbon at the bottom of the datasheet.

Accepted Answer

A) True 
 B)False

Question 10

To run a macro using the Macro Tools Design tab, click the ____ button in the Tools group.

Accepted Answer

A)  Execute 
B)  Query 
C)  OK 
D)  Run

Question 11

Access combines compacting and repairing into one step.

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: Menu that opens when you click the arrow on the right side of a field selector.

Accepted Answer

The Answer of Total row and Expression and Foreign key is...

Question 13

Match between columns
                        Premises: Stores dates, times, or a combination of both.

Accepted Answer

The Answer of Currency and Text and Memo and Date/Time is...

Question 14

A comment can affect the way the macro is executed.

Accepted Answer

A) True 
 B)False

Question 15

When you need to create a report quickly, you can use the Label Wizard , which asks you about the report you want to create and lets you select options in dialog boxes to specify the report's record source, layout, and style.

Accepted Answer

A) True 
 B)False

Question 16

To create a database, start Access. On the ____ tab in Backstage view, click the template you want to use.

Accepted Answer

A)  New 
B)  Create 
C)  Print 
D)  Help

Question 17

Match between columns
                        Premises: Have a common field.

Accepted Answer

The Answer of parameter queries and related tables and action is...

Question 18

Explain how Access helps to protect data from corruption caused by a virus hidden in a macro. Be sure to explain possible options.

Accepted Answer

The answer of Explain how Access helps to protect data...

Question 19

A(n) ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures.

Accepted Answer

A)  bound 
B)  unbound 
C)  either a. or b. 
D)  neither a. nor b.

Question 20

FIGURE AC 9-12  In Figure AC 9-12 above, the ____ wizard is displaying.

Accepted Answer

A)  Command 
B)  Command Button 
C)  Control 
D)  Control Button

Exam 1: Microsoft Access Basics

FIGURE AC 9-12 In Figure AC 9-12 above, Item 1 points to ____.

You can start a mail merge from Word, but not from Access.

When data is formatted using comma separators, the comma is called a limiter .

Click the Design tab, and then click the Themes button ____ in the Themes group to display the Themes gallery.

FIGURE AC 2-1 Figure AC 2-1 above shows Field properties for a(n) ____ field.

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.

When you use a wizard to create a report, the report opens in Layout view.

To make editing records easier, Access includes navigation buttons on the Ribbon at the bottom of the datasheet.

To run a macro using the Macro Tools Design tab, click the ____ button in the Tools group.

Access combines compacting and repairing into one step.

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.

A comment can affect the way the macro is executed.

When you need to create a report quickly, you can use the Label Wizard , which asks you about the report you want to create and lets you select options in dialog boxes to specify the report's record source, layout, and style.

To create a database, start Access. On the ____ tab in Backstage view, click the template you want to use.

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

Explain how Access helps to protect data from corruption caused by a virus hidden in a macro. Be sure to explain possible options.

A(n) ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures.

FIGURE AC 9-12 In Figure AC 9-12 above, the ____ wizard is displaying.