Question 1

You can use the ____ link in the Mail Merge task pane to add an address to the letter in the location of the insertion point.

Accepted Answer

A)  Address 
B)  Location 
C)  Address block 
D)  Recipient 
A)  Address 
B)  Location 
C)  Address block 
D)  Recipient

Question 2

____________________ let you add borders, background colors, shading, and graphic effects to an entire report at one time.

Accepted Answer

The answer of ____________________ let you add borders, background colors,...

Question 3

To run an embedded macro, you simply click on the Run button.

Accepted Answer

A) True 
 B)False

Question 4

Case AC 2-1 Ron is an IT Manager at a local grocery store and is cleaning up one of his databases. Ron found a field that he wants to delete. He can delete a field by clicking the row selector for the field, and then clicking the Delete Rows button in the Tools group on the ____ tab.

Accepted Answer

A)  Design 
B)  File 
C)  Home 
D)  Create 
A)  Design 
B)  File 
C)  Home 
D)  Create

Question 5

An input mask can only be applied to fields with date data types.

Accepted Answer

A) True 
 B)False

Question 6

A(n) ____________________ is a series of actions that you want Access to perform.

Accepted Answer

The answer of A(n) ____________________ is a series of actions...

Question 7

Match between columns
                        Premises: 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

The Answer of Merge and Mailings and Edit and Insert is...

Question 8

When you merge the data source with the form letter, one letter is printed for each record in the data source. In this case, the form letter is also called the primary document.

Accepted Answer

A) True 
 B)False

Question 9

Match between columns
                        Premises: An arithmetic formula that performs a calculation.

Accepted Answer

The Answer of combo box and lookup property and text is...

Question 10

To change from ascending order to descending order in any of the Wizard dialog boxes, you click the Reorder button.

Accepted Answer

A) True 
 B)False

Question 11

Case AC 2-2 Jennifer is creating a new inventory management table for the pet store where she works. She is spending the time upfront to make sure the data types are all assigned correctly. Jennifer wants to add a field with the answer to the question, "Is this an inventory item?" The answer to the question would be "yes" or "no." In this case, she should use the ____ data type.

Accepted Answer

A)  Yes/No 
B)  True/False 
C)  On/Off 
D)  Inventory/Custom 
A)  Yes/No 
B)  True/False 
C)  On/Off 
D)  Inventory/Custom

Question 12

You can filter mail merge records by clicking the ____ link in the Refine recipient list section, which opens the Filter and Sort dialog box with the Filter Records tab selected.

Accepted Answer

A)  Refine 
B)  Filter 
C)  Sort 
D)  Edit 
A)  Refine 
B)  Filter 
C)  Sort 
D)  Edit

Question 13

The ____________________ tool lets you add a line to a report.

Accepted Answer

The answer of The ____________________ tool lets you add a...

Question 14

Access opens in ____ view.

Accepted Answer

A)  Design 
B)  Datasheet 
C)  Layout 
D)  Backstage 
A)  Design 
B)  Datasheet 
C)  Layout 
D)  Backstage

Question 15

Use the ____ property to specify how you want Access to display numbers, dates, times, and text.

Accepted Answer

A)  Setup 
B)  Layout 
C)  Format 
D)  Edit 
A)  Setup 
B)  Layout 
C)  Format 
D)  Edit

Question 16

A ____ that welcomes the user to the database is known as a splash screen.

Accepted Answer

A)  window 
B)  form 
C)  box 
D)  menu 
A)  window 
B)  form 
C)  box 
D)  menu

Question 17

The Form Wizard provides four form layouts from which to choose. Name and briefly describe each layout, including an example of a situation of where you would use each layout.

Accepted Answer

(Answers will vary) The Columnar layout

Question 18

Pressing the right arrow key moves you from one field to another in a form.

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises: Identifies what will appear in the unbound part of the text box control

Accepted Answer

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

Question 20

Most programs have converters to separate the values in a CSV file into the ____.

Accepted Answer

A)  columns of a worksheet 
B)  cells of a table 
C)  either a. or b. 
D)  neither a. nor b. 
A)  columns of a worksheet 
B)  cells of a table 
C)  either a. or b. 
D)  neither a. nor b.

You can use the ____ link in the Mail Merge task pane to add an address to the letter in the location of the insertion point.

____________________ let you add borders, background colors, shading, and graphic effects to an entire report at one time.

To run an embedded macro, you simply click on the Run button.

Case AC 2-1 Ron is an IT Manager at a local grocery store and is cleaning up one of his databases. Ron found a field that he wants to delete. He can delete a field by clicking the row selector for the field, and then clicking the Delete Rows button in the Tools group on the ____ tab.

An input mask can only be applied to fields with date data types.

A(n) ____________________ is a series of actions that you want Access to perform.

When you merge the data source with the form letter, one letter is printed for each record in the data source. In this case, the form letter is also called the primary document.

To change from ascending order to descending order in any of the Wizard dialog boxes, you click the Reorder button.

You can filter mail merge records by clicking the ____ link in the Refine recipient list section, which opens the Filter and Sort dialog box with the Filter Records tab selected.

The ____________________ tool lets you add a line to a report.

Access opens in ____ view.

Use the ____ property to specify how you want Access to display numbers, dates, times, and text.

A ____ that welcomes the user to the database is known as a splash screen.

The Form Wizard provides four form layouts from which to choose. Name and briefly describe each layout, including an example of a situation of where you would use each layout.

Pressing the right arrow key moves you from one field to another in a form.

Most programs have converters to separate the values in a CSV file into the ____.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

You can use the ____ link in the Mail Merge task pane to add an address to the letter in the location of the insertion point.

____________________ let you add borders, background colors, shading, and graphic effects to an entire report at one time.

To run an embedded macro, you simply click on the Run button.

Case AC 2-1 Ron is an IT Manager at a local grocery store and is cleaning up one of his databases. Ron found a field that he wants to delete. He can delete a field by clicking the row selector for the field, and then clicking the Delete Rows button in the Tools group on the ____ tab.

An input mask can only be applied to fields with date data types.

A(n) ____________________ is a series of actions that you want Access to perform.

When you merge the data source with the form letter, one letter is printed for each record in the data source. In this case, the form letter is also called the primary document.

To change from ascending order to descending order in any of the Wizard dialog boxes, you click the Reorder button.

You can filter mail merge records by clicking the ____ link in the Refine recipient list section, which opens the Filter and Sort dialog box with the Filter Records tab selected.

The ____________________ tool lets you add a line to a report.

Access opens in ____ view.

Use the ____ property to specify how you want Access to display numbers, dates, times, and text.

A ____ that welcomes the user to the database is known as a splash screen.

The Form Wizard provides four form layouts from which to choose. Name and briefly describe each layout, including an example of a situation of where you would use each layout.

Pressing the right arrow key moves you from one field to another in a form.

Most programs have converters to separate the values in a CSV file into the ____.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters