Exam 40: Using Macros and SQL in Access: Hands On Exercise Videos

A(n)________ macro can be used to intercept and change incorrectly entered data before it is added to a table.

A named macro is displayed as an object in the Navigation Pane.

You must end very SQL statement with a ________.

Which SQL SELECT statement determines the criteria for the rows that appear in the results?

Which of the following events CANNOT be used as a trigger for a macro?

A named macro can be used to send an e-mail message when a form is used to change an entry in a table.

You use the Macro Wizard to create and edit macros.

SQL stands for Sequential Query Language.

You can only create data macros from within a table.

Which of the following is NOT a SQL SELECT keyword?

Which of the following events is NOT a type of macro that can be created in Access?

You can use the Macro ________ to edit a macro.

A command button is triggered by the On Click event.

A(n)________ macro can be attached to a command button control on a form.

A(n)________ macro can be designed to automatically open several tables,forms,or reports.

You can use an SQL statement in place of a table or query record source.