Exam 11: Enhanced Database Techniques

Macros that work with ""user interface"" objects, such as forms, reports, and buttons, are known as ________ macros.

Stand-alone macros display as objects in the Navigation Pane.

Match the SQL keywords at the top with what would follow those words from the list at the bottom to accomplish the following: display three fields (Field1, Field2, Field3) from the Sample table, sorted by Field1 in ascending order, and with only those records where Field2 equals "FrogLegs" and put all those in a new table called "Delicacies". I. SELECT II. WHERE III. ORDER BY IV. FROM V. INTO A. Sample B. Field2="FrogLegs" C. Field2 DESC D. Field1, Field2, Field3 E. Delicacies

A constant used to provide the output for an action is called a(n) ________.

The actions available in the Macro Designer are the same for data macros as for standalone or embedded macros.

A data macro performs a series of actions when a specific form event occurs.

A(n) ________ can be used to automate repetitive tasks or perform specific actions.

The Macro ________ makes it easier to create or modify macros.

What type of macros allow companies to apply business logic to a database?

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

A form that is based on a table that contains a(n) ________ macro inherits the logic of the table.

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

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

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

The ________ Update event is triggered any time you enter or update data on a form.

When an On Close event is triggered and there is no macro attached to the event, what does Access do?

Which one of the four keywords in SQL is used to establish criteria?

Which one of the four keywords in SQL is used to specify what table the fields can be found?

Which of the following is not an action which can be used in a data macro?

The On Close event is triggered only if there is a macro attached to it.