Question 1

Which of the four is not considered one of the four basic words in SQL statements?

Accepted Answer

A)  SELECT 
B)  WHERE 
C)  FROM 
D)  SORTED

Question 2

When you add a macro to an event, Access embeds a macro in the object or control and lists it on the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 3

SQL stands for what?

Accepted Answer

A)  Structured Query Language 
B)  Structural Query Language 
C)  Simplified Query Language 
D)  Simple Query Language

Question 4

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 5

Since data macros are connected to tables, they cannot be attached to events in a form.

Accepted Answer

A) True 
 B)False

Question 6

When business logic requires the comparison of two or more fields, you need to use a(n) ________ macro.

Accepted Answer

The answer of When business logic requires the comparison of...

Question 7

Which is not an argument for the MessageBox action?

Accepted Answer

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

Question 8

If your SQL query does not include a WHERE statement, then how many records will be selected?

Accepted Answer

A)  All 
B)  None 
C)  Your SQL statement must include a WHERE statement. 
D)  Your query will pause upon execution for user entry, just like a parameter query.

Question 9

What type of macros associate programming logic to tables?

Accepted Answer

A)  Data 
B)  Embedded 
C)  Stand-alone 
D)  Event

Question 10

What type of macros allow companies to apply business logic to a database?

Accepted Answer

A)  Embedded 
B)  Stand-alone 
C)  Data 
D)  Event

Question 11

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

Question 12

Macros can be created to run other macros inside of them.

Accepted Answer

A) True 
 B)False

Question 13

A(n) ________ is a series of actions that can be programmed to automate tasks.

Accepted Answer

The answer of A(n) ________ is a series of actions...

Question 14

Match the SQL keywords at the top with what would follow those words from the list at the bottom to accomplish the following: display three fields (Field1, Field2, Field3) from the Sample table, sorted by Field1 in ascending order, and with only those records where Field2 equals "FrogLegs" and put all those in a new table called "Delicacies".
I. SELECT
II. WHERE
III. ORDER BY
IV. FROM
V. INTO
A. Sample
B. Field2="FrogLegs"
C. Field2 DESC
D. Field1, Field2, Field3
E. Delicacies

Accepted Answer

The answer of Match the SQL keywords at the top...

Question 15

The ________ Update event is triggered any time you enter or update data on a form.

Accepted Answer

The answer of The ________ Update event is triggered any...

Question 16

Which of the following is not an action which can be used in a data macro?

Accepted Answer

A)  DeleteRecord 
B)  SetRecord 
C)  SendEmail 
D)  SetField

Question 17

When was SQL developed?

Accepted Answer

A)  Early 1960s 
B)  Early 1970s 
C)  Late 1970s 
D)  Early 1980s

Question 18

Which one of the four keywords in SQL is used to establish criteria?

Accepted Answer

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

Question 19

Stand-alone macros do not display as objects in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 20

Match the following SQL keywords with their purposes:
I. SELECT
II. FROM
III. WHERE
IV. GROUP BY
V. ORDER BY
A. This is not a SQL keyword.
B. Specifies the sort order of the records
C. Specifies which table or tables contain the necessary fields
D. Specifies any criteria which will be applied to the records
E. Specifies which fields will be displayed

Accepted Answer

The answer of Match the following SQL keywords with their...

Exam 10: Using Macros and Sql in Access

Which of the four is not considered one of the four basic words in SQL statements?

When you add a macro to an event, Access embeds a macro in the object or control and lists it on the Navigation Pane.

SQL stands for what?

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

Since data macros are connected to tables, they cannot be attached to events in a form.

When business logic requires the comparison of two or more fields, you need to use a(n) ________ macro.

Which is not an argument for the MessageBox action?

If your SQL query does not include a WHERE statement, then how many records will be selected?

What type of macros associate programming logic to tables?

What type of macros allow companies to apply business logic to a database?

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

Macros can be created to run other macros inside of them.

A(n) ________ is a series of actions that can be programmed to automate tasks.

The ________ Update event is triggered any time you enter or update data on a form.

Which of the following is not an action which can be used in a data macro?

When was SQL developed?

Which one of the four keywords in SQL is used to establish criteria?

Stand-alone macros do not display as objects in the Navigation Pane.