Exam 39 : Using Macros and SQL in Access: Advanced Techniques

An SQL keyword defines the purpose and the structure of a SQL statement.

Access provides two methods of programming creating macros and creating procedures using Visual Basic Applications.

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

A(n)________ macro is created independently of other controls or objects and displays as an object in the Navigation Pane.

A ________ is a series of actions that can be programmed to automate tasks.

The SQL ________ keyword is used to sort the records by a certain field in either ascending or descending order.

The ________ was designed to make it easier to create macros,to modify macros,and to add or delete actions from macros.

Action queries each have their equivalent SQL keywords and syntax.

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

The ________ wizard can you use to create a macro.

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

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

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

After you create a macro,you initiate all its tasks by running it.

The SQL WHERE keyword specifies the:

What is SQL?

Data macros attach programming logic to tables.

An embedded macro is a database object that you create and use independently of other controls or objects.