Question 1

It is easier to automate tasks by using a VBA procedure than by using macros.

Accepted Answer

A) True 
 B)False

Question 2

Macros can be converted to VBA.

Accepted Answer

A) True 
 B)False

Question 3

In SQL, what is the default sort order when using the ORDER BY keyword?

Accepted Answer

A)  There is no default sort order. 
B)  The order of data entry 
C)  Descending 
D)  Ascending 
A)  There is no default sort order. 
B)  The order of data entry 
C)  Descending 
D)  Ascending

Question 4

The Macro ___ makes it easier to create or modify macros.

Accepted Answer

The answer of The Macro ___ makes it easier to...

Question 5

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

Accepted Answer

The answer of A(n) ________ macro is a database object...

Question 6

Since SQL statements are considered text, you can copy and paste them just like any other text.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

The answer of A(n) ________ is a variable, constant, or...

Question 8

Embedded macros can be attached to an event on a control on a form or to the form itself.

Accepted Answer

A) True 
 B)False

Question 9

You can use the ________ Button Wizard to create an embedded macro automatically.

Accepted Answer

The answer of You can use the ________ Button Wizard...

Question 10

When an On Close event is triggered and there is no macro attached to the event, Access runs its default On Close macro.

Accepted Answer

A) True 
 B)False

Question 11

In SQL, what statement is used to retrieve data from a table?

Accepted Answer

A)  RETRIEVE 
B)  UPDATE 
C)  GET 
D)  SELECT 
A)  RETRIEVE 
B)  UPDATE 
C)  GET 
D)  SELECT

Question 12

Match the following terms with their descriptions:
I. SQL
II. Stand-alone macro
III. Macro
IV. Argument
V. Event
A. Developed by IBM in the early 70s
B. The MessageBox action has four of these
C. Is displayed on the Navigation Pane
D. Occurs when a user enters, edits, or deletes data
E. Automated series of actions

Accepted Answer

The answer of Match the following terms with their descriptions:
I....

Question 13

Business logic describes the policies and procedures established by an organization.

Accepted Answer

A) True 
 B)False

Question 14

What was developed to make it easier to create or modify macros?

Accepted Answer

A)  Macro Creator 
B)  Macro Developer 
C)  Macro Designer 
D)  Visual Basic for Applications (VB
A)  
A)  Macro Creator 
B)  Macro Developer 
C)  Macro Designer 
D)  Visual Basic for Applications (VB
A)

Question 15

What is normally the first SQL keyword in an SQL statement?

Accepted Answer

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

Question 16

A constant used to provide the output for an action is called a(n) ________.

Accepted Answer

A)  function 
B)  argument 
C)  equation 
D)  variable 
A)  function 
B)  argument 
C)  equation 
D)  variable

Question 17

Since data macros can only be associated with table events, they have no impact on forms.

Accepted Answer

A) True 
 B)False

Question 18

Besides a stand-alone macro, what is the other type of macro?

Accepted Answer

A)  Embedded 
B)  Inserted 
C)  Included 
D)  Automated 
A)  Embedded 
B)  Inserted 
C)  Included 
D)  Automated

Question 19

Match the following terms with their descriptions:
I. Event
II. Macro
III. Macro Designer
IV. Embedded macro
V. Data macro
A. Used to automate tasks
B. Executes when an event is triggered
C. Triggered by table events
D. User interface for working with macros
E. Occurs when users open, use, or close forms and reports

Accepted Answer

The answer of Match the following terms with their descriptions:
I....

Question 20

According the chapter, what is the easiest way to learn more advanced SQL statements?

Accepted Answer

A)  Buy the SQL for Dummies book. 
B)  Perform a Google search on advanced SQL statements. 
C)  Experiment; create queries in SQL view, run them, and see what happens. 
D)  Create queries in Design view and then view the SQL statements. 
A)  Buy the SQL for Dummies book. 
B)  Perform a Google search on advanced SQL statements. 
C)  Experiment; create queries in SQL view, run them, and see what happens. 
D)  Create queries in Design view and then view the SQL statements.

It is easier to automate tasks by using a VBA procedure than by using macros.

Macros can be converted to VBA.

In SQL, what is the default sort order when using the ORDER BY keyword?

The Macro ___ makes it easier to create or modify macros.

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

Since SQL statements are considered text, you can copy and paste them just like any other text.

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

Embedded macros can be attached to an event on a control on a form or to the form itself.

You can use the ________ Button Wizard to create an embedded macro automatically.

When an On Close event is triggered and there is no macro attached to the event, Access runs its default On Close macro.

In SQL, what statement is used to retrieve data from a table?

Business logic describes the policies and procedures established by an organization.

What was developed to make it easier to create or modify macros?

What is normally the first SQL keyword in an SQL statement?

A constant used to provide the output for an action is called a(n) ________.

Since data macros can only be associated with table events, they have no impact on forms.

Besides a stand-alone macro, what is the other type of macro?

According the chapter, what is the easiest way to learn more advanced SQL statements?

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Microsoft Office Basics and Functions

Filters

Exam 10: Using Macros and Sql in Access

It is easier to automate tasks by using a VBA procedure than by using macros.

Macros can be converted to VBA.

In SQL, what is the default sort order when using the ORDER BY keyword?

The Macro ___ makes it easier to create or modify macros.

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

Since SQL statements are considered text, you can copy and paste them just like any other text.

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

Embedded macros can be attached to an event on a control on a form or to the form itself.

You can use the ________ Button Wizard to create an embedded macro automatically.

When an On Close event is triggered and there is no macro attached to the event, Access runs its default On Close macro.

In SQL, what statement is used to retrieve data from a table?

Business logic describes the policies and procedures established by an organization.

What was developed to make it easier to create or modify macros?

What is normally the first SQL keyword in an SQL statement?

A constant used to provide the output for an action is called a(n) ________.

Since data macros can only be associated with table events, they have no impact on forms.

Besides a stand-alone macro, what is the other type of macro?

According the chapter, what is the easiest way to learn more advanced SQL statements?

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Microsoft Office Basics and Functions

Filters