Deck 10: Using Macros and Sql in Access

Question 1

Which of the following is not considered a table event?

A) After Insert
B) After Update
C) During Delete
D) After Delete

Answer 1

C

Question 2

Which is not an argument for the MessageBox action?

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

Answer 2

D

Question 3

What type of macros associate programming logic to tables?

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

Answer 3

A

Question 4

VBA stands for ________.

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

Question 5

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

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

Question 6

What is true about how Access handles macros when there are multiple actions in the macro?

A) They execute in a nested last-in, first-executed mode.
B) They execute according to an established priority list created by the user.
C) They execute according to an established priority list built into Access.
D) They execute in the order in which they display.

Question 7

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

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

Question 8

Which of the following objects do not appear in the Navigation pane?

A) Embedded macros
B) Stand-alone macros
C) Queries
D) Forms

Question 9

What is not a good task for a macro?

A) Group a series of commands into one database object
B) Automate repetitive tasks
C) Perform a specific action
D) Automate a one-time event

Question 10

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

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

Question 11

When business logic requires the comparison of two or more fields, you need to use what type of macro?

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

Question 12

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

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

Question 13

Which of the following is not true about macros which have been converted to VBA?

A) They appear as modules in Access.
B) They do not appear on the Navigation Pane.
C) They appear on the Navigation Pane.
D) The code will perform the same tasks as the original macro.

Question 14

Which event is triggered any time you enter or update data on a form?

A) After Update
B) After Enter
C) After Change
D) After Modification

Question 15

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

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

Question 16

Event-driven data macros are triggered by what events?

A) Table
B) Form
C) Form control
D) Report

Question 17

You can run a named data macro from within another macro by using what action?

A) ExecuteNamedDataMacro
B) ExecuteDataMacro
C) RunDataMacro
D) PerformDataMacro

Question 18

Which type of macro executes when an event attached to a control or object occurs?

A) Stand-alone
B) Included
C) Embedded
D) Automatic

Question 19

When a user enters, edits, or deletes data; Access determines that what has occurred?

A) Event
B) Action
C) Incident
D) Function

Question 20

When an On Close event is triggered and there is no macro attached to the event, what does Access do?

A) It closes the form or report without doing anything.
B) The default On Close macro is run
C) The default Event macro is run.
D) There is no On Close event.

Question 21

What defines the purpose and the structure of an SQL statement?

A) Keyword
B) Definition
C) Code word
D) ScreenTip

Question 22

Which of the following is not considered to be an industry-leading DBMS?

A) SQL Server
B) Alpha database software
C) Oracle
D) SAP Sybase

Question 23

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

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

Question 24

According the chapter, what is the easiest way to learn more advanced 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 25

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

Question 26

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

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

Question 27

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

Question 28

SQL stands for what?

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

Question 29

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

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

Question 30

Which one of the four keywords in SQL is used to specify what table the fields can be found?

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

Question 31

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

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 32

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

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

Question 33

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

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 34

Which one of the four keywords in SQL is used to pick which fields will be in the query?

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

Question 35

When was SQL developed?

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

Question 36

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

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

Question 37

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

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

Question 38

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

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

Question 39

What company developed SQL?

A) Microsoft
B) Apple
C) Adobe
D) IBM

Question 40

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

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

Question 41

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

Question 42

When a user enters, edits, or deletes data; Access determines that a(n) ________ has occurred.

Question 43

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

Question 44

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

Question 45

In SQL, the ________ statement is used to retrieve data from a table.

Question 46

An SQL ________ defines the purpose and the structure of an SQL statement.

Question 47

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

Question 48

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

Question 49

The keyword used in SQL to establish criteria is ________.

Question 50

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

Question 51

A(n) ________ data macro can be attached to an event in a form.

Question 52

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

Question 53

The keyword used in SQL to establish specify the table where the fields can be found is ________.

Question 54

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

Question 55

Structured Query Language is the industry-standard language for defining, manipulating, and retrieving the ________ in a database.

Question 56

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

Question 57

Access creates macros automatically when you add certain controls to forms or reports.

Question 58

A form that is based on a table that contains a(n) ________ macro inherits the logic of the table.

Question 59

Event-driven data macros are triggered by ________ events.

Question 60

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

Question 61

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

Question 62

Table validation rules can only work with one field.

Question 63

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

Question 64

To test a data macro, open the table and perform whatever the event was to which the macro has been attached and see if the proper action is performed.

Question 65

Microsoft does not use IBMs version of SQL in Access.

Question 66

Macros can be converted to VBA.

Question 67

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

Question 68

You can use the Macro Designer to edit existing macros.

Question 69

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

Question 70

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

Question 71

If you drag a table, query, form, or report to the Macro Designer, Access adds an action that opens the table, query, form, or report in edit/design mode.

Question 72

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

Question 73

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

Question 74

Data macros, like stand-alone macros and embedded macros, use the Macro Designer.

Question 75

ExecuteDataMacro is an action that can be chosen in the Macro Designer.

Question 76

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

Question 77

Macros allow more complex functionality than just using VBA.

Question 78

The actions available in the Macro Designer are the same for data macros as for standalone or embedded macros.

Question 79

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

Question 80

When there are multiple actions in a macro, Access executes the actions according to an established priority list.