Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

The answer of Match the following terms with their meanings:
I....

Question 3

You use the Macro Wizard to create and edit macros.

Accepted Answer

A) True 
 B)False

Question 4

What are the four keywords of an SQL SELECT statement?

Accepted Answer

SELECT, FR

Question 5

After Update and On Click are examples of a(n) ________ that would execute an embedded macro.

Accepted Answer

The answer of After Update and On Click are examples...

Question 6

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

Accepted Answer

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

Question 7

In Access, you can create programming by creating a ________ to automate tasks.

Accepted Answer

The answer of In Access, you can create programming by...

Question 8

Which of the following events is NOT a type of macro that can be created in Access?

Accepted Answer

A)  stand-alone 
B)  data 
C)  embedded 
D)  encapsulated 
A)  stand-alone 
B)  data 
C)  embedded 
D)  encapsulated

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Which SQL statement determines how the rows will be sorted?

Accepted Answer

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

Question 12

What are three reasons for using an SQL statement for a record source?

Accepted Answer

You can create a form or repor

Question 13

A(n) ________ macro can be attached to a command button control on a form.

Accepted Answer

A)  dependent 
B)  external 
C)  embedded 
D)  stand-alone 
A)  dependent 
B)  external 
C)  embedded 
D)  stand-alone

Question 14

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

Accepted Answer

The answer of Match the following SQL keywords with their...

Question 15

Which of the following events CANNOT be used as a trigger for a macro?

Accepted Answer

A)  On Click 
B)  Before Change 
C)  After Update 
D)  While Open 
A)  On Click 
B)  Before Change 
C)  After Update 
D)  While Open

Question 16

The SQL WHERE keyword specifies the:

Accepted Answer

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

Data macros can only be used with report events.

Accepted Answer

A) True 
 B)False

Question 18

Match between columns
                        Premises: argument
event
Macro Designer
SQL SELECT statement
Structured Query Language

Accepted Answer

The Answer of block of text that is used to is...

Question 19

A(n) ________ macro can be designed to automatically open several tables, forms, or reports.

Accepted Answer

A)  internal 
B)  independent 
C)  stand-alone 
D)  embedded 
A)  internal 
B)  independent 
C)  stand-alone 
D)  embedded

Question 20

Which type of events trigger data macros?

Accepted Answer

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

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

You use the Macro Wizard to create and edit macros.

What are the four keywords of an SQL SELECT statement?

After Update and On Click are examples of a(n) ________ that would execute an embedded macro.

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

In Access, you can create programming by creating a ________ to automate tasks.

Which of the following events is NOT a type of macro that can be created in Access?

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

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

Which SQL statement determines how the rows will be sorted?

What are three reasons for using an SQL statement for a record source?

A(n) ________ macro can be attached to a command button control on a form.

Which of the following events CANNOT be used as a trigger for a macro?

The SQL WHERE keyword specifies the:

Data macros can only be used with report events.

A(n) ________ macro can be designed to automatically open several tables, forms, or reports.

Which type of events trigger data macros?

Introduction to Access: Finding Your Way Through an Access Database

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Office Fundamentals and File Management

Filters

Exam 10: Using Macros and Sqlin Access: Advanced Techniques

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

You use the Macro Wizard to create and edit macros.

What are the four keywords of an SQL SELECT statement?

After Update and On Click are examples of a(n) ________ that would execute an embedded macro.

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

In Access, you can create programming by creating a ________ to automate tasks.

Which of the following events is NOT a type of macro that can be created in Access?

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

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

Which SQL statement determines how the rows will be sorted?

What are three reasons for using an SQL statement for a record source?

A(n) ________ macro can be attached to a command button control on a form.

Which of the following events CANNOT be used as a trigger for a macro?

The SQL WHERE keyword specifies the:

Data macros can only be used with report events.

A(n) ________ macro can be designed to automatically open several tables, forms, or reports.

Which type of events trigger data macros?

Introduction to Access: Finding Your Way Through an Access Database

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Office Fundamentals and File Management

Filters