Deck 11: Enhanced Database Techniques

Question 1

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

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

Answer 1

C

Question 2

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

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

Answer 2

A

Question 3

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

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

Answer 3

C

Question 4

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 5

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 6

Which of the following is not considered a table event?

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

Question 7

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 8

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 9

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

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

Question 10

Which is not an argument for the MessageBox action?

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

Question 11

What type of macros associate programming logic to tables?

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

Question 12

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

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

Question 13

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

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

Question 14

Event-driven data macros are triggered by what events?

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

Question 15

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 16

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

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

Question 17

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 18

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 19

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 20

VBA stands for ________.

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

Question 21

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 22

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 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

What company developed SQL?

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

Question 25

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

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

Question 26

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

Question 27

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 28

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 29

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

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

Question 30

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

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

Question 31

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 32

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

Question 33

SQL stands for what?

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

Question 34

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 35

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 36

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 37

A data macro performs a series of actions when a specific form event occurs.

Question 38

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 39

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

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

Question 40

When was SQL developed?

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

Macros can be converted to VBA.

Question 46

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

Question 47

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

Question 48

Macros allow more complex functionality than just using VBA.

Question 49

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

Question 50

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

Question 51

The On Close event is triggered only if there is a macro attached to it.

Question 52

A standalone macro can be used independent of other controls or objects.

Question 53

Standalone macros are listed in the Navigation Pane.

Question 54

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

Question 55

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

Question 56

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 57

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 58

Table validation rules can only work with one field.

Question 59

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

Question 60

You can use the Macro Designer to edit existing macros.

Question 61

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 62

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

Question 63

Event-driven data macros are triggered by ________ events.

Question 64

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

Question 65

The version of SQL that is found in Access has a graphical user interface to make creating SQL statements much easier.

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

Microsoft uses IBMs version of SQL in Access.

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

Since SQL statements are considered text, you can copy and paste them just like any other text.

Question 77

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

Question 78

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

Question 79

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

Question 80

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