Exam 10: Using Macros and Sql in Access

What defines the purpose and the structure of an SQL statement?

When a user enters, edits, or deletes data; Access determines that a(n) ________ has occurred.

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

Which event is triggered any time you enter or update data on a form?

Which type of macro executes when an event attached to a control or object occurs?

If your SQL query does not include a WHERE statement, then ___ records will be selected.

Besides an embedded macro, what is the other type of macro?

Microsoft does not use IBMs version of SQL in Access.

When business logic requires the comparison of two or more fields, you need to use what type of macro?

Which of the following is not true about macros which have been converted to VBA?

A(n) ________ data macro can be attached to an event in a form.

Which of the following objects do not appear in the Navigation pane?

Where is the normal location in an SQL statement for the WHERE keyword?

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 a user enters, edits, or deletes data; Access determines that what has occurred?

Table validation rules can only work with one field.

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

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

Structured Query Language is the industry-standard language for defining, manipulating, and retrieving the ________ in a database.

Access creates macros automatically when you add certain controls to forms or reports.