Deck 10: Using Macros and Sqlin Access: Advanced Techniques

Question 1

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

A) stand-alone macro
B) procedure macro
C) embedded macro
D) command macro

Answer 1

A

Question 2

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

A) macro
B) table
C) form
D) report

Answer 2

A

Question 3

Which of the following examples is NOT an event attached to an object?

A) On Close
B) After Update
C) On Click
D) Select

Answer 3

D

Question 4

When does an event occur?

A) When a user enters, edits or deletes data and when users open, use and close forms and reports
B) When the Navigation Pane is displayed and when the macro can be run independently
C) When the Navigation Pane is hidden and when the macro can be run independently
D) When Access executes steps stored in the table lookup fields

Question 5

Data macros are used to ensure the accuracy of data in a(n):

A) table.
B) report.
C) embedded macro.
D) stand-alone macro.

Question 6

A(n) ________ executes a series of actions when a table event occurs.

A) data macro
B) stand-alone macro
C) embedded macro
D) event-driven macro

Question 7

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

A) argument
B) description
C) explanation
D) message

Question 8

What feature does Access include to aid in creating a macro?

A) Macro Designer
B) Macro Editor
C) Macro Maker
D) Named Data Macro

Question 9

________ can be converted to VBA without having to write any complex programming code.

A) Macros
B) Tables
C) Forms
D) Reports

Question 10

A(n) ________ is attached to an event of a control on a form or report.

A) embedded macro
B) stand-alone macro
C) event macro
D) property macro

Question 11

A(n) ________ attaches programming logic to tables.

A) data macros
B) stand-alone macros
C) embedded macros
D) event-driven macros

Question 12

Which of the following is NOT a method for adding actions to a macro with the Macro Designer?

A) Add a command button to a New Action command.
B) Click the Add New Action and choose the action you want to add to your macro.
C) Type the action name directly into the Add New Action box.
D) Locate an action in the Action Catalog and double-click it to add it to the macro.

Question 13

What do you use to create a stand-alone macro?

A) Macro Designer
B) Macro Maker
C) Macro Editor
D) Named Data Macro

Question 14

What are the two methods of programming used by Access?

A) Creating macros and Visual Basic for applications
B) Creating macros and Adobe Acrobat
C) Adobe Acrobat and Visual Basic for Applications
D) Visual Basic for Applications and Hypertext Markup Language

Question 15

Once a macro has been created, you should ________ to initiate the tasks.

A) run the macro
B) convert the macro
C) display the macro
D) control the macro

Question 16

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

A) embedded macro
B) procedure macro
C) stand-alone macro
D) command macro

Question 17

The ________ was designed to make it easier to create macros, to modify macros, and to add or delete actions from macros.

A) Macro Designer
B) Macro Maker
C) Macro Editor
D) Named Data Macro

Question 18

The ________ event is triggered each time you enter data into a field on a form.

A) After Update
B) On Close
C) On Click
D) Select

Question 19

Like stand-alone macros and embedded macros, what does a data macro use?

A) Macro Designer
B) Command Wizard
C) Design View
D) MessageBox

Question 20

What do you use to create a stand-alone macro?

A) Macro Designer
B) An automated task
C) An Embedded macro
D) An event

Question 21

Which SQL statement determines how the rows will be sorted?

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

Question 22

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

A) argument
B) message
C) beep
D) title

Question 23

Which type of macro can only be used with table events?

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

Question 24

What character is used to select all the fields in a table in the Design view of a query?

A) Asterisk character (*)
B) Number sign (#)
C) At symbol (@)
D) Ampersand (&)

Question 25

Macros can be converted to VBA without having to write any complex programming code.

Question 26

All SQL statements must end with a:

A) semi-colon (;).
B) colon (:).
C) question mark (?).
D) bracket({}).

Question 27

Access provides two methods of programming creating macros and creating procedures using Visual Basic Applications.

Question 28

After you create a macro, you initiate all its tasks by running it.

Question 29

Which SQL keyword specifies the table (or tables) that will be searched?

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

Question 30

Which SQL statement sets the criteria for the rows in the results?

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

Question 31

Which of the following inherits the logic of the table?

A) A form based on a table that contains a data macro
B) A report based on a table that contains a data macro
C) A query based on a table that contains a data macro
D) An imported table that contains similar data

Question 32

In a SELECT SQL statement, if two fields from two different tables have the same name, what follows the table name prefix?

A) Dot (.)
B) Comma (,)
C) Apostrophe (')
D) Quotation marks (")

Question 33

Which of the following is NOT a reason for using an SQL statement for a record source?

A) You can create a form or report without creating a new query
B) It is easier to transfer a form or report to another database
C) You can click the View arrow and select SQL View from the list of options
D) You can construct the record source of a report at run-time using VBA

Question 34

The ________ keyword instructs Access to return the specific fields from one or more tables or queries.

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

Question 35

The SQL WHERE keyword specifies the:

