FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Automating Tasks With Macros

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

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.

A) 1
B) 3
C) 5
D) 7

E) A) and C)
F) All of the above

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Open
B) Load
C) View
D) Link

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

Matching

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

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

Matching

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

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?

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.

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.

Matching

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.

Matching

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

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

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.

Matching

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?