Question 1

VBA stands for ________.

Accepted Answer

A) Virtual Basic for Applications 
B) Visual Basic for Applications 
C) Viewable Basic for Applications 
D) Viewable Basics for Application 
A) Virtual Basic for Applications 
B) Visual Basic for Applications 
C) Viewable Basic for Applications 
D) Viewable Basics for Application

Question 2

Match between columns
                        Premises: Macro Designer
Embedded macro
Data macro
Event
Macro

Accepted Answer

The Answer of Triggered by table events and Occurs when is...

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

In SQL,the ________ statement is used to retrieve data from a table.

Accepted Answer

The answer of In SQL,the ________ statement is used to...

Question 5

Where is the normal location in an SQL statement for the WHERE keyword?

Accepted Answer

A) Before the FROM keyword 
B) First 
C) After the FROM keyword 
D) Before the SELECT keyword 
A) Before the FROM keyword 
B) First 
C) After the FROM keyword 
D) Before the SELECT keyword

Question 6

Match between columns
                        Premises: SQL keyword
FROM keyword
SELECT keyword
ORDER BY keyword
WHERE keyword

Accepted Answer

The Answer of Determines the sort order in an SQL is...

Question 7

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

Accepted Answer

The answer of A(n)________ is a variable,constant,or expression that is...

Question 8

When there are multiple actions in a macro,Access executes the actions according to an established priority list.

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

Event-driven data macros are triggered by what events?

Accepted Answer

A) Table 
B) Form 
C) Form control 
D) Report 
A) Table 
B) Form 
C) Form control 
D) Report

Question 11

What type of macros associate programming logic to tables?

Accepted Answer

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

Question 12

In SQL,what is the default sort order when using the ORDER BY keyword?

Accepted Answer

A) There is no default sort order. 
B) The order of data entry 
C) Descending 
D) Ascending 
A) There is no default sort order. 
B) The order of data entry 
C) Descending 
D) Ascending

Question 13

Which of the following is not true about macros which have been converted to VBA?

Accepted Answer

A) They appear as modules in Access. 
B) They do not appear on the Navigation Pane. 
C) They appear on the Navigation Pane. 
D) The code will perform the same tasks as the original macro. 
A) They appear as modules in Access. 
B) They do not appear on the Navigation Pane. 
C) They appear on the Navigation Pane. 
D) The code will perform the same tasks as the original macro.

Question 14

The keyword used in SQL to establish criteria is ________.

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Macros allow more complex functionality than just using VBA.

Accepted Answer

A) True 
 B)False

Question 17

An embedded macro displays as an object in the Navigation Pane and can be run independently of other objects.

Accepted Answer

A) True 
 B)False

Question 18

Besides an embedded macro,what is the other type of macro?

Accepted Answer

A) Included 
B) Automated 
C) Stand-alone 
D) Inserted 
A) Included 
B) Automated 
C) Stand-alone 
D) Inserted

Question 19

Which one of the four keywords in SQL is used to establish criteria?

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

VBA stands for ________.

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

In SQL,the ________ statement is used to retrieve data from a table.

Where is the normal location in an SQL statement for the WHERE keyword?

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

When there are multiple actions in a macro,Access executes the actions according to an established priority list.

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

Event-driven data macros are triggered by what events?

What type of macros associate programming logic to tables?

In SQL,what is the default sort order when using the ORDER BY keyword?

Which of the following is not true about macros which have been converted to VBA?

The keyword used in SQL to establish criteria is ________.

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

Macros allow more complex functionality than just using VBA.

An embedded macro displays as an object in the Navigation Pane and can be run independently of other objects.

Besides an embedded macro,what is the other type of macro?

Which one of the four keywords in SQL is used to establish criteria?

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

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

VBA stands for ________.

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

In SQL,the ________ statement is used to retrieve data from a table.

Where is the normal location in an SQL statement for the WHERE keyword?

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

When there are multiple actions in a macro,Access executes the actions according to an established priority list.

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

Event-driven data macros are triggered by what events?

What type of macros associate programming logic to tables?

In SQL,what is the default sort order when using the ORDER BY keyword?

Which of the following is not true about macros which have been converted to VBA?

The keyword used in SQL to establish criteria is ________.

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

Macros allow more complex functionality than just using VBA.

An embedded macro displays as an object in the Navigation Pane and can be run independently of other objects.

Besides an embedded macro,what is the other type of macro?

Which one of the four keywords in SQL is used to establish criteria?

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

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