Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

The Macro Designer enables you to create and edit macros.

Accepted Answer

A) True 
 B)False  True

Question 3

Data macros can only be used with what event?

Accepted Answer

Table events

Question 4

If you have to perform a repetitive task in Access,you may consider building a(n)________ to automate the task.

Accepted Answer

The answer of If you have to perform a repetitive...

Question 5

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 6

A(n)________ is a variable,constant,or expression that is needed to produce the output for an action.

Accepted Answer

A) argument 
B) message 
C) beep 
D) title 
A) argument 
B) message 
C) beep 
D) title

Question 7

________ 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 8

Which type of events trigger data macros?

Accepted Answer

A) Table events 
B) Report events 
C) Form events 
D) Query events 
A) Table events 
B) Report events 
C) Form events 
D) Query events

Question 9

How do you attach a macro to an event?

Accepted Answer

You can add a command button c

Question 10

What can data macros be used for?

Accepted Answer

Validate and ensure

Question 11

A(n)________ is a database object that you create and use independently of other controls or objects.

Accepted Answer

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

Question 12

Once a macro has been created,you should ________ to initiate the tasks.

Accepted Answer

A) run the macro 
B) convert the macro 
C) display the macro 
D) control the macro 
A) run the macro 
B) convert the macro 
C) display the macro 
D) control the macro

Question 13

A(n)________ is a variable,constant,or expression that is needed to produce the output for an action.

Accepted Answer

A) argument 
B) description 
C) explanation 
D) message 
A) argument 
B) description 
C) explanation 
D) message

Question 14

Which of the following inherits the logic of the table?

Accepted Answer

A) A form based on a table that contains a data macro 
B) A report based on a table that contains a data macro 
C) A query based on a table that contains a data macro 
D) An imported table that contains similar data 
A) A form based on a table that contains a data macro 
B) A report based on a table that contains a data macro 
C) A query based on a table that contains a data macro 
D) An imported table that contains similar data

Question 15

Which type of macro can only be used with table events?

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 16

Data macros,like stand-alone macros and embedded macros,use the Macro Designer.

Accepted Answer

A) True 
 B)False

Question 17

Macros can be converted to VBA.

Accepted Answer

A) True 
 B)False

Question 18

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 19

Which SQL keyword specifies the table (or tables)that will be searched?

Accepted Answer

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

Question 20

All SQL statements must end with a:

Accepted Answer

A) semi-colon (;). 
B) colon (:). 
C) question mark (?). 
D) bracket({}). 
A) semi-colon (;). 
B) colon (:). 
C) question mark (?). 
D) bracket({}).

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

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

The Macro Designer enables you to create and edit macros.

Data macros can only be used with what event?

If you have to perform a repetitive task in Access,you may consider building a(n)________ to automate the task.

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

A(n)________ is a variable,constant,or expression that is needed to produce the output for an action.

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

Which type of events trigger data macros?

How do you attach a macro to an event?

What can data macros be used for?

A(n)________ is a database object that you create and use independently of other controls or objects.

Once a macro has been created,you should ________ to initiate the tasks.

A(n)________ is a variable,constant,or expression that is needed to produce the output for an action.

Which of the following inherits the logic of the table?

Which type of macro can only be used with table events?

Data macros,like stand-alone macros and embedded macros,use the Macro Designer.

Macros can be converted to VBA.

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.

Which SQL keyword specifies the table (or tables)that will be searched?

All SQL statements must end with a:

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