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

Question 1

You use the Macro Wizard to create and edit macros.

Answer 1

False

Question 2

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

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

Answer 2

C

Question 3

You can use the Macro ________ to edit a macro.

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

Answer 3

C

Question 4

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

Question 5

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 6

You can only create data macros from within a table.

Question 7

You must end very SQL statement with a ________.

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

Question 8

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 9

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

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

Question 10

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

Question 11

SQL stands for Sequential Query Language.

Question 12

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 13

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

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

Question 14

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

Question 15

Which of the following is NOT a SQL SELECT keyword?

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

Question 16

A command button is triggered by the On Click event.