Question 1

What are the four keywords of an SQL SELECT statement?

Accepted Answer

SELECT,FRO

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

You can create a form or repor

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

The ________ wizard can you use to create a macro.

Accepted Answer

The answer of The ________ wizard can you use to...

Question 6

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 7

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

Accepted Answer

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

Question 8

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 expression that...

Question 9

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 10

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

Accepted Answer

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

Question 11

Data macros can only be used with report events.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following inherits the logic of the table?

Accepted Answer

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

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

Accepted Answer

Structured

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

The answer of A macro that executes when an event...

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

The Answer of a variable,constant,or expression that is needed to is...

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

What are the four keywords of an SQL SELECT statement?

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

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

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

The ________ wizard can you use to create a macro.

The SQL WHERE keyword specifies the:

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

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

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

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

Data macros can only be used with report events.

Which of the following inherits the logic of the table?

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

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

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

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

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

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

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

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

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

Filters