Question 1

Data macros, like stand-alone macros and embedded macros, use the Macro Designer.

Accepted Answer

A) True 
 B)False  True

Question 2

Event-driven data macros are triggered by what events?

Accepted Answer

A)  Table 
B)  Form 
C)  Form control 
D)  Report 
A)  Table 
B)  Form 
C)  Form control 
D)  Report A

Question 3

Which of the following is not considered to be an industry-leading DBMS?

Accepted Answer

A)  SQL Server 
B)  Alpha database software 
C)  Oracle 
D)  SAP Sybase 
A)  SQL Server 
B)  Alpha database software 
C)  Oracle 
D)  SAP Sybase B

Question 4

Which one of the four keywords in SQL is used to specify what table the fields can be found?

Accepted Answer

A)  SELECT 
B)  FROM 
C)  WHERE 
D)  ORDER BY 
A)  SELECT 
B)  FROM 
C)  WHERE 
D)  ORDER BY

Question 5

What is not a good task for a macro?

Accepted Answer

A)  Group a series of commands into one database object 
B)  Automate repetitive tasks 
C)  Perform a specific action 
D)  Automate a one-time event 
A)  Group a series of commands into one database object 
B)  Automate repetitive tasks 
C)  Perform a specific action 
D)  Automate a one-time event

Question 6

The actions available in the Macro Designer are the same for data macros as for standalone or embedded macros.

Accepted Answer

A) True 
 B)False

Question 7

An SQL ________ defines the purpose and the structure of an SQL statement.

Accepted Answer

The answer of An SQL ________ defines the purpose and...

Question 8

What company developed SQL?

Accepted Answer

A)  Microsoft 
B)  Apple 
C)  Adobe 
D)  IBM 
A)  Microsoft 
B)  Apple 
C)  Adobe 
D)  IBM

Question 9

If you drag a table, query, form, or report to the Macro Designer, Access adds an action that opens the table, query, form, or report in edit/design mode.

Accepted Answer

A) True 
 B)False

Question 10

The version of SQL that is found in Access has a graphical user interface to make creating SQL statements much easier.

Accepted Answer

A) True 
 B)False

Question 11

An embedded macro displays as an object in the Navigation Pane and can be run independently of other objects.

Accepted Answer

A) True 
 B)False

Question 12

When an On Close event is triggered and there is no macro attached to the event, what does Access do?

Accepted Answer

A)  It closes the form or report without doing anything. 
B)  The default On Close macro is run 
C)  The default Event macro is run. 
D)  There is no On Close event. 
A)  It closes the form or report without doing anything. 
B)  The default On Close macro is run 
C)  The default Event macro is run. 
D)  There is no On Close event.

Question 13

Which of the following is not correct about queries and SQL?

Accepted Answer

A)  Access stores SQL statements in the background. 
B)  When you create a query Access creates the SQL statements automatically. 
C)  SQL helps you ask a question of the data in your database. 
D)  SQL uses the same command set as VBA, except that it is used for queries instead of macros. 
A)  Access stores SQL statements in the background. 
B)  When you create a query Access creates the SQL statements automatically. 
C)  SQL helps you ask a question of the data in your database. 
D)  SQL uses the same command set as VBA, except that it is used for queries instead of macros.

Question 14

VBA stands for ________.

Accepted Answer

A)  Virtual Basic for Applications 
B)  Visual Basic for Applications 
C)  Viewable Basic for Applications 
D)  Viewable Basics for Application 
A)  Virtual Basic for Applications 
B)  Visual Basic for Applications 
C)  Viewable Basic for Applications 
D)  Viewable Basics for Application

Question 15

When there are multiple actions in a macro, Access executes the actions according to an established priority list.

Accepted Answer

A) True 
 B)False

Question 16

What is true about how Access handles macros when there are multiple actions in the macro?

Accepted Answer

A)  They execute in a nested last-in, first-executed mode. 
B)  They execute according to an established priority list created by the user. 
C)  They execute according to an established priority list built into Access. 
D)  They execute in the order in which they display. 
A)  They execute in a nested last-in, first-executed mode. 
B)  They execute according to an established priority list created by the user. 
C)  They execute according to an established priority list built into Access. 
D)  They execute in the order in which they display.

Question 17

The keyword used in SQL to establish criteria is ________.

Accepted Answer

The answer of The keyword used in SQL to establish...

Question 18

ExecuteDataMacro is an action that can be chosen in the Macro Designer.

Accepted Answer

A) True 
 B)False

Question 19

Event-driven data macros are triggered by ________ events.

Accepted Answer

The answer of Event-driven data macros are triggered by ________...

Question 20

Match the following terms with their descriptions:
I. SELECT keyword
II. WHERE keyword
III. ORDER BY keyword
IV. FROM keyword
V. SQL keyword
A. Determines any criteria that will be applied to records in an SQL statement
B. Determines the table or tables which will supply the fields used in an SQL statement
C. Determines the sort order in an SQL statement
D. Determines which fields will be included in an SQL statement
E. Defines the purpose and structure of an SQL statement

Accepted Answer

The answer of Match the following terms with their descriptions:
I....

Data macros, like stand-alone macros and embedded macros, use the Macro Designer.

Event-driven data macros are triggered by what events?

Which of the following is not considered to be an industry-leading DBMS?

Which one of the four keywords in SQL is used to specify what table the fields can be found?

What is not a good task for a macro?

The actions available in the Macro Designer are the same for data macros as for standalone or embedded macros.

An SQL ________ defines the purpose and the structure of an SQL statement.

What company developed SQL?

If you drag a table, query, form, or report to the Macro Designer, Access adds an action that opens the table, query, form, or report in edit/design mode.

The version of SQL that is found in Access has a graphical user interface to make creating SQL statements much easier.

An embedded macro displays as an object in the Navigation Pane and can be run independently of other objects.

When an On Close event is triggered and there is no macro attached to the event, what does Access do?

Which of the following is not correct about queries and SQL?

VBA stands for ________.

When there are multiple actions in a macro, Access executes the actions according to an established priority list.

What is true about how Access handles macros when there are multiple actions in the macro?

The keyword used in SQL to establish criteria is ________.

ExecuteDataMacro is an action that can be chosen in the Macro Designer.

Event-driven data macros are triggered by ________ events.

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Microsoft Office Basics and Functions

Filters

Exam 10: Using Macros and Sql in Access

Data macros, like stand-alone macros and embedded macros, use the Macro Designer.

Event-driven data macros are triggered by what events?

Which of the following is not considered to be an industry-leading DBMS?

Which one of the four keywords in SQL is used to specify what table the fields can be found?

What is not a good task for a macro?

The actions available in the Macro Designer are the same for data macros as for standalone or embedded macros.

An SQL ________ defines the purpose and the structure of an SQL statement.

What company developed SQL?

If you drag a table, query, form, or report to the Macro Designer, Access adds an action that opens the table, query, form, or report in edit/design mode.

The version of SQL that is found in Access has a graphical user interface to make creating SQL statements much easier.

An embedded macro displays as an object in the Navigation Pane and can be run independently of other objects.

When an On Close event is triggered and there is no macro attached to the event, what does Access do?

Which of the following is not correct about queries and SQL?

VBA stands for ________.

When there are multiple actions in a macro, Access executes the actions according to an established priority list.

What is true about how Access handles macros when there are multiple actions in the macro?

The keyword used in SQL to establish criteria is ________.

ExecuteDataMacro is an action that can be chosen in the Macro Designer.

Event-driven data macros are triggered by ________ events.

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Microsoft Office Basics and Functions

Filters