Exam 10: Automating Tasks With Macros

A database developer will usually want to prevent inexperienced users from deleting database records by creating a user interface that sets the Record Selectors property to No on an unbound form that allows the user to choose which query to run.____________________

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

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

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

The development environment in Access that is used to create, view, and modify macros is the ____.

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

To create a navigation form using the Navigation gallery, click on the ____ button on the Create tab.

Access 2016 provides ____ predefined layouts for navigation forms with different layouts for the placement of tabs and subtabs.

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

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

In an SQL SELECT statement, fields to be displayed are listed after the keyword ____.

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 agrees to create the interface.  He realizes that the greatest benefit of the interface is to minimize ____.

It is not possible to drag an action from the Action Catalog to a specific location in the Macro Designer.