Question 1

What are the two methods for creating an embedded macro?

Accepted Answer

Use a wizard,such as the Command Button

Question 2

The basic structure of an SQL statement is SELECT,FROM,WHERE,and ORDER BY.

Accepted Answer

A) True 
 B)False

Question 3

An SQL keyword defines the purpose and the structure of an SQL statement.

Accepted Answer

A) True 
 B)False

Question 4

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 5

________ is the industry standard language for defining,manipulating,and retrieving data in a database.

Accepted Answer

Structured

Question 6

What are the two methods of programming with Access?

Accepted Answer

Creating macros and

Question 7

Match between columns
                        Premises: FROM
WHERE
SELECT
SQL
ORDER BY

Accepted Answer

The Answer of specifies the criteria that records must match is...

Question 8

Most SQL statements begin with ________ and end with ________.

Accepted Answer

A) SELECT;semicolon (;) 
B) SELECT;colon (:) 
C) ON CLICK;comma (,) 
D) ORDER BY;period (. ) 
A) SELECT;semicolon (;) 
B) SELECT;colon (:) 
C) ON CLICK;comma (,) 
D) ORDER BY;period (. )

Question 9

One reason for using a SQL statement for a record source is that it is easier to transfer a form or report to another database because the record source is contained in the object.

Accepted Answer

A) True 
 B)False

Question 10

Data macros are used to ensure the accuracy of data in a(n):

Accepted Answer

A) table. 
B) report. 
C) embedded macro. 
D) stand-alone macro. 
A) table. 
B) report. 
C) embedded macro. 
D) stand-alone macro.

Question 11

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 12

A(n)________ is a macro that executes when an event attached to a control or object occurs.

Accepted Answer

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

Question 13

If your query does not include the WHERE keyword,the query will return all records from the table.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) Macro Designer 
B) An automated task 
C) An Embedded macro 
D) An event 
A) Macro Designer 
B) An automated task 
C) An Embedded macro 
D) An event

Question 15

Data macros can only be used with report events.

Accepted Answer

A) True 
 B)False

Question 16

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 17

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.

Question 18

What are the two methods of programming used by Access?

Accepted Answer

A) Creating macros and Visual Basic for applications 
B) Creating macros and Adobe Acrobat 
C) Adobe Acrobat and Visual Basic for Applications 
D) Visual Basic for Applications and Hypertext Markup Language 
A) Creating macros and Visual Basic for applications 
B) Creating macros and Adobe Acrobat 
C) Adobe Acrobat and Visual Basic for Applications 
D) Visual Basic for Applications and Hypertext Markup Language

Question 19

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 20

A macro that executes when an event attached to a control or object occurs is called a(n)________ macro.

Accepted Answer

The answer of A macro that executes when an event...

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

What are the two methods for creating an embedded macro?

The basic structure of an SQL statement is SELECT,FROM,WHERE,and ORDER BY.

An SQL keyword defines the purpose and the structure of an SQL statement.

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

________ is the industry standard language for defining,manipulating,and retrieving data in a database.

What are the two methods of programming with Access?

Most SQL statements begin with ________ and end with ________.

One reason for using a SQL statement for a record source is that it is easier to transfer a form or report to another database because the record source is contained in the object.

Data macros are used to ensure the accuracy of data in a(n):

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

A(n)________ is a macro that executes when an event attached to a control or object occurs.

If your query does not include the WHERE keyword,the query will return all records from the table.

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

Data macros can only be used with report events.

A(n)________ attaches programming logic to tables.

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

What are the two methods of programming used by Access?

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

A macro that executes when an event attached to a control or object occurs is called a(n)________ macro.

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

Most SQL statements begin with and end with .