A) criteria that records must match to be included in the results.
B) table that will be searched.
C) specific field to be included in the query.
D) specific fields to include in the query.

Question 36

On Close is an example of a(n):

A) event attached to an object.
B) event After Update.
C) update event.
D) new action.

Question 37

All Access queries use ________ behind the scenes to extract data from tables.

A) SQL statement
B) Oracle statement
C) Sybase statement
D) Structured statement

Question 38

Most SQL statements begin with ________ and end with ________.

A) SELECT; semicolon (;)
B) SELECT; colon (:)
C) ON CLICK; comma (,)
D) ORDER BY; period (.)

Question 39

Which type of events trigger data macros?

A) Table events
B) Report events
C) Form events
D) Query events

Question 40

Which SQL statement is used to retrieve data from tables in a database?

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

Question 41

Instead of specifying the individual field names in SQL, you can use the asterisk character (*) to select all of the fields.

Question 42

Data macros can be accessed from anywhere in the database, including running them from within another macro.

Question 43

In a SELECT statement, field names are listed after the SELECT statement and are separated by commas.

Question 44

There are three keywords found in a typical SQL SELECT statement: SELECT, FROM, and ORDER BY.

Question 45

An SQL keyword defines the purpose and the structure of a SQL statement.

Question 46

The SELECT keyword instructs Access to return the specific fields from one or more tables or queries.

Question 47

The ORDER BY keyword is used to sort the records by a certain field.

Question 48

An SQL SELECT statement is used to retrieve reports from tables in a database.

Question 49

A form based on a table that contains a macro inherits the logic of the table.

Question 50

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

Question 51

Access queries use an Oracle statement behind the scenes to extract data from tables.

Question 52

Microsoft has developed its own version of SQL for Access, which varies slightly from the industry standard SQL language.

Question 53

Data macros can only be used with report events.

Question 54

Action queries each have their equivalent SQL keywords and syntax.

Question 55

SQL is the data retrieval and data manipulation language of all the industry-leading databases.

Question 56

The WHERE keyword specifies how the rows will be sorted.

Question 57

Most SQL statements begin with SELECT and end with a colon(:).

Question 58

The easiest way to learn more advanced SQL statements is to create Access queries in Design view and then view the SQL statement in SQL view.

Question 59

If your query does not include the WHERE keyword, the query will return all records from the table.

Question 60

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

Question 61

The ORDER BY clause must be added to the beginning of an SQL statement after the WHERE clause.

Question 62

When you close a form or a report, the On Close event is triggered and Access executes the steps stored in the macro associated with the On Close event.

Question 63

To run one macro from within another, use the RunDataMacro action.

Question 64

MessageBox actions contain the arguments Message, Beep, Type, and Title.

Question 65

Embedded macros can be used to validate the data in a field or a record.

Question 66

The basic structure of an SQL statement is SELECT, FROM, WHERE, and ORDER BY.

Question 67

If you have to perform a repetitive task in Access, you may consider building a(n) ________ to automate the task.

Question 68

Data macros attach programming logic to tables.

Question 69

Match the following terms with their meanings:
I. macro
II. data macro
III. stand-alone macro
IV. embedded macro
A. executes a series of actions when a table event occurs
B. executes when an event attached to a control or object occurs
C. a series of actions that can be programmed to automate tasks
D. database object that can be created and used independently of other controls or objects

Question 70

Embedded macros are always attached to an event of a control on a form or report.

Question 71

An embedded macro is a database object that you create and use independently of other controls or objects.

Question 72

________ is the industry standard language for defining, manipulating, and retrieving data in a database.

Question 73

Macros can be converted to VBA.

Question 74

One reason for using a SQL statement for a record source is that it is easier to transfer a form or report to another database because the record source is contained in the object.

Question 75

The record source of a form or a report in Access can be either a table or a query, depending on the complexity of the data.

Question 76

When modifying a macro in the Macro Designer, it is not necessary to save because Access saves automatically.

Question 77

Match the following terms with their meanings:
I. argument
II. event
III. Macro Designer
IV. SQL SELECT statement
V. Structured Query Language
A. block of text that is used to retrieve data from the tables in a database
B. user interface that enables you to create and edit macros
C. occurs when a user enters, edits, or deleted data
D. industry-standard language for defining, manipulating, and retrieving data in a database
E. a variable, constant, or expression that is needed to product the output for an action

Question 78

Match the following SQL keywords with their meanings:
I. FROM
II. ORDER BY
III. SELECT
IV. SQL
V. WHERE
A. instructs Access to return the specific fields from one or more tables
B. specifies the table or tables that will be searched
C. specifies the criteria that records must match to be included in the results
D. defines the purpose and the structure of an SQL statement
E. sorts the records by a certain field in either ascending or descending order

Question 79

The Macro Designer enables you to create and edit macros.

Question 80

When you add a macro to an event, Access embeds a macro in the object or control.