Question 1

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

Accepted Answer

In Microsoft Access, the MSysObjects table stores information about database objects. A [TYPE] value of 5 indicates that the object is a query.

Question 2

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

Accepted Answer

The five SQL statement types are SELECT (retrieve data), UPDATE (modify data), DELETE (remove data), INSERT (add data), and CREATE (create database objects). Out of the given choices, option C matches the accurate statement types.

Question 3

Which of the following is an example of an event property?
A)OnClose
B)Input Mask
C)Validation Rule
D)Border Style

Accepted Answer

OnClose is an event property, which is triggered when a form or report is closed.

The other options are not event properties:
B) Input Mask is a control property that determines the format of user input
C) Validation Rule is a control property that specifies a condition that must be met for data to be considered valid
D) Border Style is a control property that determines the appearance of the control's border.

Question 4

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

Accepted Answer

A procedure is a set of VBA statements that can be executed as a unit. By creating a procedure for an event in Access, we can set the event property value to the name of that procedure. When the event occurs, Access will execute the procedure. This approach allows us to write custom code to handle events and automate tasks within our Access database.

Question 5

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

Accepted Answer

The "Stop All Macros" button is used to halt the execution of macros, including when running in single step mode.

Question 6

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

Accepted Answer

Access 2016 provides 6 predefined layouts for navigation forms, allowing users to choose different placements for tabs and subtabs.

Question 7

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

Accepted Answer

Single step mode is used when running a macro one step at a time to verify that arguments are correct and the macro runs appropriately. This allows the user to take their time and ensure that each step is executed properly before moving on to the next one. The other options, Action Catalog and Show All Actions, do not pertain to the question of verifying macro arguments and functionality. All steps mode does not allow for single step verification.

Question 8

A(n)____ is a piece of data required by an action in a macro.
A)code
B)argument
C)message
D)pointer

Accepted Answer

In macros, arguments refer to the variables or pieces of data that are required for an action to be performed. These arguments can be passed to the macro at the time of execution, and they provide the necessary inputs for the macro to work correctly. Therefore, B (argument) is the best choice for the given question.

Question 9

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

Accepted Answer

A button that performs an action when the user clicks on it is a command button. A message button would typically display a message, an action button may perform multiple actions, and a macro button is typically used to automate repetitive tasks.

Question 10

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

Accepted Answer

Clicking on the "clear filter" button removes any search filters and displays all actions in the Action Catalog pane again.

Question 11

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

Accepted Answer

A submacro is a smaller macro within a larger macro. In this case, "OpenBillingTable" is a submacro within the larger macro "mcrLatePayment".

Question 12

In an SQL SELECT statement,fields to be displayed are listed after the keyword ____.
A)WHERE
B)FIELDS
C)SELECT
D)SORT

Accepted Answer

In an SQL SELECT statement, the keyword used to list the fields to be displayed is SELECT. The WHERE keyword is used to filter records, the FIELDS keyword does not exist in SQL, and the SORT keyword is used to sort records in a specific order.

Question 13

Most database developers prefer to prevent inexperienced database users from using which type of query?
A)action
B)cross-tab
C)select
D)parameter

Accepted Answer

Action queries can modify data or database structure, which can lead to unintended consequences if used improperly by inexperienced users.

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

The field name enclosed in square brackets with a space between two words most likely refers to a field name with a space between two words in the selected table. Therefore, the correct field name in this case would be "Last Name" as none of the other options have a space between two words.

Question 16

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

Accepted Answer

In an SQL SELECT statement, tables to be used for the query are listed after the keyword "FROM". The FROM keyword is used to specify the table or tables from which the records will be selected. Therefore, B is the best choice.

Question 17

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

Accepted Answer

Navigation forms allow the display of database objects using tabs to organize them in a user-friendly way, making it easier for users to access and navigate through different objects. Bound forms are used for data entry and display data from a single record, while reports forms are used to present summarized data.

Question 18

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

Accepted Answer

The Macro Designer is the development environment in Access that is used to create, view, and modify macros. It allows users to create automated tasks without the need for extensive programming knowledge. SQL Server is a relational database management system that can be used with Access, but it is not the development environment for macros. Visual Basic can be used in Access for more complex programming tasks but it is not the development environment for macros. ODBC (Open Database Connectivity) is a software interface that allows different databases to communicate with one another but it is not a development environment for macros.

Question 19

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

Accepted Answer

The four sections of a basic SQL statement are SELECT, FROM, WHERE, and ORDER BY, and each section begins with its respective keyword. Therefore, the correct option is A.

Question 20

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

Accepted Answer

The SelectObject action is used to select a specified object, such as a form or a report, so that an action can be run that applies to the object. This action is commonly used in macros and can be helpful for automating repetitive tasks.

Quiz 10: Automating Tasks With Macros

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

Which of the following describe the five SQL statement types?

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

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.

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

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

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(n) ____ is a piece of data required by an action in a macro.

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

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

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

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

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

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

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?

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

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

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

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

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