Question 1

A filter temporarily displays records in a datasheet based on the condition that you specify.

Accepted Answer

A) True 
 B)False

Question 2

Match between columns
                        Premises: When you are viewing a table or query datasheet, you can use the ____ to count the number of values in a column.

Accepted Answer

The Answer of AutoFilter and Expression and Calculated field and is...

Question 3

Match between columns
                        Premises: Stores long passages of text.

Accepted Answer

The Answer of Currency and Date/Time and Yes/No and Memo is...

Question 4

The Many Fields tool creates a form that lists all the fields in a datasheet format, but using a style that is similar to the form created by the Form tool.

Accepted Answer

A) True 
 B)False

Question 5

Average, Min, and Max are examples of VBA ____.

Accepted Answer

A)  syntax 
B)  controls 
C)  variables 
D)  built-in functions 
A)  syntax 
B)  controls 
C)  variables 
D)  built-in functions

Question 6

Match between columns
                        Premises: Use the ____ block link in the Mail Merge task pane to add an address to the letter in the location of the insertion point.

Accepted Answer

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

Question 7

When creating an append query, you can add all of the fields at one time to the query design by double-clicking the ____ to select all of the fields.

Accepted Answer

A)  table column 
B)  table row title 
C)  table name title 
D)  table grid outline 
A)  table column 
B)  table row title 
C)  table name title 
D)  table grid outline

Question 8

Match between columns
                        Premises: Allow you to arrange the information you want to place in the rows and columns.

Accepted Answer

The Answer of parameter queries and update queries and related is...

Question 9

A(n) AutoFilter is a menu that opens when you click the arrow on the right side of a field selector. The menu contains options for sorting data and clearing any filters that you have already applied.

Accepted Answer

A) True 
 B)False

Question 10

You can only skip saving a table when you make changes to its layout.

Accepted Answer

A) True 
 B)False

Question 11

If you have a table with an ID field with the AutoNumber data type, when you enter a new record in the table, you do not need to type a value in this field.

Accepted Answer

A) True 
 B)False

Question 12

You must enter data before you can see how an input mask will display data.

Accepted Answer

A) True 
 B)False

Question 13

You can highlight a line of code before you type it to make it easier to see in the window.

Accepted Answer

A) True 
 B)False

Question 14

To start a mail merge using Access, open the database that contains the data source for the form letters, and then click the data source (table or query) in the ____ to select it.

Accepted Answer

A)  Task pane 
B)  status bar 
C)  Ribbon 
D)  Navigation Pane 
A)  Task pane 
B)  status bar 
C)  Ribbon 
D)  Navigation Pane

Question 15

To draw a straight line, press and hold down the Tab key while drawing the line.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: Collection of characters that a user types to gain access to a file.

Accepted Answer

The Answer of password and Open Exclusive Read-Only mode and is...

Question 17

Case AC 1-1 Jonathan is the IT manager for a Toy Company and is looking into using different types of database objects. The Sales Manager has asked Jonathan to consolidate data from several tables into a format similar to a paper form. In this case, Jonathan would use the ____ object.

Accepted Answer

A)  Table 
B)  Query 
C)  Form 
D)  Report 
A)  Table 
B)  Query 
C)  Form 
D)  Report

Question 18

The ____________________ pane contains the tables in the database and displays the fields they contain.

Accepted Answer

The answer of The ____________________ pane contains the tables in...

Question 19

Setting lookup properties can help prevent data validation errors.

Accepted Answer

A) True 
 B)False

Question 20

Access 2010 has a new feature that allows you to create a(n) ____________________ field in a table.

Accepted Answer

The answer of Access 2010 has a new feature that...

A filter temporarily displays records in a datasheet based on the condition that you specify.

The Many Fields tool creates a form that lists all the fields in a datasheet format, but using a style that is similar to the form created by the Form tool.

Average, Min, and Max are examples of VBA ____.

When creating an append query, you can add all of the fields at one time to the query design by double-clicking the ____ to select all of the fields.

A(n) AutoFilter is a menu that opens when you click the arrow on the right side of a field selector. The menu contains options for sorting data and clearing any filters that you have already applied.

You can only skip saving a table when you make changes to its layout.

If you have a table with an ID field with the AutoNumber data type, when you enter a new record in the table, you do not need to type a value in this field.

You must enter data before you can see how an input mask will display data.

You can highlight a line of code before you type it to make it easier to see in the window.

To start a mail merge using Access, open the database that contains the data source for the form letters, and then click the data source (table or query) in the ____ to select it.

To draw a straight line, press and hold down the Tab key while drawing the line.

Case AC 1-1 Jonathan is the IT manager for a Toy Company and is looking into using different types of database objects. The Sales Manager has asked Jonathan to consolidate data from several tables into a format similar to a paper form. In this case, Jonathan would use the ____ object.

The ____________________ pane contains the tables in the database and displays the fields they contain.

Setting lookup properties can help prevent data validation errors.

Access 2010 has a new feature that allows you to create a(n) ____________________ field in a table.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

A filter temporarily displays records in a datasheet based on the condition that you specify.

The Many Fields tool creates a form that lists all the fields in a datasheet format, but using a style that is similar to the form created by the Form tool.

Average, Min, and Max are examples of VBA ____.

When creating an append query, you can add all of the fields at one time to the query design by double-clicking the ____ to select all of the fields.

A(n) AutoFilter is a menu that opens when you click the arrow on the right side of a field selector. The menu contains options for sorting data and clearing any filters that you have already applied.

You can only skip saving a table when you make changes to its layout.

If you have a table with an ID field with the AutoNumber data type, when you enter a new record in the table, you do not need to type a value in this field.

You must enter data before you can see how an input mask will display data.

You can highlight a line of code before you type it to make it easier to see in the window.

To start a mail merge using Access, open the database that contains the data source for the form letters, and then click the data source (table or query) in the ____ to select it.

To draw a straight line, press and hold down the Tab key while drawing the line.

Case AC 1-1 Jonathan is the IT manager for a Toy Company and is looking into using different types of database objects. The Sales Manager has asked Jonathan to consolidate data from several tables into a format similar to a paper form. In this case, Jonathan would use the ____ object.

The ____________________ pane contains the tables in the database and displays the fields they contain.

Setting lookup properties can help prevent data validation errors.

Access 2010 has a new feature that allows you to create a(n) ____________________ field in a table.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters