Question 1

Which one of the four keywords in SQL is used to pick which fields will be in the query?

Accepted Answer

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

Question 2

Macros allow more complex functionality than just using VBA.

Accepted Answer

A) True 
 B)False

Question 3

You can use the Macro Designer to edit existing macros.

Accepted Answer

A) True 
 B)False

Question 4

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 5

The keyword used in SQL to establish specify the table where the fields can be found is ________.

Accepted Answer

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

Question 6

You can run a named data macro from within another macro by using what action?

Accepted Answer

A)  ExecuteNamedDataMacro 
B)  ExecuteDataMacro 
C)  RunDataMacro 
D)  PerformDataMacro 
A)  ExecuteNamedDataMacro 
B)  ExecuteDataMacro 
C)  RunDataMacro 
D)  PerformDataMacro

Question 7

There are two types of macros: stand-alone macros and ________ macros.

Accepted Answer

The answer of There are two types of macros: stand-alone...

Question 8

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

Which one of the four keywords in SQL is used to pick which fields will be in the query?

Macros allow more complex functionality than just using VBA.

You can use the Macro Designer to edit existing macros.

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

The keyword used in SQL to establish specify the table where the fields can be found is ________.

You can run a named data macro from within another macro by using what action?

There are two types of macros: stand-alone macros and ________ macros.

Which of the following is not considered a table event?

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

Which one of the four keywords in SQL is used to pick which fields will be in the query?

Macros allow more complex functionality than just using VBA.

You can use the Macro Designer to edit existing macros.

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

The keyword used in SQL to establish specify the table where the fields can be found is ________.

You can run a named data macro from within another macro by using what action?

There are two types of macros: stand-alone macros and ________ macros.

Which of the following is not considered a table event?

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