Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

The answer of A(n) ________ is a variable, constant or...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

The WHERE keyword specifies how the rows will be sorted.

Accepted Answer

A) True 
 B)False

Question 10

When does an event occur?

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

On Close is an example of a(n):

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

A named macro is displayed as an object in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 18

Which SQL SELECT statement determines the criteria for the rows that appear in the results?

Accepted Answer

A)  WHICH 
B)  WHO 
C)  WHERE 
D)  FROM 
A)  WHICH 
B)  WHO 
C)  WHERE 
D)  FROM

Question 19

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

Accepted Answer

A) True 
 B)False

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

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

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

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

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

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

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

The WHERE keyword specifies how the rows will be sorted.

When does an event occur?

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

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

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

On Close is an example of a(n):

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

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

A named macro is displayed as an object in the Navigation Pane.

Which SQL SELECT statement determines the criteria for the rows that appear in the results?

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

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

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

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

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

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

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

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

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

The WHERE keyword specifies how the rows will be sorted.

When does an event occur?

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

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

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

On Close is an example of a(n):

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

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

A named macro is displayed as an object in the Navigation Pane.

Which SQL SELECT statement determines the criteria for the rows that appear in the results?

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

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