Question 1

Which of the following is NOT a reason for using an SQL statement for a record source?

Accepted Answer

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

All SQL statements must end with a:

Accepted Answer

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

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

The ________ makes it easier to create and modify macros.

Accepted Answer

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

Question 7

You can use the Macro ________ to edit a macro.

Accepted Answer

A)  Analyzer 
B)  Documenter 
C)  Designer 
D)  Wizard 
A)  Analyzer 
B)  Documenter 
C)  Designer 
D)  Wizard

Question 8

A(n) ________ attaches programming logic to tables.

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 9

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.

Accepted Answer

A) True 
 B)False

Question 10

SQL stands for Sequential Query Language.

Accepted Answer

A) True 
 B)False

Question 11

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 12

What are the two methods of programming used by Access?

Accepted Answer

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

A named macro can be used to send an e-mail message when a form is used to change an entry in a table.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Macros can be converted to VBA.

Accepted Answer

A) True 
 B)False

Question 18

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 19

SELECT, FROM, WHERE, and ORDER BY are examples or a(n) ________.

Accepted Answer

The answer of SELECT, FROM, WHERE, and ORDER BY are...

Question 20

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

Which of the following is NOT a reason for using an SQL statement for a record source?

All SQL statements must end with a:

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

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

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

The ________ makes it easier to create and modify macros.

You can use the Macro ________ to edit a macro.

A(n) ________ attaches programming logic to tables.

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.

SQL stands for Sequential Query Language.

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

What are the two methods of programming used by Access?

A named macro can be used to send an e-mail message when a form is used to change an entry in a table.

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

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

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

Macros can be converted to VBA.

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

SELECT, FROM, WHERE, and ORDER BY are examples or a(n) ________.

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

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

Which of the following is NOT a reason for using an SQL statement for a record source?

All SQL statements must end with a:

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

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

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

The ________ makes it easier to create and modify macros.

You can use the Macro ________ to edit a macro.

A(n) ________ attaches programming logic to tables.

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.

SQL stands for Sequential Query Language.

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

What are the two methods of programming used by Access?

A named macro can be used to send an e-mail message when a form is used to change an entry in a table.

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

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

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

Macros can be converted to VBA.

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

SELECT, FROM, WHERE, and ORDER BY are examples or a(n) ________.

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

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