Question 1

Microsoft has developed its own version of SQL for Access, which varies slightly from the industry standard SQL language.

Accepted Answer

A) True 
 B)False

Question 2

If your query does not include the WHERE keyword, the query will return all records from the table.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Most SQL statements begin with ________ and end with ________.

Accepted Answer

A)  SELECT; semicolon (;) 
B)  SELECT; colon (:) 
C)  ON CLICK; comma (,) 
D)  ORDER BY; period (.) 
A)  SELECT; semicolon (;) 
B)  SELECT; colon (:) 
C)  ON CLICK; comma (,) 
D)  ORDER BY; period (.)

Question 5

The SQL ________ keyword is used to sort the records by a certain field in either ascending or descending order.

Accepted Answer

The answer of The SQL ________ keyword is used to...

Question 6

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 7

The record source of a form or a report in Access can be either a table or a query, depending on the complexity of the data.

Accepted Answer

A) True 
 B)False

Question 8

What are four methods for adding actions to a macro with the Macro Designer?

Accepted Answer

Click the Add New Action arrow and choos

Question 9

Which of the following is NOT a SQL SELECT keyword?

Accepted Answer

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

Question 10

Action queries each have their equivalent SQL keywords and syntax.

Accepted Answer

A) True 
 B)False

Question 11

A command button is triggered by the On Click event.

Accepted Answer

A) True 
 B)False

Question 12

After you create a macro, you initiate all its tasks by running it.

Accepted Answer

A) True 
 B)False

Question 13

Data macros can only be used with what event?

Accepted Answer

The answer of Data macros can only be used with...

Question 14

Which SQL keyword specifies the table (or tables) that will be searched?

Accepted Answer

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

Question 15

The ________ was designed to make it easier to create macros, to modify macros, and to add or delete actions from macros.

Accepted Answer

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

Question 16

What are the two methods for creating an embedded macro?

Accepted Answer

Use a wizard, such as the Command Button

Question 17

A(n) ________ is a database object that you create and use independently of other controls or objects.

Accepted Answer

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

Question 18

A(n) ________ macro can be used to intercept and change incorrectly entered data before it is added to a table.

Accepted Answer

A)  embedded 
B)  data 
C)  independent 
D)  dependent 
A)  embedded 
B)  data 
C)  independent 
D)  dependent

Question 19

A(n) ________ macro is created independently of other controls or objects and displays as an object in the Navigation Pane.

Accepted Answer

stand-alon

Question 20

What can data macros be used for?

Accepted Answer

Validate and ensure

Microsoft has developed its own version of SQL for Access, which varies slightly from the industry standard SQL language.

If your query does not include the WHERE keyword, the query will return all records from the table.

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

Most SQL statements begin with and end with .

The SQL ________ keyword is used to sort the records by a certain field in either ascending or descending order.

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

The record source of a form or a report in Access can be either a table or a query, depending on the complexity of the data.

What are four methods for adding actions to a macro with the Macro Designer?

Which of the following is NOT a SQL SELECT keyword?

Action queries each have their equivalent SQL keywords and syntax.

A command button is triggered by the On Click event.

After you create a macro, you initiate all its tasks by running it.

Data macros can only be used with what event?

Which SQL keyword specifies the table (or tables) that will be searched?

The ________ was designed to make it easier to create macros, to modify macros, and to add or delete actions from macros.

What are the two methods for creating an embedded macro?

A(n) ________ is a database object that you create and use independently of other controls or objects.

A(n) ________ macro can be used to intercept and change incorrectly entered data before it is added to a table.

A(n) ________ macro is created independently of other controls or objects and displays as an object in the Navigation Pane.

What can data macros be used for?

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

Microsoft has developed its own version of SQL for Access, which varies slightly from the industry standard SQL language.

If your query does not include the WHERE keyword, the query will return all records from the table.

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

Most SQL statements begin with ________ and end with ________.

The SQL ________ keyword is used to sort the records by a certain field in either ascending or descending order.

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

The record source of a form or a report in Access can be either a table or a query, depending on the complexity of the data.

What are four methods for adding actions to a macro with the Macro Designer?

Which of the following is NOT a SQL SELECT keyword?

Action queries each have their equivalent SQL keywords and syntax.

A command button is triggered by the On Click event.

After you create a macro, you initiate all its tasks by running it.

Data macros can only be used with what event?

Which SQL keyword specifies the table (or tables) that will be searched?

The ________ was designed to make it easier to create macros, to modify macros, and to add or delete actions from macros.

What are the two methods for creating an embedded macro?

A(n) ________ is a database object that you create and use independently of other controls or objects.

A(n) ________ macro can be used to intercept and change incorrectly entered data before it is added to a table.

A(n) ________ macro is created independently of other controls or objects and displays as an object in the Navigation Pane.

What can data macros be used for?

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

Most SQL statements begin with and end with .