Deck 11: Automating Tasks With Macros

Question 1

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.____________________

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

In a macro containing submacros, the macro name is separated from the submacro name by a period .____________________

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

Use the Background Color tool to copy the formatting from one control to another.____________________

Question 12

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

Question 13

Edit is the default setting for the Data Mode argument of the OpenTable action.____________________

Question 14

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

Question 15

A semi-colon separates multiple arguments for an action in a macro.____________________

Question 16

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

Question 17

To define the data that is retrieved from a database and how the data is presented, SQL uses the SELECT statement.____________________

Question 18

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

Question 19

It is not possible to create a form without using a table or query object as the source for the form.

Question 20

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

Question 21

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

A) 1
B) 2
C) 3
D) 4

Question 22

The Access action that selects a specified object so that an action can be run that applies to the object.

A) SelectObject
B) Apply Filter
C) OpenForm
D) RunMacro

Question 23

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

A) 1
B) 2
C) 3
D) 4

Question 24

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

A) Expand All
B) search
C) clear filter
D) Undo

Question 25

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

A) OnClose
B) Input Mask
C) Validation Rule
D) Border Style

Question 26

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

A) message
B) command
C) action
D) macro

Question 27

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?

A) Action Catalog
B) Show All Actions
C) single step mode
D) all steps mode

Question 28

In the accompanying figure, which numbered arrow indicates the Build button?

A) 1
B) 2
C) 3
D) 4

Question 29

A ____ is a recorded action, or set of actions that automates repetitive tasks.

A) command
B) macro
C) filter
D) code

Question 30

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

A) 1
B) 2
C) 3
D) 4

Question 31

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

A) code
B) argument
C) message
D) pointer

Question 32

Macros may be selected and run from the Macros group in the Navigation Pane or the ____.

A) Query Wizard
B) Form Wizard
C) Report Design View
D) Run Macro dialog box

Question 33

In the accompanying figure, which numbered arrow indicates that a comment has ended?

A) 1
B) 2
C) 3
D) 4

Question 34

In the accompanying figure, which numbered arrow indicates a comment?

A) 1
B) 2
C) 3
D) 4

Question 35

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.

A) procedure
B) method
C) property
D) action

Question 36

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

Question 37

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

A) SQL server
B) Visual Basic
C) Macro Designer
D) ODBC database

Question 38

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

A) Step
B) Single Step
C) Stop All Macros
D) Continue

Question 39

Which of the following is an example of a submacro within a macro?

A) OnClick.OpenCustomerTable
B) frmInvoice.OnClose
C) tblBilling.ListCustomer
D) mcrLatePayment.OpenBillingTable

Question 40

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

A) 1
B) 2
C) 3
D) 4

Question 41

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

Question 42

In the accompanying figure, the action name for which arguments are shown is the ____ action.

A) OpenQuery
B) Data Entry Operations
C) Program Flow
D) OnClick

Question 43

Unsafe actions available in the Action Catalog when Show All Actions is enabled while creating or modifying a macro are identified by ____.

A) a red exclamation mark
B) the name of the action in red letters
C) an "Unsafe Action" ScreenTip
D) "Trusted" ScreenTip

Question 44

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

A) tables, forms, and reports
B) forms, reports, and controls
C) forms, reports, and queries
D) tables, reports, and queries

Question 45

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

A) 3
B) 5
C) 6
D) 10

Question 46

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

A) Form Layout
B) Report Wizard
C) Pagination
D) Print Preview

Question 47

In the accompanying figure illustrating a SQL SELECT statement, selected field names are separated from the table name which contains the field by a(n) ____.

A) comma
B) period
C) semi-colon
D) equal symbol

Question 48

In the accompanying figure, Access has been programmed to show the results of the action as a(n) ____.

A) Query Name
B) OpenQuery
C) Datasheet
D) frmQueries

Question 49

Most database developers prefer to prevent inexperienced database users from using which type of query?

A) action
B) cross-tab
C) select
D) parameter

Question 50

In an SQL SELECT statement, tables to be used for the query are listed after the keyword ____.

A) WHERE
B) FROM
C) SELECT
D) TABLE

Question 51

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

A) Navigation
B) Form Wizard
C) Form Design
D) Form

Question 52

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

A) WHERE
B) FIELDS
C) SELECT
D) SORT

Question 53

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

A) the statement is selecting query objects in an Access system table
B) the statement would like to display only 5 names
C) the statement is selecting table objects in an Access system table
D) the statement will select records in groups of 5

Question 54

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

A) SELECT, FROM, WHERE, ORDER BY
B) RECORD, TO, WHERE, ORDER BY
C) CREATE, SELECT, FROM, WHERE
D) CREATE, FROM, SELECT, ORDER BY

Question 55

In the accompanying figure, the action is being initiated by what event?

A) OnLoad
B) OnClick
C) OnClose
D) Command3

Question 56

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

A) crosstab queries
B) macros
C) table datasheet
D) select queries

Question 57

Which of the following describe the five SQL statement types?

A) modify, update, delete, insert, create
B) select, modify, remove, insert, create
C) select, update, delete, insert, create
D) remove, update, delete, add, rename

Question 58

In the accompanying figure, which numbered arrow indicates the event to which a submacro has been assigned as a property?

A) 1
B) 2
C) 3
D) 4

Question 59

In the accompanying figure illustrating a SQL SELECT statement, the SELECT statement ends with a(n) ____.

A) comma
B) period
C) semi-colon
D) equal symbol

Question 60

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) bound form
B) data entry form
C) reports form
D) navigation form

Question 61

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

Question 62

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.

A) actions
B) event properties
C) submacros
D) event procedures

Question 63

The ____________________ action finds the first record that meets the criteria specified in the action's argument(s) or the next record if the action is used again.

Question 64

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.
A message box has been included in a macro that runs in the client billing form.  Elaina wants the message box to display this icon
in the message box to get the user's attention.  What does this icon represent?

A) Warning?
B) Warning!
C) Critical
D) Information

Question 65

Single step mode is accessed from the Tools group on the ____________________ tab when in creating or modifying a macro.

Question 66

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 has created a button on the Schedule form that references a macro (mcrOpenScheduleTable) which opens the Schedule table when the button is clicked.  Which event property associated with the button will be assigned the macro name?

A) OnClick
B) OnDblClick
C) OnEnter
D) OnMouseMove

Question 67

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

Question 68

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) SelectObject
B) GoToControl
C) OpenForm
D) FindRecord

Question 69

A user communicates with a computer program using a(n) ____________________.

Question 70

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

A) Navigation control
B) Combo Box control
C) Hyperlink control
D) Toggle Button control

Question 71

Two methods are available to turn off single step mode, one method is to use the Single Step command on the DESIGN tab, the other method is to click the ____________________ button in the Macro Single Step window.

Question 72

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 ____.

A) the user's ability to use the database
B) the information available from the database
C) data being corrupted inadvertently
D) the administration of the database

Question 73

A state, condition, or occurrence detectable by Access is a(n) __________________.

Question 74

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?

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

Question 75

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.

A) USysRibbon
B) MSysObjects
C) MSysQueries
D) MSysSelect

Question 76

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) Align Together
B) To Grid
C) Align Left
D) Stacked

Question 77

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.

A) Form Wizard
B) Form Design button
C) Navigation Gallery
D) Macro button

Question 78

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

Question 79

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

Question 80

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

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