Exam 22: Using Macros and SQL in Access: Advanced Techniques

How do you attach a macro to an event?

If your query does not include the WHERE keyword,the query will return all records from the table.

What are four methods for adding actions to a macro with the Macro Designer?

In Access,you can create programming by creating a ________ to automate tasks.

When you add a macro to an event,Access embeds a macro in the object or control.

Which SQL keyword specifies the table (or tables)that will be searched?

Instead of specifying the individual field names in SQL,you can use the asterisk character (*)to select all of the fields.

Data macros,like stand-alone macros and embedded macros,use the Macro Designer.

Which of the following is NOT a reason for using an SQL statement for a record source?

Most SQL statements begin with ________ and end with ________.

What are the two methods of programming used by Access?

Embedded macros can be used to validate the data in a field or a record.

Macros can be converted to VBA without having to write any complex programming code.

Data macros are used to ensure the accuracy of data in a(n):

What do you use to create a stand-alone macro?

A(n)________ is a variable,constant,or expression that is needed to produce the output for an action.

The WHERE keyword specifies how the rows will be sorted.

The record source of a form or a report in Access can be either a table or a query,depending on the complexity of the data.

SELECT,FROM,WHERE,and ORDER BY are examples or a(n)________.

To run one macro from within another,use the RunDataMacro action.