Deck 11: Enhanced Database Techniques

Question 1

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.

Answer 1

A

Question 2

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

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

Answer 2

C

Question 3

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.

Answer 3

B

Question 4

Event-driven data macros are triggered by what events?

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

Question 5

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 6

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 7

What type of macros associate programming logic to tables?

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

Question 8

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

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

Question 9

Which of the following is not considered a table event?

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

Question 10

VBA stands for ________.

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

Question 11

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

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

Question 12

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 13

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

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

Question 14

Which is not an argument for the MessageBox action?

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

Question 15

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 16

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 17

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

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

Question 18

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

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

Question 19

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

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

Question 20

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 21

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

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

Question 22

SQL stands for what?

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

Question 23

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 24

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 25

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 26

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 27

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

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

Question 28

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 29

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 30

When was SQL developed?

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

Question 31

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 32

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 33

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

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

Question 34

What company developed SQL?

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

Question 35

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 36

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

Question 37

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

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

Question 38

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 39

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

Question 40

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 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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 46

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

Question 47

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

Question 48

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

Question 49

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 50

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

Question 51

You can use the Macro Designer to edit existing macros.

Question 52

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

Question 53

Table validation rules can only work with one field.

Question 54

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

Question 55

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

Question 56

Macros can be converted to VBA.

Question 57

Macros allow more complex functionality than just using VBA.

Question 58

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

Question 59

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

Question 60

Standalone macros are listed in the Navigation Pane.

Question 61

Microsoft uses IBMs version of SQL in Access.

Question 62

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

Question 63

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

Question 64

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

Question 65

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 66

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

Question 67

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

Question 68

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

Question 69

Event-driven data macros are triggered by ________ events.

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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