Question 1

Macros can be converted to VBA.

Accepted Answer

A) True 
 B)False  True

Question 2

________ are the individual steps that make up a macro.

Accepted Answer

Actions

Question 3

If your SQL query does not include a WHERE statement, then ________ records will be selected.

Accepted Answer

all

Question 4

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 5

An embedded macro displays as an object in the Navigation Pane and can be run independently of other objects.

Accepted Answer

A) True 
 B)False

Question 6

You can use the Macro Designer to edit existing macros.

Accepted Answer

A) True 
 B)False

Question 7

Which one of the four keywords in SQL is used to determine how rows will be sorted?

Accepted Answer

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

Question 8

There are two types of macros: stand-alone macros and ________ macros.

Accepted Answer

The answer of There are two types of macros: stand-alone...

Question 9

VBA stands for ________.

Accepted Answer

A)  Virtual Basic for Applications 
B)  Visual Basic for Applications 
C)  Viewable Basic for Applications 
D)  Viewable Basics for Application 
A)  Virtual Basic for Applications 
B)  Visual Basic for Applications 
C)  Viewable Basic for Applications 
D)  Viewable Basics for Application

Question 10

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

Accepted Answer

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

Question 11

Besides an embedded macro, what is the other type of macro?

Accepted Answer

A)  Included 
B)  Automated 
C)  Stand-alone 
D)  Inserted 
A)  Included 
B)  Automated 
C)  Stand-alone 
D)  Inserted

Question 12

Macros allow more complex functionality than just using VBA.

Accepted Answer

A) True 
 B)False

Question 13

When you add an action to a macro and that action has several arguments, each of the arguments are required.

Accepted Answer

A) True 
 B)False

Question 14

Where is the normal location in an SQL statement for the WHERE keyword?

Accepted Answer

A)  Before the FROM keyword 
B)  First 
C)  After the FROM keyword 
D)  Before the SELECT keyword 
A)  Before the FROM keyword 
B)  First 
C)  After the FROM keyword 
D)  Before the SELECT keyword

Question 15

Which is not an argument for the MessageBox action?

Accepted Answer

A)  Message 
B)  Beep 
C)  Title 
D)  Repeat check box 
A)  Message 
B)  Beep 
C)  Title 
D)  Repeat check box

Question 16

When you create a command button, an embedded macro is automatically created.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not correct about queries and SQL?

Accepted Answer

A)  Access stores SQL statements in the background. 
B)  When you create a query, Access creates the SQL statements automatically. 
C)  SQL helps you ask a question of the data in your database. 
D)  SQL uses the same command set as VBA, except that it is used for queries instead of macros. 
A)  Access stores SQL statements in the background. 
B)  When you create a query, Access creates the SQL statements automatically. 
C)  SQL helps you ask a question of the data in your database. 
D)  SQL uses the same command set as VBA, except that it is used for queries instead of macros.

Question 18

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.

Question 19

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 20

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

Macros can be converted to VBA.

________ are the individual steps that make up a macro.

If your SQL query does not include a WHERE statement, then ________ records will be selected.

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

An embedded macro displays as an object in the Navigation Pane and can be run independently of other objects.

You can use the Macro Designer to edit existing macros.

Which one of the four keywords in SQL is used to determine how rows will be sorted?

There are two types of macros: stand-alone macros and ________ macros.

VBA stands for ________.

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

Besides an embedded macro, what is the other type of macro?

Macros allow more complex functionality than just using VBA.

When you add an action to a macro and that action has several arguments, each of the arguments are required.

Where is the normal location in an SQL statement for the WHERE keyword?

Which is not an argument for the MessageBox action?

When you create a command button, an embedded macro is automatically created.

Which of the following is not correct about queries and SQL?

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

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 is the default sort order when using the ORDER BY keyword?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Filters

Exam 11: Enhanced Database Techniques

Macros can be converted to VBA.

________ are the individual steps that make up a macro.

If your SQL query does not include a WHERE statement, then ________ records will be selected.

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

An embedded macro displays as an object in the Navigation Pane and can be run independently of other objects.

You can use the Macro Designer to edit existing macros.

Which one of the four keywords in SQL is used to determine how rows will be sorted?

There are two types of macros: stand-alone macros and ________ macros.

VBA stands for ________.

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

Besides an embedded macro, what is the other type of macro?

Macros allow more complex functionality than just using VBA.

When you add an action to a macro and that action has several arguments, each of the arguments are required.

Where is the normal location in an SQL statement for the WHERE keyword?

Which is not an argument for the MessageBox action?

When you create a command button, an embedded macro is automatically created.

Which of the following is not correct about queries and SQL?

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

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 is the default sort order when using the ORDER BY keyword?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Filters