Question 1

Changing a relationship's join type only affects the way queries,and any object built from a query,work.

Accepted Answer

A) True 
 B)False  True

Question 2

Which of the following is a way to run a stand-alone macro?

Accepted Answer

A)  double-click the macro name in the Navigation pane 
B)  call the macro from another macro 
C)  attach the macro to an event property of an object or control 
D)  all of the above 
A)  double-click the macro name in the Navigation pane 
B)  call the macro from another macro 
C)  attach the macro to an event property of an object or control 
D)  all of the above D

Question 3

Which of the following events executes when an object/ control receives focus?

Accepted Answer

A)  On Click 
B)  On Dbl Click 
C)  On Got Focus 
D)  On Enter 
A)  On Click 
B)  On Dbl Click 
C)  On Got Focus 
D)  On Enter C

Question 4

A many-to-many relationship exists when one row of data in one table can be associated with many rows of data in a second table.

Accepted Answer

A) True 
 B)False

Question 5

Relational databases,like Access,do not directly support many-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is a named,executable set of actions that perform a specific task?

Accepted Answer

A)  group 
B)  argument 
C)  submacro 
D)  If block 
A)  group 
B)  argument 
C)  submacro 
D)  If block

Question 7

Which of the following executes when a mouse button is released after having been pressed?

Accepted Answer

A)  On Mouse Up 
B)  On Key Up 
C)  On Open 
D)  On Activate 
A)  On Mouse Up 
B)  On Key Up 
C)  On Open 
D)  On Activate

Question 8

Which of the following are attached to tables?

Accepted Answer

A)  user interface macros 
B)  data macros 
C)  events 
D)  macro window 
A)  user interface macros 
B)  data macros 
C)  events 
D)  macro window

Question 9

Macros in Access are the same as the macros you may have created in Excel or Word.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following notifies the application that an error has occurred?

Accepted Answer

A)  After Update data macro event 
B)  CancelRecordChange data macro action 
C)  RaiseError data macro action 
D)  EditRecord data block macro action 
A)  After Update data macro event 
B)  CancelRecordChange data macro action 
C)  RaiseError data macro action 
D)  EditRecord data block macro action

Question 11

SQL is the underlying language in a relational database system.

Accepted Answer

A) True 
 B)False

Question 12

The property sheet of an object or control displays all the possible events on the Event tab.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following are attached to objects and controls,such as forms,reports,and command buttons,that are part of the user interface?

Accepted Answer

A)  user interface macros 
B)  data macros 
C)  events 
D)  macro window 
A)  user interface macros 
B)  data macros 
C)  events 
D)  macro window

Question 14

When you create a database built from one of these templates,you must link it to a SharePoint server running Access Services.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following categories of user interface macros relates to importing,exporting,sending,and collecting data?

Accepted Answer

A)  Data Entry Operations 
B)  Data Import/ Export 
C)  Database Objects 
D)  Filter/ Query/ Search 
A)  Data Entry Operations 
B)  Data Import/ Export 
C)  Database Objects 
D)  Filter/ Query/ Search

Question 16

Which of the following events is only used with text box controls?

Accepted Answer

A)  On Click 
B)  On Dbl Click 
C)  On Got Focus 
D)  On Enter 
A)  On Click 
B)  On Dbl Click 
C)  On Got Focus 
D)  On Enter

Question 17

Which of the following is the most common type of program flow statement?

Accepted Answer

A)  program flow statement 
B)  Action 
C)  Comment 
D)  Macro Builder 
A)  program flow statement 
B)  Action 
C)  Comment 
D)  Macro Builder

Question 18

Which of the following statements is not true of online web databases?

Accepted Answer

A)  Design view is an available option for objects in web databases. 
B)  For web databases,Access provides enhanced Datasheet view features as well as the Layout view functionality. 
C)  In web databases,relationships are created and modified through a Lookup field and not through the Relationships window. 
D)  Access databases that are built to work online are different. 
A)  Design view is an available option for objects in web databases. 
B)  For web databases,Access provides enhanced Datasheet view features as well as the Layout view functionality. 
C)  In web databases,relationships are created and modified through a Lookup field and not through the Relationships window. 
D)  Access databases that are built to work online are different.

Question 19

Which of the following provides organizational structure to a macro?

Accepted Answer

A)  program flow statement 
B)  Action 
C)  Comment 
D)  Macro Builder 
A)  program flow statement 
B)  Action 
C)  Comment 
D)  Macro Builder

Question 20

What is a named data macro? What characteristics do named data macros have?

Accepted Answer

A named data macro is associated with a

Changing a relationship's join type only affects the way queries,and any object built from a query,work.

Which of the following is a way to run a stand-alone macro?

Which of the following events executes when an object/ control receives focus?

A many-to-many relationship exists when one row of data in one table can be associated with many rows of data in a second table.

Relational databases,like Access,do not directly support many-to-many relationships.

Which of the following is a named,executable set of actions that perform a specific task?

Which of the following executes when a mouse button is released after having been pressed?

Which of the following are attached to tables?

Macros in Access are the same as the macros you may have created in Excel or Word.

Which of the following notifies the application that an error has occurred?

SQL is the underlying language in a relational database system.

The property sheet of an object or control displays all the possible events on the Event tab.

Which of the following are attached to objects and controls,such as forms,reports,and command buttons,that are part of the user interface?

When you create a database built from one of these templates,you must link it to a SharePoint server running Access Services.

Which of the following categories of user interface macros relates to importing,exporting,sending,and collecting data?

Which of the following events is only used with text box controls?

Which of the following is the most common type of program flow statement?

Which of the following statements is not true of online web databases?

Which of the following provides organizational structure to a macro?

What is a named data macro? What characteristics do named data macros have?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters

Exam 6: Creating Advanced Queries and Reports and Using SQL

Changing a relationship's join type only affects the way queries,and any object built from a query,work.

Which of the following is a way to run a stand-alone macro?

Which of the following events executes when an object/ control receives focus?

A many-to-many relationship exists when one row of data in one table can be associated with many rows of data in a second table.

Relational databases,like Access,do not directly support many-to-many relationships.

Which of the following is a named,executable set of actions that perform a specific task?

Which of the following executes when a mouse button is released after having been pressed?

Which of the following are attached to tables?

Macros in Access are the same as the macros you may have created in Excel or Word.

Which of the following notifies the application that an error has occurred?

SQL is the underlying language in a relational database system.

The property sheet of an object or control displays all the possible events on the Event tab.

Which of the following are attached to objects and controls,such as forms,reports,and command buttons,that are part of the user interface?

When you create a database built from one of these templates,you must link it to a SharePoint server running Access Services.

Which of the following categories of user interface macros relates to importing,exporting,sending,and collecting data?

Which of the following events is only used with text box controls?

Which of the following is the most common type of program flow statement?

Which of the following statements is not true of online web databases?

Which of the following provides organizational structure to a macro?

What is a named data macro? What characteristics do named data macros have?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters