Deck 40: Using Macros and SQL in Access: Hands On Exercise Videos

Question 1

A(n)________ macro can be designed to automatically open several tables,forms,or reports.

A)internal
B)independent
C)stand-alone
D)embedded

Answer 1

C

Question 2

A(n)________ macro can be used to intercept and change incorrectly entered data before it is added to a table.

A)embedded
B)data
C)independent
D)dependent

Answer 2

B

Question 3

You can only create data macros from within a table.

Answer 3

True

Question 4

A named macro is displayed as an object in the Navigation Pane.

Question 5

Which of the following is NOT a SQL SELECT keyword?

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

Question 6

You can use the Macro ________ to edit a macro.

A)Analyzer
B)Documenter
C)Designer
D)Wizard

Question 7

SQL stands for Sequential Query Language.

Question 8

You use the Macro Wizard to create and edit macros.

Question 9

Which of the following events CANNOT be used as a trigger for a macro?

A)On Click
B)Before Change
C)After Update
D)While Open

Question 10

A named macro can be used to send an e-mail message when a form is used to change an entry in a table.

Question 11

Which of the following events is NOT a type of macro that can be created in Access?

A)stand-alone
B)data
C)embedded
D)encapsulated

Question 12

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

Question 13

A command button is triggered by the On Click event.

Question 14

A(n)________ macro can be attached to a command button control on a form.

A)dependent
B)external
C)embedded
D)stand-alone

Question 15

Which SQL SELECT statement determines the criteria for the rows that appear in the results?

A)WHICH
B)WHO
C)WHERE
D)FROM

Question 16

You must end very SQL statement with a ________.

A)comma (,)
B)period (. )
C)colon (:)
D)semicolon (;)