Question 1

What are the four keywords of an SQL SELECT statement?

Accepted Answer

SELECT,FRO

Question 2

When you add a macro to an event,Access embeds a macro in the object or control.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

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 6

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 7

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 8

Embedded macros are always attached to an event of a control on a form or report.

Accepted Answer

A) True 
 B)False

Question 9

To run one macro from within another,use the RunDataMacro action.

Accepted Answer

A) True 
 B)False

Question 10

Instead of specifying the individual field names in SQL,you can use the asterisk character (*)to select all of the fields.

Accepted Answer

A) True 
 B)False

Question 11

An SQL SELECT statement is used to retrieve reports from tables in a database.

Accepted Answer

A) True 
 B)False

Question 12

Which SQL statement is used to retrieve data from tables in a database?

Accepted Answer

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

Question 13

What are three reasons for using an SQL statement for a record source?

Accepted Answer

You can create a form or repor

Question 14

The record source of a form or a report in Access can be either a table or a query,depending on the complexity of the data.

Accepted Answer

A) True 
 B)False

Question 15

What are four methods for adding actions to a macro with the Macro Designer?

Accepted Answer

Click the Add New Action arrow and choos

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

SELECT,FROM,WHERE,and ORDER BY are examples or a(n)________.

Accepted Answer

The answer of SELECT,FROM,WHERE,and ORDER BY are examples or a(n)________....

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is NOT a reason for using an SQL statement for a record source?

Accepted Answer

A) You can create a form or report without creating a new query 
B) It is easier to transfer a form or report to another database 
C) You can click the View arrow and select SQL View from the list of options 
D) You can construct the record source of a report at run-time using VBA 
A) You can create a form or report without creating a new query 
B) It is easier to transfer a form or report to another database 
C) You can click the View arrow and select SQL View from the list of options 
D) You can construct the record source of a report at run-time using VBA

Question 20

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

Accepted Answer

A) True 
 B)False

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

What are the four keywords of an SQL SELECT statement?

When you add a macro to an event,Access embeds a macro in the object or control.

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

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

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

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.

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

Embedded macros are always attached to an event of a control on a form or report.

To run one macro from within another,use the RunDataMacro action.

Instead of specifying the individual field names in SQL,you can use the asterisk character (*)to select all of the fields.

An SQL SELECT statement is used to retrieve reports from tables in a database.

Which SQL statement is used to retrieve data from tables in a database?

What are three reasons for using an SQL statement for a record source?

The record source of a form or a report in Access can be either a table or a query,depending on the complexity of the data.

What are four methods for adding actions to a macro with the Macro Designer?

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

SELECT,FROM,WHERE,and ORDER BY are examples or a(n)________.

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

Which of the following is NOT a reason for using an SQL statement for a record source?

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

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

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

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters