Exam 11: Enhanced Database Techniques

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

Which of the following is not considered to be an industry-leading DBMS?

When you create a command button,an embedded macro is automatically created.

The version of SQL that is found in Access has a graphical user interface to make creating SQL statements much easier.

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

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

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

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

In SQL,what statement is used to retrieve data from a table?

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

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

When a user enters,edits,or deletes data; Access determines that what has occurred?

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

Which one of the four keywords in SQL is used to pick which fields will be in the query?

SQL stands for what?

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

Since SQL statements are considered text,you can copy and paste them just like any other text.

Table validation rules can only work with one field.

When business logic requires the comparison of two or more fields,you need to use a(n)________ macro.