Question 1

After you create a macro,you initiate all its tasks by running it.

Accepted Answer

A) True 
 B)False  True

Question 2

Macros can be converted to VBA.

Accepted Answer

A) True 
 B)False  True

Question 3

What can data macros be used for?

Accepted Answer

Validate and ensure the accuracy of data in a table.

Question 4

When you close a form or a report,the On Close event is triggered and Access executes the steps stored in the macro associated with the On Close event.

Accepted Answer

A) True 
 B)False

Question 5

The ________ keyword instructs Access to return the specific fields from one or more tables or queries.

Accepted Answer

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

Question 6

A(n)________ is a database object that you create and use independently of other controls or objects.

Accepted Answer

A)  stand-alone macro 
B)  procedure macro 
C)  embedded macro 
D)  command macro 
A)  stand-alone macro 
B)  procedure macro 
C)  embedded macro 
D)  command macro

Question 7

SQL is the data retrieval and data manipulation language of all the industry-leading databases.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following examples is NOT an event attached to an object?

Accepted Answer

A)  On Close 
B)  After Update 
C)  On Click 
D)  Select 
A)  On Close 
B)  After Update 
C)  On Click 
D)  Select

Question 9

A(n)________ macro is created independently of other controls or objects and displays as an object in the Navigation Pane.

Accepted Answer

stand-alon

Question 10

Which type of events trigger data macros?

Accepted Answer

A)  Table events 
B)  Report events 
C)  Form events 
D)  Query events 
A)  Table events 
B)  Report events 
C)  Form events 
D)  Query events

Question 11

All SQL statements must end with a:

Accepted Answer

A)  semi-colon (;). 
B)  colon (:). 
C)  question mark (?). 
D)  bracket({}). 
A)  semi-colon (;). 
B)  colon (:). 
C)  question mark (?). 
D)  bracket({}).

Question 12

In a SELECT statement,field names are listed after the SELECT statement and are separated by commas.

Accepted Answer

A) True 
 B)False

Question 13

On Close is an example of a(n):

Accepted Answer

A)  event attached to an object. 
B)  event After Update. 
C)  update event. 
D)  new action. 
A)  event attached to an object. 
B)  event After Update. 
C)  update event. 
D)  new action.

Question 14

A ________ is a series of actions that can be programmed to automate tasks.

Accepted Answer

A)  macro 
B)  table 
C)  form 
D)  report 
A)  macro 
B)  table 
C)  form 
D)  report

Question 15

The SQL ________ keyword is used to sort the records by a certain field in either ascending or descending order.

Accepted Answer

The answer of The SQL ________ keyword is used to...

Question 16

The ORDER BY keyword is used to sort the records by a certain field.

Accepted Answer

A) True 
 B)False

Question 17

A(n)________ attaches programming logic to tables.

Accepted Answer

A)  data macros 
B)  stand-alone macros 
C)  embedded macros 
D)  event-driven macros 
A)  data macros 
B)  stand-alone macros 
C)  embedded macros 
D)  event-driven macros

Question 18

After Update and On Click are examples of a(n)________ that would execute an embedded macro.

Accepted Answer

The answer of After Update and On Click are examples...

Question 19

Access provides two methods of programming creating macros and creating procedures using Visual Basic Applications.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is NOT a method for adding actions to a macro with the Macro Designer?

Accepted Answer

A)  Add a command button to a New Action command. 
B)  Click the Add New Action and choose the action you want to add to your macro. 
C)  Type the action name directly into the Add New Action box. 
D)  Locate an action in the Action Catalog and double-click it to add it to the macro. 
A)  Add a command button to a New Action command. 
B)  Click the Add New Action and choose the action you want to add to your macro. 
C)  Type the action name directly into the Add New Action box. 
D)  Locate an action in the Action Catalog and double-click it to add it to the macro.

Exam 22: Using Macros and SQL in Access: Advanced Techniques

After you create a macro,you initiate all its tasks by running it.

Macros can be converted to VBA.

What can data macros be used for?

When you close a form or a report,the On Close event is triggered and Access executes the steps stored in the macro associated with the On Close event.

The ________ keyword instructs Access to return the specific fields from one or more tables or queries.

A(n)________ is a database object that you create and use independently of other controls or objects.

SQL is the data retrieval and data manipulation language of all the industry-leading databases.

Which of the following examples is NOT an event attached to an object?

A(n)________ macro is created independently of other controls or objects and displays as an object in the Navigation Pane.

Which type of events trigger data macros?

All SQL statements must end with a:

In a SELECT statement,field names are listed after the SELECT statement and are separated by commas.

On Close is an example of a(n):

A ________ is a series of actions that can be programmed to automate tasks.

The SQL ________ keyword is used to sort the records by a certain field in either ascending or descending order.

The ORDER BY keyword is used to sort the records by a certain field.

A(n)________ attaches programming logic to tables.

After Update and On Click are examples of a(n)________ that would execute an embedded macro.

Access provides two methods of programming creating macros and creating procedures using Visual Basic Applications.

Which of the following is NOT a method for adding actions to a macro with the Macro Designer?

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters