Exam 11: 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. As Kirk is completing the interface for Misaki, he notices that the controls on the navigation form are not properly aligned.  To remedy this problem, he will use the Align shortcut menu in Design view for each control and choose the ____ feature from the menu.

A(n) ____ is a piece of data required by an action in a macro.

In the accompanying figure, which numbered arrow indicates the arguments for the MessageBox action?

Which of these Access objects will work as a subform in a navigation form?

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?

In single step mode, the macro may be stopped at any time by clicking the ___ button.

The word or words that appear in the title bar of a message box in a MessageBox action are included in the ____________________ argument.

Which type of form allows the display of database objects using tabs in an organized way to assist users with accessing the different objects.

A database administrator for a large enterprise using Oracle will use ____________________ statements to query, update, delete, and make tables in the DBMS.

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

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.

Access automatically constructs an equivalent SQL statement for queries when the query is created.

Macros may only be run from within a form or report.

Change the text that appears on a command button by changing the ____________________ property on the command button's property sheet.

Briefly explain how to embed submacros, subforms, subqueries, and subreports in macro, form, query, and report Access objects.

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

A button that performs an action when the user clicks on the button is a(n) ____ button.

The SendKeys action available in the Action Catalog when creating a macro is considered to be a trusted action.____________________

The Build button available on a Command button Property Sheet is also called the ____________________ when it is used to work with macros.