Deck 10: Automating Tasks With Macros

Question 1

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

Answer 1

False
comment

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False
Collapse

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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 23

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

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

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

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 26

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

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

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

Question 29

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 30

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 31

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 32

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

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

Question 33

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 34

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 35

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 36

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 37

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 38

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 39

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 40

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 41

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
A SQL keyword after which selection criteria is listed in a SQL SELECT statement.

Question 42

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 43

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 44

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 45

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
A state,condition,or occurrence detectable by Access.

Question 46

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
The action that opens a specified form in a specified view.

Question 47

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 48

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

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

Question 49

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

Question 50

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

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 53

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
The action that displays a message box containing a warning or informational message.

Question 54

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 55

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 56

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

Question 57

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 58

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 59

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
A standard language used in querying,updating,and managing relational databases.

Question 60

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

Question 61

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
An argument for the OpenTable action which specifies the view in which an object opens.

Question 62

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
The action that moves the focus to a specified field or control on the active datasheet or form.

Question 63

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
​Opens a specied form in a specied view

Question 64

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
​Executes one macro action at a time,pausing between actions

Question 65

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
​The instruction that initiates each individual command or keystroke within a macro

Question 66

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
The action that selects a specified object and runs an action that applies to the object.

Question 67

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
​Displays a scrollable list of values

Question 68

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
​Allows you to enter a lter term to lter the list of objects displayed in the Acton Catalog pane

Question 69

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
​A piece of data that is required by an action

Question 70

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
A recorded sequence of commands or keystrokes that can be saved and then executed, or run,by a single action by the user

Question 71

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
​A text description for the benefit of database developers and has no effect on the macro

Question 72

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
​A form with tabs that allows you to display database objects in an organized way to users

Question 73

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
A SQL keyword after which the tables used in a query are listed in a SQL SELECT statement.

Question 74

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
The action that selects and runs a command on the ribbon.

Question 75

a.OpenForm
b.RunMenuCommand
c.message box
d.SelectObject
e.event
f.View Argument
g.WHERE
h.GoToControl
i.FROM
j.SQL
k.Single step
l.Action Catalog button
m.Macro
n.Action
o.OpenForm Action
p.Navigation form
q.List box control
r.Comment
s.Search box
t.Argument
​Toggles to open and close the Action Catalog pane