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

Which SQL statement determines how the rows will be sorted?

When does an event occur?

The SELECT keyword instructs Access to return the specific fields from one or more tables or queries.

The ________ makes it easier to create and modify macros.

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

When modifying a macro in the Macro Designer,it is not necessary to save because Access saves automatically.

The easiest way to learn more advanced SQL statements is to create Access queries in Design view and then view the SQL statement in SQL view.

In a SELECT SQL statement,if two fields from two different tables have the same name,what follows the table name prefix?

The ORDER BY keyword is used to sort the records by a certain field.

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

In a SELECT statement,field names are listed after the SELECT statement and are separated by commas.

Which SQL statement sets the criteria for the rows in the results?

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

The WHERE keyword specifies how the rows will be sorted.

A(n)________ executes a series of actions when a table event occurs.

What feature does Access include to aid in creating a macro?

There are three keywords found in a typical SQL SELECT statement: SELECT,FROM,and ORDER BY.

What character is used to select all the fields in a table in the Design view of a query?

On Close is an example of a(n):

After Update and On Click are examples of a(n)________ that would execute an embedded macro.