Deck 22: Using Macros and SQL in Access: Advanced Techniques

Question 1

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

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

Answer 1

A

Question 2

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

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

Answer 2

A

Question 3

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

Answer 3

A

Question 4

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 5

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 6

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 7

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 8

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

Question 9

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 10

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

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

Question 11

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 12

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 13

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 14

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 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)________ attaches programming logic to tables.

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

Question 17

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

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

Question 18

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

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

Question 19

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 20

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 21

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 22

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 23

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

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

Question 24

All SQL statements must end with a:

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

Question 25

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

Question 26

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

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

Question 27

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

Question 28

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 29

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 30

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

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 33

Most SQL statements begin with ________ and end with ________.

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

Question 34

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 35

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 36

Which SQL statement determines how the rows will be sorted?

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

Question 37

Which type of events trigger data macros?

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

Question 38

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 39

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

Question 40

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 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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 52

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

Question 53

The WHERE keyword specifies how the rows will be sorted.

Question 54

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

Question 55

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

Question 56

Action queries each have their equivalent SQL keywords and syntax.

Question 57

Data macros can only be used with report events.

Question 58

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

Question 59

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

Question 60

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

Question 62

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

Question 63

The Macro Designer enables you to create and edit macros.

Question 64

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

Question 65

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

Question 66

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 67

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

Question 68

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 69

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

Question 70

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

Question 71

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 73

Data macros attach programming logic to tables.

Question 74

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

Question 75

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

Question 77

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

Question 78

Macros can be converted to VBA.

Question 79

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

Question 80

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