Exam 10: Automating Tasks With Macros

Case-Based Critical Thinking Questions Case 10-2 Misaki is a new Reservation Specialist for an event rental company. She has asked the database administrator, Kirk, to develop an interface for her to access the database objects she needs because she is not familiar with Access. -Kirk has determined he needs a list box of all of the queries in the database to include in the interface he is developing.  Access maintains special tables that store information about the structure of the objects in the database. The ____ system table, stores information about the names, types, and other characteristics of every object in a database.  Kirk will write an SQL statement that includes information from this table.

Using VBA code, a group of statements may be created that set the event property value to the name of that group of statements; Access will then execute an event ____ when the event occurs.

In a SQL SELECT statement a field name enclosed in square brackets like this [Last Name] most likely refers to which of the following field names from the selected table?

Single step mode remains on for all macros once it is turned on until it is manually turned off.

After searching for a specific action in the Action Catalog pane, all actions may be displayed again by clicking on the ____ button.

Case-Based Critical Thinking Questions Case 10-2 Misaki is a new Reservation Specialist for an event rental company. She has asked the database administrator, Kirk, to develop an interface for her to access the database objects she needs because she is not familiar with Access. -In the SQL SELECT statement, Kirk must identify the object type for queries using code that SQL can interpret.  In the Access system table, the field value for the query object type is ____ and will follow [Type]= in the statement.

The four sections of a basic SQL statement include clauses that begin with which group of keywords?

An Access action that finds the first record (or the next record, if the action is used again)that meets specified criteria.

A macro attached to the OnOpen property in a form will execute its actions each time the form is opened.

Which macro feature is used to run a macro one step at a time to verify that arguments are correct and the macro runs appropriately?

A comment used to describe an action included in a macro must begin with /* .

When Access opens a form or report, the ____ event occurs.

The only arguments available for the Beep argument are Yes or No.

Which of the following is an example of an event property?

Case-Based Critical Thinking Questions Case 10-2 Misaki is a new Reservation Specialist for an event rental company. She has asked the database administrator, Kirk, to develop an interface for her to access the database objects she needs because she is not familiar with Access. -Kirk will use one of the predefined navigation forms available from the ____ in the Forms group on the Create tab to create the navigation form for the interface.