Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Data macros,like stand-alone macros and embedded macros,use the Macro Designer.

Accepted Answer

A) True 
 B)False

Question 3

What is not a good task for a macro?

Accepted Answer

A) Group a series of commands into one database object 
B) Automate repetitive tasks 
C) Perform a specific action 
D) Automate a one-time event 
A) Group a series of commands into one database object 
B) Automate repetitive tasks 
C) Perform a specific action 
D) Automate a one-time event

Question 4

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 5

When an On Close event is triggered and there is no macro attached to the event,Access runs its default On Close macro.

Accepted Answer

A) True 
 B)False

Question 6

When a user enters,edits,or deletes data; Access determines that a(n)________ has occurred.

Accepted Answer

The answer of When a user enters,edits,or deletes data; Access...

Question 7

Business logic describes the policies and procedures established by an organization.

Accepted Answer

A) True 
 B)False

Question 8

When was SQL developed?

Accepted Answer

A) Early 1960s 
B) Early 1970s 
C) Late 1970s 
D) Early 1980s 
A) Early 1960s 
B) Early 1970s 
C) Late 1970s 
D) Early 1980s

Question 9

Macros that work with ""user interface"" objects,such as forms,reports,and buttons,are known as ________ macros.

Accepted Answer

The answer of Macros that work with ""user interface"" objects,such...

Question 10

You can use the Macro Designer to edit existing macros.

Accepted Answer

A) True 
 B)False

Question 11

Structured Query Language is the industry-standard language for defining,manipulating,and retrieving the ________ in a database.

Accepted Answer

The answer of Structured Query Language is the industry-standard language...

Question 12

Which is not an argument for the MessageBox action?

Accepted Answer

A) Message 
B) Beep 
C) Title 
D) Repeat check box 
A) Message 
B) Beep 
C) Title 
D) Repeat check box

Question 13

Which type of macro executes when an event attached to a control or object occurs?

Accepted Answer

A) Stand-alone 
B) Included 
C) Embedded 
D) Automatic 
A) Stand-alone 
B) Included 
C) Embedded 
D) Automatic

Question 14

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 15

Standalone macros are listed in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 16

According the chapter,what is the easiest way to learn more advanced SQL statements?

Accepted Answer

A) Buy the SQL for Dummies book. 
B) Perform a Google search on advanced SQL statements. 
C) Experiment; create queries in SQL view,run them,and see what happens. 
D) Create queries in Design view and then view the SQL statements. 
A) Buy the SQL for Dummies book. 
B) Perform a Google search on advanced SQL statements. 
C) Experiment; create queries in SQL view,run them,and see what happens. 
D) Create queries in Design view and then view the SQL statements.

Question 17

When business logic requires the comparison of two or more fields,you need to use what type of macro?

Accepted Answer

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

Question 18

When you add a macro to an event,Access embeds a macro in the object or control and lists it on the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 19

What defines the purpose and the structure of an SQL statement?

Accepted Answer

A) Keyword 
B) Definition 
C) Code word 
D) ScreenTip 
A) Keyword 
B) Definition 
C) Code word 
D) ScreenTip

Question 20

If your SQL query does not include a WHERE statement,then ________ records will be selected.

Accepted Answer

The answer of If your SQL query does not include...

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

Data macros,like stand-alone macros and embedded macros,use the Macro Designer.

What is not a good task for a macro?

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

When an On Close event is triggered and there is no macro attached to the event,Access runs its default On Close macro.

When a user enters,edits,or deletes data; Access determines that a(n)________ has occurred.

Business logic describes the policies and procedures established by an organization.

When was SQL developed?

Macros that work with ""user interface"" objects,such as forms,reports,and buttons,are known as ________ macros.

You can use the Macro Designer to edit existing macros.

Structured Query Language is the industry-standard language for defining,manipulating,and retrieving the ________ in a database.

Which is not an argument for the MessageBox action?

Which type of macro executes when an event attached to a control or object occurs?

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

Standalone macros are listed in the Navigation Pane.

According the chapter,what is the easiest way to learn more advanced SQL statements?

When business logic requires the comparison of two or more fields,you need to use what type of macro?

When you add a macro to an event,Access embeds a macro in the object or control and lists it on the Navigation Pane.

What defines the purpose and the structure of an SQL statement?

If your SQL query does not include a WHERE statement,then ________ records will be selected.

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

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

Data macros,like stand-alone macros and embedded macros,use the Macro Designer.

What is not a good task for a macro?

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

When an On Close event is triggered and there is no macro attached to the event,Access runs its default On Close macro.

When a user enters,edits,or deletes data; Access determines that a(n)________ has occurred.

Business logic describes the policies and procedures established by an organization.

When was SQL developed?

Macros that work with ""user interface"" objects,such as forms,reports,and buttons,are known as ________ macros.

You can use the Macro Designer to edit existing macros.

Structured Query Language is the industry-standard language for defining,manipulating,and retrieving the ________ in a database.

Which is not an argument for the MessageBox action?

Which type of macro executes when an event attached to a control or object occurs?

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

Standalone macros are listed in the Navigation Pane.

According the chapter,what is the easiest way to learn more advanced SQL statements?

When business logic requires the comparison of two or more fields,you need to use what type of macro?

When you add a macro to an event,Access embeds a macro in the object or control and lists it on the Navigation Pane.

What defines the purpose and the structure of an SQL statement?

If your SQL query does not include a WHERE statement,then ________ records will be selected.

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