Question 1

Which of the following objects do not appear in the Navigation Pane?

Accepted Answer

A)  Embedded macros 
B)  Stand-alone macros 
C)  Queries 
D)  Forms 
A)  Embedded macros 
B)  Stand-alone macros 
C)  Queries 
D)  Forms

Question 2

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

Accepted Answer

stand-alon

Question 3

Embedded macros can be attached to an event on a control on a form or to the form itself.

Accepted Answer

A) True 
 B)False

Question 4

Which one of the four keywords in SQL is used to pick which fields will be in the query?

Accepted Answer

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

Question 5

If you drag a table, query, form, or report to the Macro Designer, Access adds an action that opens the table, query, form, or report in edit/design mode.

Accepted Answer

A) True 
 B)False

Question 6

ExecuteDataMacro is an action that can be chosen in the Macro Designer.

Accepted Answer

A) True 
 B)False

Question 7

Event-driven data macros are triggered by ________ events.

Accepted Answer

The answer of Event-driven data macros are triggered by ________...

Question 8

Microsoft uses IBMs version of SQL in Access.

Accepted Answer

A) True 
 B)False

Question 9

What is normally the first SQL keyword in an SQL statement?

Accepted Answer

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

Question 10

It is easier to automate tasks by using a VBA procedure than by using macros.

Accepted Answer

A) True 
 B)False

Question 11

Since SQL statements are considered text, you can copy and paste them just like any other text.

Accepted Answer

A) True 
 B)False

Question 12

When a user enters, edits, or deletes data; Access determines that what has occurred?

Accepted Answer

A)  Event 
B)  Action 
C)  Incident 
D)  Function 
A)  Event 
B)  Action 
C)  Incident 
D)  Function

Question 13

Which of the following is not considered to be an industry-leading DBMS?

Accepted Answer

A)  SQL Server 
B)  Alpha database software 
C)  Oracle 
D)  SAP Sybase 
A)  SQL Server 
B)  Alpha database software 
C)  Oracle 
D)  SAP Sybase

Question 14

A standalone macro can be used independent of other controls or objects.

Accepted Answer

A) True 
 B)False

Question 15

The keyword used in SQL to establish specify the table where the fields can be found is ________.

Accepted Answer

The answer of The keyword used in SQL to establish...

Question 16

A(n) ________ is a series of actions that can be programmed to automate tasks.

Accepted Answer

The answer of A(n) ________ is a series of actions...

Question 17

Which of the four is not considered one of the four basic words in SQL statements?

Accepted Answer

A)  SELECT 
B)  WHERE 
C)  FROM 
D)  SORTED 
A)  SELECT 
B)  WHERE 
C)  FROM 
D)  SORTED

Question 18

Since data macros are connected to tables, they can be attached to events in a form.

Accepted Answer

A) True 
 B)False

Question 19

Since data macros can only be associated with table events, they have no impact on forms.

Accepted Answer

A) True 
 B)False

Question 20

A(n) ________ data macro can be attached to an event in a form.

Accepted Answer

The answer of A(n) ________ data macro can be attached...

Which of the following objects do not appear in the Navigation Pane?

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

Embedded macros can be attached to an event on a control on a form or to the form itself.

Which one of the four keywords in SQL is used to pick which fields will be in the query?

If you drag a table, query, form, or report to the Macro Designer, Access adds an action that opens the table, query, form, or report in edit/design mode.

ExecuteDataMacro is an action that can be chosen in the Macro Designer.

Event-driven data macros are triggered by ________ events.

Microsoft uses IBMs version of SQL in Access.

What is normally the first SQL keyword in an SQL statement?

It is easier to automate tasks by using a VBA procedure than by using macros.

Since SQL statements are considered text, you can copy and paste them just like any other text.

When a user enters, edits, or deletes data; Access determines that what has occurred?

Which of the following is not considered to be an industry-leading DBMS?

A standalone macro can be used independent of other controls or objects.

The keyword used in SQL to establish specify the table where the fields can be found is ________.

A(n) ________ is a series of actions that can be programmed to automate tasks.

Which of the four is not considered one of the four basic words in SQL statements?

Since data macros are connected to tables, they can be attached to events in a form.

Since data macros can only be associated with table events, they have no impact on forms.

A(n) ________ data macro can be attached to an event in a form.

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Filters

Exam 11: Enhanced Database Techniques

Which of the following objects do not appear in the Navigation Pane?

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

Embedded macros can be attached to an event on a control on a form or to the form itself.

Which one of the four keywords in SQL is used to pick which fields will be in the query?

If you drag a table, query, form, or report to the Macro Designer, Access adds an action that opens the table, query, form, or report in edit/design mode.

ExecuteDataMacro is an action that can be chosen in the Macro Designer.

Event-driven data macros are triggered by ________ events.

Microsoft uses IBMs version of SQL in Access.

What is normally the first SQL keyword in an SQL statement?

It is easier to automate tasks by using a VBA procedure than by using macros.

Since SQL statements are considered text, you can copy and paste them just like any other text.

When a user enters, edits, or deletes data; Access determines that what has occurred?

Which of the following is not considered to be an industry-leading DBMS?

A standalone macro can be used independent of other controls or objects.

The keyword used in SQL to establish specify the table where the fields can be found is ________.

A(n) ________ is a series of actions that can be programmed to automate tasks.

Which of the four is not considered one of the four basic words in SQL statements?

Since data macros are connected to tables, they can be attached to events in a form.

Since data macros can only be associated with table events, they have no impact on forms.

A(n) ________ data macro can be attached to an event in a form.

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Filters