1. You can run a macro all of the following ways, except? 

  Directly 
 Hold down the control and M keys.
 From another macro.
 From a command button.

2. When referring to a macro in a group you may use which of the following syntaxes?

  Macrogroupname.macroname
Macroname
Macroname.macrogroupname
Macrogroupname.

3. The reference property is available only by using which of the following?

 A Form
 A report
Visual Basic
A Query

4.  You can synchronize records between two forms, by?

 Creating a command button to open the second form.
 Using the Current Event to display related records on the second form when you move between records on the first form.
 Use form wizard to create two related forms from scratch.
 All of the above.

5. Which of the following expressions defines an SQL command?

 Select
 Where
 Order by
 All of the above

6. Which best describes the function of a cross tab query?

 A cross tab query calculates a type of total for data that is grouped by two types of information, down the left and across the top.
 To relate data between two forms
 To create a completely separate graph based on the data from the original report or form.
All of the above

7. What is a Module? .

 A collection of Visual Basic for Applications declarations and procedures that are stored together as a unit. 
 A module is associated to particular forms or reports often containing event procedures.
 A module contains frequently used procedures in a form or report.
A module is a customized form of a macro

8. What is the difference between class modules and standard modules.

 The version of the Access program.
 Class modules are associated particular forms or reports often containing Event Procedures, while Standard modules are just associated to classified forms or reports.
 Class modules often contain Event Procedures, while Standard modules contain general procedures that aren't associated with any other object and frequently used procedures that can be run from anywhere on your database.
 Class modules are associated to particular forms or reports often containing Event Procedures, while Standard Modules contain general procedures that aren't associated with any other object and frequently used procedures that can be run from anywhere on your database.

9. Which of the following is not one of the three errors that can occur in Visual Basic Code.

 Compile time errors
 Common errors
 Run time errors
Logic errors

10. How does one add a dynamic chart to a form or report?

Open the form/report in Design View, click chart on the Insert menu, on the form/report click where you want to add the chart follow direction from the chart wizard, switch  to form view to see the chart with current data.
Choose chart wizard, follow the directions.
Create the chart in Excel and then transfer it into an Access form or report.
All of the above.