Exam 10: Using Macros and Sqlin Access: Advanced Techniques

The ORDER BY clause must be added to the beginning of an SQL statement after the WHERE clause.

What do you use to create a stand-alone macro?

A(n) ________ is a macro that executes when an event attached to a control or object occurs.

Access queries use an Oracle statement behind the scenes to extract data from tables.

One reason for using a SQL statement for a record source is that it is easier to transfer a form or report to another database because the record source is contained in the object.

What is the difference between a stand-alone macro and an embedded macro?

What character is used to select all the fields in a table in the Design view of a query?

________ is the industry standard language for defining, manipulating, and retrieving data in a database.

Which of the following inherits the logic of the table?

What are the two methods of programming with Access?

Data macros are used to ensure the accuracy of data in a(n):

Once a macro has been created, you should ________ to initiate the tasks.

When you close a form or a report, the On Close event is triggered and Access executes the steps stored in the macro associated with the On Close event.

The SELECT keyword instructs Access to return the specific fields from one or more tables or queries.

An SQL SELECT statement is used to retrieve reports from tables in a database.

A(n) ________ is a variable, constant, or expression that is needed to produce the output for an action.

The ________ wizard can you use to create a macro.

All Access queries use ________ behind the scenes to extract data from tables.

Data macros can be accessed from anywhere in the database, including running them from within another macro.