Question 1

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 2

Once a macro has been created,you should ________ to initiate the tasks.

Accepted Answer

A)  run the macro 
B)  convert the macro 
C)  display the macro 
D)  control the macro 
A)  run the macro 
B)  convert the macro 
C)  display the macro 
D)  control the macro

Question 3

The ________ makes it easier to create and modify macros.

Accepted Answer

The answer of The ________ makes it easier to create...

Question 4

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

Accepted Answer

The answer of If you have to perform a repetitive...

Question 5

What are the two methods of programming with Access?

Accepted Answer

Creating macros and

Question 6

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.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Match between columns
                        Premises: embedded macro
stand-alone macro
data macro
macro

Accepted Answer

The Answer of database object that can be created and is...

Question 10

The Macro Designer enables you to create and edit macros.

Accepted Answer

A) True 
 B)False

Question 11

A(n)________ executes a series of actions when a table event occurs.

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Which SQL statement is used to retrieve data from tables in a database?

Accepted Answer

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

Question 14

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

Accepted Answer

A)  embedded macro 
B)  procedure macro 
C)  stand-alone macro 
D)  command macro 
A)  embedded macro 
B)  procedure macro 
C)  stand-alone macro 
D)  command macro

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Action queries each have their equivalent SQL keywords and syntax.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

Which SQL statement determines how the rows will be sorted?

Once a macro has been created,you should ________ to initiate the tasks.

The ________ makes it easier to create and modify macros.

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

What are the two methods of programming with Access?

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.

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

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

The Macro Designer enables you to create and edit macros.

A(n)________ executes a series of actions when a table event occurs.

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

Which SQL statement is used to retrieve data from tables in a database?

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

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

Action queries each have their equivalent SQL keywords and syntax.

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

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

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

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

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