Question 1

Even the simplest functions can contain errors.

Accepted Answer

A) True 
 B)False

Question 2

When a form is displayed in Query view, you will see each record in the record source in a form.

Accepted Answer

A) True 
 B)False

Question 3

After you save a table, the new table name appears ____.

Accepted Answer

A)  on the tab for the table 
B)  in the Navigation Pane 
C)  both a. and b. 
D)  neither a. nor b. 
A)  on the tab for the table 
B)  in the Navigation Pane 
C)  both a. and b. 
D)  neither a. nor b.

Question 4

The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs.

Accepted Answer

A) True 
 B)False

Question 5

You can close Access by clicking the Close button on the ____.

Accepted Answer

A)  status bar 
B)  toolbar 
C)  scroll bar 
D)  title bar 
A)  status bar 
B)  toolbar 
C)  scroll bar 
D)  title bar

Question 6

If you are going to use a control in a procedure, you first add the control to the database .

Accepted Answer

A) True 
 B)False

Question 7

If the report's controls all fit on the page, with the exception of the control in the Page Footer section, you can drag the control to the left so it fits on the printed page.

Accepted Answer

A) True 
 B)False

Question 8

A summary query shows every field in each record.

Accepted Answer

A) True 
 B)False

Question 9

Match between columns
                        Premises: To merge selected records in the data source, click the ____ recipient list link in the Mail Merge task pane to open the Mail Merge Recipients dialog box.

Accepted Answer

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

Question 10

You can import data stored in a workbook into a new or existing database table.

Accepted Answer

A) True 
 B)False

Question 11

The ____ operator selects records that match all of two or more conditions in a query.

Accepted Answer

A)  Or 
B)  And 
C)  Either 
D)  Plus 
A)  Or 
B)  And 
C)  Either 
D)  Plus

Question 12

Case AC 6-1 Kathleen is working with a large recipient list for an upcoming promotional mailing. She has opened the Mail Merge Recipients dialog box. Kathleen wants to remove some of the recipients from the mail merge list so they do not receive the promotional mailing. What should she do?

Accepted Answer

A)  Clear its check box 
B)  Double-click the recipient's name and click Remove 
C)  Fill in their name in the Data Source box 
D)  None of the above 
A)  Clear its check box 
B)  Double-click the recipient's name and click Remove 
C)  Fill in their name in the Data Source box 
D)  None of the above

Question 13

Crosstab queries calculate a Sum, Avg, Count, or other type of calculation that you choose for numerical data.

Accepted Answer

A) True 
 B)False

Question 14

The ____________________ tool creates a form that looks just like a datasheet.

Accepted Answer

The answer of The ____________________ tool creates a form that...

Question 15

In the Form Wizard, the ____ layout displays fields across the screen in the order in which they occur.

Accepted Answer

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

Question 16

Match between columns
                        Premises: Section is printed once for each row in the record source and contains the main body of the report.

Accepted Answer

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

Question 17

Match between columns
                        Premises: Accepts field values containing letters, numbers, spaces, and certain symbols.

Accepted Answer

The Answer of Text and Yes/No and Currency and Memo is...

Question 18

To run a macro in the Navigation pane, right-click the macro name, and then click ____ on the shortcut menu.

Accepted Answer

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

Question 19

Each object has a different ____________________ to identify its function.

Accepted Answer

The answer of Each object has a different ____________________ to...

Question 20

Crosstab queries calculate a Sum, Avg, Count, or other type of calculation that you choose for ____ data.

Accepted Answer

A)  string 
B)  numerical 
C)  text 
D)  variable 
A)  string 
B)  numerical 
C)  text 
D)  variable

Even the simplest functions can contain errors.

When a form is displayed in Query view, you will see each record in the record source in a form.

After you save a table, the new table name appears ____.

The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs.

You can close Access by clicking the Close button on the ____.

If you are going to use a control in a procedure, you first add the control to the database .

If the report's controls all fit on the page, with the exception of the control in the Page Footer section, you can drag the control to the left so it fits on the printed page.

A summary query shows every field in each record.

You can import data stored in a workbook into a new or existing database table.

The ____ operator selects records that match all of two or more conditions in a query.

Case AC 6-1 Kathleen is working with a large recipient list for an upcoming promotional mailing. She has opened the Mail Merge Recipients dialog box. Kathleen wants to remove some of the recipients from the mail merge list so they do not receive the promotional mailing. What should she do?

Crosstab queries calculate a Sum, Avg, Count, or other type of calculation that you choose for numerical data.

The ____________________ tool creates a form that looks just like a datasheet.

In the Form Wizard, the ____ layout displays fields across the screen in the order in which they occur.

To run a macro in the Navigation pane, right-click the macro name, and then click ____ on the shortcut menu.

Each object has a different ____________________ to identify its function.

Crosstab queries calculate a Sum, Avg, Count, or other type of calculation that you choose for ____ data.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

Even the simplest functions can contain errors.

When a form is displayed in Query view, you will see each record in the record source in a form.

After you save a table, the new table name appears ____.

The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs.

You can close Access by clicking the Close button on the ____.

If you are going to use a control in a procedure, you first add the control to the database .

If the report's controls all fit on the page, with the exception of the control in the Page Footer section, you can drag the control to the left so it fits on the printed page.

A summary query shows every field in each record.

You can import data stored in a workbook into a new or existing database table.

The ____ operator selects records that match all of two or more conditions in a query.

Case AC 6-1 Kathleen is working with a large recipient list for an upcoming promotional mailing. She has opened the Mail Merge Recipients dialog box. Kathleen wants to remove some of the recipients from the mail merge list so they do not receive the promotional mailing. What should she do?

Crosstab queries calculate a Sum, Avg, Count, or other type of calculation that you choose for numerical data.

The ____________________ tool creates a form that looks just like a datasheet.

In the Form Wizard, the ____ layout displays fields across the screen in the order in which they occur.

To run a macro in the Navigation pane, right-click the macro name, and then click ____ on the shortcut menu.

Each object has a different ____________________ to identify its function.

Crosstab queries calculate a Sum, Avg, Count, or other type of calculation that you choose for ____ data.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters