Deck 10: Automating Tasks With Macros

Question 1

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

Answer 1

C

Question 2

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 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

In a navigation form, the  lower-level tabs are  displayed with the same  background color as the  active top-level tab. ​

Question 19

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

Question 20

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

Question 21

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 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 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 24

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 25

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 26

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

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

Question 27

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 28

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

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

Question 29

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 30

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 31

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 32

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 33

Access 2016 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 34

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 35

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 36

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

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 39

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 40

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

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

Question 41

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 42

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 43

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 44

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 46

​What are some of the problems in restricting access to Database Objects and prohibiting design changes?

Question 47

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 48

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 49

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

Question 50

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

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 53

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 54

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 55

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 57

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

Question 59

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

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