Exam 11: Enhanced Database Techniques

To test a data macro, open the table and perform whatever the event was to which the macro has been attached and see if the proper action is performed.

When you add a macro to an event, Access embeds a macro in the object or control and lists it on the Navigation Pane.

Which of the following is not considered a table event?

What is not a good task for a macro?

In SQL, the ________ statement is used to retrieve data from a table.

You can run a named data macro from within another macro by using what action?

Match the following SQL keywords with their purposes: I. SELECT II. FROM III. WHERE IV. GROUP BY V. ORDER BY A. This is not a SQL keyword. B. Specifies the sort order of the records C. Specifies which table or tables contain the necessary fields D. Specifies any criteria which will be applied to the records E. Specifies which fields will be displayed

Match the following terms with their descriptions: I. Argument II. SQL III. Stand-alone macro IV. Data macro V. SQL SELECT statement A. Triggered by table events B. A variable, constant, or expression that is used to produce the output for an action C. Industry-standard language for working with data in databases D. Statement used to retrieve data from tables E. Can be used independently of other objects

Business logic describes the policies and procedures established by an organization.

Macros can be created to run other macros inside of them.

________ is the data retrieval and data manipulation language of all the industry-leading databases.

What is true about how Access handles macros when there are multiple actions in the macro?

SQL stands for what?

An SQL ________ defines the purpose and the structure of an SQL statement.

________ macros can help to validate and ensure the accuracy of data in a table.

When there are multiple actions in a macro, Access executes the actions according to an established priority list.

If your SQL query does not include a WHERE statement, then how many records will be selected?