Question 1

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 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

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

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 7

What is SQL?

Accepted Answer

It is the industry standard la

Question 8

The Macro Designer enables you to create and edit macros.

Accepted Answer

A) True 
 B)False

Question 9

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 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

How do you attach a macro to an event?

Accepted Answer

You can add a command button c

Question 14

You can only create data macros from within a table.

Accepted Answer

A) True 
 B)False

Question 15

Access provides two methods of programming creating macros and creating procedures using Visual Basic Applications.

Accepted Answer

A) True 
 B)False

Question 16

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 17

Match between columns
                        Premises: macro
data macro
stand-alone macro
embedded macro

Accepted Answer

The Answer of executes a series of actions when a is...

Question 18

Data macros attach programming logic to tables.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

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

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

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

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

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

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

What is SQL?

The Macro Designer enables you to create and edit macros.

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

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.

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

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

How do you attach a macro to an event?

You can only create data macros from within a table.

Access provides two methods of programming creating macros and creating procedures using Visual Basic Applications.

You must end very SQL statement with a ________.

Data macros attach programming logic to tables.

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

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

Introduction to Access: Finding Your Way Through an Access Database

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

Office Fundamentals and File Management

Filters

Exam 10: Using Macros and Sqlin Access: Advanced Techniques

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

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

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

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

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

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

What is SQL?

The Macro Designer enables you to create and edit macros.

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

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.

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

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

How do you attach a macro to an event?

You can only create data macros from within a table.

Access provides two methods of programming creating macros and creating procedures using Visual Basic Applications.

You must end very SQL statement with a ________.

Data macros attach programming logic to tables.

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

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

Introduction to Access: Finding Your Way Through an Access Database

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

Office Fundamentals and File Management

Filters