Question 1

The ________ event is triggered each time you enter data into a field on a form.

Accepted Answer

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

Question 2

Access queries use an Oracle statement behind the scenes to extract data from tables.

Accepted Answer

A) True 
 B)False

Question 3

Microsoft has developed its own version of SQL for Access,which varies slightly from the industry standard SQL language.

Accepted Answer

A) True 
 B)False

Question 4

Most SQL statements begin with SELECT and end with a colon(:).

Accepted Answer

A) True 
 B)False

Question 5

The ________ was designed to make it easier to create macros,to modify macros,and to add or delete actions from macros.

Accepted Answer

A)  Macro Designer 
B)  Macro Maker 
C)  Macro Editor 
D)  Named Data Macro 
A)  Macro Designer 
B)  Macro Maker 
C)  Macro Editor 
D)  Named Data Macro

Question 6

What are the two methods for creating an embedded macro?

Accepted Answer

Use a wizard,such as the Command Button

Question 7

The type of macro that is used to validate and ensure the accuracy of data that is entered into a table is called a(n)________ macro.

Accepted Answer

The answer of The type of macro that is used...

Question 8

When does an event occur?

Accepted Answer

A)  When a user enters, edits or deletes data and when users open, use and close forms and reports 
B)  When the Navigation Pane is displayed and when the macro can be run independently 
C)  When the Navigation Pane is hidden and when the macro can be run independently 
D)  When Access executes steps stored in the table lookup fields 
A)  When a user enters, edits or deletes data and when users open, use and close forms and reports 
B)  When the Navigation Pane is displayed and when the macro can be run independently 
C)  When the Navigation Pane is hidden and when the macro can be run independently 
D)  When Access executes steps stored in the table lookup fields

Question 9

Data macros attach programming logic to tables.

Accepted Answer

A) True 
 B)False

Question 10

Data macros can only be used with what event?

Accepted Answer

The answer of Data macros can only be used with...

Question 11

Like stand-alone macros and embedded macros,what does a data macro use?

Accepted Answer

A)  Macro Designer 
B)  Command Wizard 
C)  Design View 
D)  MessageBox 
A)  Macro Designer 
B)  Command Wizard 
C)  Design View 
D)  MessageBox

Question 12

What do you use to create a stand-alone macro?

Accepted Answer

A)  Macro Designer 
B)  Macro Maker 
C)  Macro Editor 
D)  Named Data Macro 
A)  Macro Designer 
B)  Macro Maker 
C)  Macro Editor 
D)  Named Data Macro

Question 13

MessageBox actions contain the arguments Message,Beep,Type,and Title.

Accepted Answer

A) True 
 B)False

Question 14

Match between columns
                        Premises: WHERE
SELECT
ORDER BY
SQL
FROM

Accepted Answer

The Answer of defines the purpose and the structure of is...

Question 15

________ can be converted to VBA without having to write any complex programming code.

Accepted Answer

A)  Macros 
B)  Tables 
C)  Forms 
D)  Reports 
A)  Macros 
B)  Tables 
C)  Forms 
D)  Reports

Question 16

The easiest way to learn more advanced SQL statements is to create Access queries in Design view and then view the SQL statement in SQL view.

Accepted Answer

A) True 
 B)False

Question 17

A(n)________ is attached to an event of a control on a form or report.

Accepted Answer

A)  embedded macro 
B)  stand-alone macro 
C)  event macro 
D)  property macro 
A)  embedded macro 
B)  stand-alone macro 
C)  event macro 
D)  property macro

Question 18

What is SQL?

Accepted Answer

It is the industry standard la

Question 19

A form based on a table that contains a macro inherits the logic of the table.

Accepted Answer

A) True 
 B)False

Question 20

What is the difference between a stand-alone macro and an embedded macro?

Accepted Answer

A stand-alone macro is a separ

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

The ________ event is triggered each time you enter data into a field on a form.

Access queries use an Oracle statement behind the scenes to extract data from tables.

Microsoft has developed its own version of SQL for Access,which varies slightly from the industry standard SQL language.

Most SQL statements begin with SELECT and end with a colon(:).

The ________ was designed to make it easier to create macros,to modify macros,and to add or delete actions from macros.

What are the two methods for creating an embedded macro?

The type of macro that is used to validate and ensure the accuracy of data that is entered into a table is called a(n)________ macro.

When does an event occur?

Data macros attach programming logic to tables.

Data macros can only be used with what event?

Like stand-alone macros and embedded macros,what does a data macro use?

What do you use to create a stand-alone macro?

MessageBox actions contain the arguments Message,Beep,Type,and Title.

________ can be converted to VBA without having to write any complex programming code.

The easiest way to learn more advanced SQL statements is to create Access queries in Design view and then view the SQL statement in SQL view.

A(n)________ is attached to an event of a control on a form or report.

What is SQL?

A form based on a table that contains a macro inherits the logic of the table.

What is the difference between a stand-alone macro and an embedded macro?

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