Question 1

A named macro is displayed as an object in the Navigation Pane.

Accepted Answer

A) True 
 B)False  False

Question 2

A command button is triggered by the On Click event.

Accepted Answer

A) True 
 B)False  True

Question 3

A(n)________ macro can be designed to automatically open several tables,forms,or reports.

Accepted Answer

A)  internal 
B)  independent 
C)  stand-alone 
D)  embedded 
A)  internal 
B)  independent 
C)  stand-alone 
D)  embedded C

Question 4

Which of the following events is NOT a type of macro that can be created in Access?

Accepted Answer

A)  stand-alone 
B)  data 
C)  embedded 
D)  encapsulated 
A)  stand-alone 
B)  data 
C)  embedded 
D)  encapsulated

Question 5

Which of the following is NOT a SQL SELECT keyword?

Accepted Answer

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

Question 6

A named macro can be used to send an e-mail message when a form is used to change an entry in a table.

Accepted Answer

A) True 
 B)False

Question 7

You can use an SQL statement in place of a table or query record source.

Accepted Answer

A) True 
 B)False

Question 8

Which SQL SELECT statement determines the criteria for the rows that appear in the results?

Accepted Answer

A)  WHICH 
B)  WHO 
C)  WHERE 
D)  FROM 
A)  WHICH 
B)  WHO 
C)  WHERE 
D)  FROM

Question 9

You must end very SQL statement with a ________.

Accepted Answer

A)  comma (,) 
B)  period (.) 
C)  colon (:) 
D)  semicolon (;) 
A)  comma (,) 
B)  period (.) 
C)  colon (:) 
D)  semicolon (;)

Question 10

Which of the following events CANNOT be used as a trigger for a macro?

Accepted Answer

A)  On Click 
B)  Before Change 
C)  After Update 
D)  While Open 
A)  On Click 
B)  Before Change 
C)  After Update 
D)  While Open

Question 11

You can use the Macro ________ to edit a macro.

Accepted Answer

A)  Analyzer 
B)  Documenter 
C)  Designer 
D)  Wizard 
A)  Analyzer 
B)  Documenter 
C)  Designer 
D)  Wizard

Question 12

You can only create data macros from within a table.

Accepted Answer

A) True 
 B)False

Question 13

SQL stands for Sequential Query Language.

Accepted Answer

A) True 
 B)False

Question 14

A(n)________ macro can be used to intercept and change incorrectly entered data before it is added to a table.

Accepted Answer

A)  embedded 
B)  data 
C)  independent 
D)  dependent 
A)  embedded 
B)  data 
C)  independent 
D)  dependent

Question 15

You use the Macro Wizard to create and edit macros.

Accepted Answer

A) True 
 B)False

Question 16

A(n)________ macro can be attached to a command button control on a form.

Accepted Answer

A)  dependent 
B)  external 
C)  embedded 
D)  stand-alone 
A)  dependent 
B)  external 
C)  embedded 
D)  stand-alone

A named macro is displayed as an object in the Navigation Pane.

A command button is triggered by the On Click event.

A(n)________ macro can be designed to automatically open several tables,forms,or reports.

Which of the following events is NOT a type of macro that can be created in Access?

Which of the following is NOT a SQL SELECT keyword?

A named macro can be used to send an e-mail message when a form is used to change an entry in a table.

You can use an SQL statement in place of a table or query record source.

Which SQL SELECT statement determines the criteria for the rows that appear in the results?

You must end very SQL statement with a ________.

Which of the following events CANNOT be used as a trigger for a macro?

You can use the Macro ________ to edit a macro.

You can only create data macros from within a table.

SQL stands for Sequential Query Language.

A(n)________ macro can be used to intercept and change incorrectly entered data before it is added to a table.

You use the Macro Wizard to create and edit macros.

A(n)________ macro can be attached to a command button control on a form.

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

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

Using Macros and SQL in Access: Advanced Techniques

Filters

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

A named macro is displayed as an object in the Navigation Pane.

A command button is triggered by the On Click event.

A(n)________ macro can be designed to automatically open several tables,forms,or reports.

Which of the following events is NOT a type of macro that can be created in Access?

Which of the following is NOT a SQL SELECT keyword?

A named macro can be used to send an e-mail message when a form is used to change an entry in a table.

You can use an SQL statement in place of a table or query record source.

Which SQL SELECT statement determines the criteria for the rows that appear in the results?

You must end very SQL statement with a ________.

Which of the following events CANNOT be used as a trigger for a macro?

You can use the Macro ________ to edit a macro.

You can only create data macros from within a table.

SQL stands for Sequential Query Language.

A(n)________ macro can be used to intercept and change incorrectly entered data before it is added to a table.

You use the Macro Wizard to create and edit macros.

A(n)________ macro can be attached to a command button control on a form.

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

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

Using Macros and SQL in Access: Advanced Techniques

Filters