Question 1

Besides a stand-alone macro,what is the other type of macro?

Accepted Answer

A) Embedded 
B) Inserted 
C) Included 
D) Automated 
A) Embedded 
B) Inserted 
C) Included 
D) Automated

Question 2

Event-driven data macros are triggered by ________ events.

Accepted Answer

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

Question 3

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 4

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 5

Match between columns
                        Premises: INTO
WHERE
ORDER BY
FROM
SELECT

Accepted Answer

The Answer of Field2 DESC and Field1,Field2,Field3 and Sample and is...

Question 6

A data macro performs a series of actions when a specific form event occurs.

Accepted Answer

A) True 
 B)False

Question 7

Which one of the four keywords in SQL is used to determine how rows will be sorted?

Accepted Answer

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

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 your SQL query does not include a WHERE statement,then how many records will be selected?

Accepted Answer

A) All 
B) None 
C) Your SQL statement must include a WHERE statement. 
D) Your query will pause upon execution for user entry,just like a parameter query. 
A) All 
B) None 
C) Your SQL statement must include a WHERE statement. 
D) Your query will pause upon execution for user entry,just like a parameter query.

Question 10

Stand-alone macros display as objects in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 11

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 12

A form that is based on a table that contains a(n)________ macro inherits the logic of the table.

Accepted Answer

The answer of A form that is based on a...

Question 13

The ________ Update event is triggered any time you enter or update data on a form.

Accepted Answer

The answer of The ________ Update event is triggered any...

Question 14

To test a data macro,open the table and perform whatever the event was to which the macro has been attached and see if the proper action is performed.

Accepted Answer

A) True 
 B)False

Question 15

Match between columns
                        Premises: What would need to be done to sort the records in descending order?
What would need to be done to not create the new table?
What would need to be done to change the name of the new database to "Old"?
What would need to be done to sort by the default field?
What would need to be done to delete the criteria?

Accepted Answer

The Answer of ORDER BY Contribution.PayDate DESC and Delete WHERE is...

Question 16

Which of the following is not considered a table event?

Accepted Answer

A) After Insert 
B) After Update 
C) During Delete 
D) After Delete 
A) After Insert 
B) After Update 
C) During Delete 
D) After Delete

Question 17

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 18

When you add an action to a macro and that action has several arguments,each of the arguments are required.

Accepted Answer

A) True 
 B)False

Question 19

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 20

What was developed to make it easier to create or modify macros?

Accepted Answer

A) Macro Creator 
B) Macro Developer 
C) Macro Designer 
D) Visual Basic for Applications (VB
A)  
A) Macro Creator 
B) Macro Developer 
C) Macro Designer 
D) Visual Basic for Applications (VB
A)

Besides a stand-alone macro,what is the other type of macro?

Event-driven data macros are triggered by ________ events.

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

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

A data macro performs a series of actions when a specific form event occurs.

Which one of the four keywords in SQL is used to determine how rows will be sorted?

What company developed SQL?

If your SQL query does not include a WHERE statement,then how many records will be selected?

Stand-alone macros display as objects in the Navigation Pane.

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

A form that is based on a table that contains a(n)________ macro inherits the logic of the table.

The ________ Update event is triggered any time you enter or update data on a form.

To test a data macro,open the table and perform whatever the event was to which the macro has been attached and see if the proper action is performed.

Which of the following is not considered a table event?

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

When you add an action to a macro and that action has several arguments,each of the arguments are required.

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.

What was developed to make it easier to create or modify macros?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Filters

Exam 11: Enhanced Database Techniques

Besides a stand-alone macro,what is the other type of macro?

Event-driven data macros are triggered by ________ events.

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

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

A data macro performs a series of actions when a specific form event occurs.

Which one of the four keywords in SQL is used to determine how rows will be sorted?

What company developed SQL?

If your SQL query does not include a WHERE statement,then how many records will be selected?

Stand-alone macros display as objects in the Navigation Pane.

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

A form that is based on a table that contains a(n)________ macro inherits the logic of the table.

The ________ Update event is triggered any time you enter or update data on a form.

To test a data macro,open the table and perform whatever the event was to which the macro has been attached and see if the proper action is performed.

Which of the following is not considered a table event?

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

When you add an action to a macro and that action has several arguments,each of the arguments are required.

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.

What was developed to make it easier to create or modify macros?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Filters