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

Question 1

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

Answer 1

A

Question 2

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

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 5

A(n)________ attaches programming logic to tables.

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

Question 6

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

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

Question 7

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 8

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 9

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 10

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 11

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

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

Question 12

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 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 do you use to create a stand-alone macro?

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

Question 15

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 16

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 17

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 18

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 19

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 20

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 21

Which SQL statement determines how the rows will be sorted?

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

Question 22

All SQL statements must end with a:

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

Question 23

Most SQL statements begin with ________ and end with ________.

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

Question 24

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

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

Question 25

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 26

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

Question 27

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 28

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 29

Which type of events trigger data macros?

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

Question 30

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

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

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 34

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 35

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 36

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

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

Question 37

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 38

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 39

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 40

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

Question 41

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 42

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

Question 43

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

Question 44

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

Question 45

Data macros can only be used with report events.

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

Action queries each have their equivalent SQL keywords and syntax.

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

The WHERE keyword specifies how the rows will be sorted.

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

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

Question 62

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

Question 63

Data macros attach programming logic to tables.

Question 64

The Macro Designer enables you to create and edit macros.

Question 65

Macros can be converted to VBA.

Question 66

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

Question 67

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 69

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

Question 70

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 71

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

Question 72

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

Question 74

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

Question 75

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

Question 76

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

Question 78

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

Question 79

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 80

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