FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Automating Tasks With Macros

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

A) ApplyFilter
B) GoToControl
C) FindRecord
D) SelectObject

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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?

A) lName
B) Lname
C) LastName
D) Last Name

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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

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

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

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?

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

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

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

A button that performs an action when the user clicks on the button is a(n) ____ 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. 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.

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

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

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

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

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?

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

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.