Exam 11: Automating Tasks With Macros

Case-Based Critical Thinking Questions Case 10-1 Elaina is the database administrator for a women's fitness franchise. She has been asked to automate several of the database functions to make it easier for the front desk employees to provide information to clients.  Elaina will create macros to automate the functions. As Elaina continues to automate the database, she discovers that several of her macros are related.  To make maintenance of the database more manageable, she decides to create ____ within a macro to consolidate the related macros.

Images may be used as a background for which of the following objects?

What are some advantages of including submacros in a single macro instead of creating them all as separate macros?

In the accompanying figure, which numbered arrow indicates an event property?

Case-Based Critical Thinking Questions Case 10-1 Elaina is the database administrator for a women's fitness franchise. She has been asked to automate several of the database functions to make it easier for the front desk employees to provide information to clients.  Elaina will create macros to automate the functions. Elaina needs to move the focus to a particular field in the Client form.  Which Access action should she add to the macro?

An object in Access responds to an event, such as clicking on a command button, based on specified event properties.

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

Every system query name begins with the ˜ (tilde) character.____________________

The default orientation for printing a report many be changed using the ____ feature of Access.

A custom form should be tested in ___________________ view before being deployed to end users.

In the SQL statement: SELECT [Name] FROM MSysObjects WHERE [TYPE]=5 AND Left([Name],1) "˜ ORDER BY[NAME]; what does [TYPE]=5 indicate?

In a macro, a phrase is a text description that has no effect on the macro.____________________

Case-Based Critical Thinking Questions Case 10-1 Elaina is the database administrator for a women's fitness franchise. She has been asked to automate several of the database functions to make it easier for the front desk employees to provide information to clients.  Elaina will create macros to automate the functions. In a different macro, Elaina would like to locate the first or next record that meets a specific set of criteria.  Which Access action can be added to the macro that will meet her demand?

A database developer may use either a macro or VBA code to display a user interface for the database.

To hide all arguments for an action, click the Expand Action button in the Collapse/Expand group on the DESIGN tab.____________________

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?

In the accompanying figure, which numbered arrow indicates the name of the selected control on the form?

Which control allows a user to link to an existing file, web page, database object, or email address from a form or report?

In the accompanying figure, which numbered arrow indicates the Action Catalog?

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