1. Which menu contains filter and sort commands?

 Records
 Insert
 Format
 Tools

2. Which of the following actions will result in a properly constructed table?

 Click Tables under Objects, then New, double click design view, define the fields. 
Click Tables under Objects, then New, define the fields.
Click Objects, Then New, double left click Design View, define the fields
Click Objects, Click Tables, double click Design View, define the fields.

3. You can create a form all of the following ways except? 

 Auto form
 A Wizard
 By yourself
The Pivot Table Wizard

4.  How does one open a table in design view?

 Click Design on the tool bar, then choose Tables.
 Click Tables under Objects, click the table you want to open, click Design on the Tool bar.
 Open the Tables menu, choose Design View.
 None of the above

5. Object Properties are available for which access objects?

 Forms, data access pages, macros, modules, and reports in an Access project
 Only Access projects
 Only forms and reports structured in tabular format
 For all objects in the program excluding; forms, data access pages, macros, modules, and reports in a access project.

6. When designing/modifying a query which of the following is an option? 

 Joining multiple tables
 Insert a field between other fields.
 Clear the design grid.
 all of the above

7. All of the following are queries you can create in Access, except?

 Select queries
 Parameter Queries
 SQL queries
 Search queries

8. Which of the following menu commands create an Auto Report?

 From the report tab choose Auto Report: columnar
 From the report tab choose Auto Report: fields
 From the report tab choose  Auto Report: Records
 Select the data set for the report and then choose Insert: Auto report

9. Why must you define relationships in an Access database? 

 Relationships define how the records in one table relate to the records in other tables
 To define the order in which forms and reports appear
 To define the order in which mathematical operations will be performed.
 none of the above.

10. Transfer Spreadsheet action refers to what?

Importing and Exporting data between Access and Excel.
Importing and Exporting data between tables.
Importing and Exporting data between forms.
All of the above