Question 1

Design view is an available option for objects in web databases.

Accepted Answer

A) True 
 B)False

Question 2

What do you need in order to work with templates that run on the web? What templates are included with Access?

Accepted Answer

You can choose from several templates th

Question 3

When a relationship is created,what kind of join does Access assign?

Accepted Answer

A)  inner join 
B)  left outer join 
C)  right outer join 
D)  none of the above 
A)  inner join 
B)  left outer join 
C)  right outer join 
D)  none of the above

Question 4

Which of the following lets you integrate conditional logic into the execution of a macro?

Accepted Answer

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

Question 5

Which of the following Lookup field properties determines the width of the drop-down list?

Accepted Answer

A)  Display Control 
B)  List Width 
C)  Limit to List 
D)  Allow Value List Edits 
A)  Display Control 
B)  List Width 
C)  Limit to List 
D)  Allow Value List Edits

Question 6

Which of the following lets you copy an action?

Accepted Answer

A)  Ctrl+C 
B)  Ctrl+X 
C)  Ctrl+V 
D)  Ctrl+P 
A)  Ctrl+C 
B)  Ctrl+X 
C)  Ctrl+V 
D)  Ctrl+P

Question 7

What is the Macro Builder used for? Describe the different components of the Macro Builder.

Accepted Answer

You write and edit the content of all ma

Question 8

The join type property determines how to match the data in the two related tables.

Accepted Answer

A) True 
 B)False

Question 9

Edit an embedded macro by right-clicking the macro name from the Navigation pane and selecting design view.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following statements is true about deleting a relationship created with a Lookup field?

Accepted Answer

A)  Occasionally you may need to remove a relationship that was not created correctly. 
B)  If the relationship was the result of using the Lookup Wizard,you most likely will need to delete both the relationship and the lookup attached to the field. 
C)  After deleting a relationship,you may need to change the Display Control property of the field so it is no longer a combo box. 
D)  all of the above 
A)  Occasionally you may need to remove a relationship that was not created correctly. 
B)  If the relationship was the result of using the Lookup Wizard,you most likely will need to delete both the relationship and the lookup attached to the field. 
C)  After deleting a relationship,you may need to change the Display Control property of the field so it is no longer a combo box. 
D)  all of the above

Question 11

In data macros,which of the following is available to help you debug a macro?

Accepted Answer

A)  parameter 
B)  Single Step tool 
C)  Application Log 
D)  Macro Builder 
A)  parameter 
B)  Single Step tool 
C)  Application Log 
D)  Macro Builder

Question 12

Which of the following keys will help you select multiple foreign keys?

Accepted Answer

A)  Ctrl 
B)  Shift 
C)  Shift+Tab 
D)  Tab 
A)  Ctrl 
B)  Shift 
C)  Shift+Tab 
D)  Tab

Question 13

Comments affect the logic or functionality of macros.

Accepted Answer

A) True 
 B)False

Question 14

A submacro is a named,executable set of actions that perform a specific task.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following returns all the records from the table on the right side of the join and only the records that have a matching value from the table on the left side of the join?

Accepted Answer

A)  join type property 
B)  inner join 
C)  left outer join 
D)  right outer join 
A)  join type property 
B)  inner join 
C)  left outer join 
D)  right outer join

Question 16

Which of the following runs when a database is first opened?

Accepted Answer

A)  Open macro 
B)  AutoOpen macro 
C)  Exec macro 
D)  AutoExec macro 
A)  Open macro 
B)  AutoOpen macro 
C)  Exec macro 
D)  AutoExec macro

Question 17

Which of the following is a piece of information needed to complete an action?

Accepted Answer

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

Question 18

Which of the following Lookup field properties determines whether a user can edit the list of items?

Accepted Answer

A)  Display Control 
B)  List Width 
C)  Limit to List 
D)  Allow Value List Edits 
A)  Display Control 
B)  List Width 
C)  Limit to List 
D)  Allow Value List Edits

Question 19

You can create a stand-alone macro that executes automatically when the database is first opened.

Accepted Answer

A) True 
 B)False

Question 20

The Row Source Type and Row Source properties are not set automatically by the Lookup Wizard.

Accepted Answer

A) True 
 B)False

Design view is an available option for objects in web databases.

What do you need in order to work with templates that run on the web? What templates are included with Access?

When a relationship is created,what kind of join does Access assign?

Which of the following lets you integrate conditional logic into the execution of a macro?

Which of the following Lookup field properties determines the width of the drop-down list?

Which of the following lets you copy an action?

What is the Macro Builder used for? Describe the different components of the Macro Builder.

The join type property determines how to match the data in the two related tables.

Edit an embedded macro by right-clicking the macro name from the Navigation pane and selecting design view.

Which of the following statements is true about deleting a relationship created with a Lookup field?

In data macros,which of the following is available to help you debug a macro?

Which of the following keys will help you select multiple foreign keys?

Comments affect the logic or functionality of macros.

A submacro is a named,executable set of actions that perform a specific task.

Which of the following returns all the records from the table on the right side of the join and only the records that have a matching value from the table on the left side of the join?

Which of the following runs when a database is first opened?

Which of the following is a piece of information needed to complete an action?

Which of the following Lookup field properties determines whether a user can edit the list of items?

You can create a stand-alone macro that executes automatically when the database is first opened.

The Row Source Type and Row Source properties are not set automatically by the Lookup Wizard.

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

Design view is an available option for objects in web databases.

What do you need in order to work with templates that run on the web? What templates are included with Access?

When a relationship is created,what kind of join does Access assign?

Which of the following lets you integrate conditional logic into the execution of a macro?

Which of the following Lookup field properties determines the width of the drop-down list?

Which of the following lets you copy an action?

What is the Macro Builder used for? Describe the different components of the Macro Builder.

The join type property determines how to match the data in the two related tables.

Edit an embedded macro by right-clicking the macro name from the Navigation pane and selecting design view.

Which of the following statements is true about deleting a relationship created with a Lookup field?

In data macros,which of the following is available to help you debug a macro?

Which of the following keys will help you select multiple foreign keys?

Comments affect the logic or functionality of macros.

A submacro is a named,executable set of actions that perform a specific task.

Which of the following returns all the records from the table on the right side of the join and only the records that have a matching value from the table on the left side of the join?

Which of the following runs when a database is first opened?

Which of the following is a piece of information needed to complete an action?

Which of the following Lookup field properties determines whether a user can edit the list of items?

You can create a stand-alone macro that executes automatically when the database is first opened.

The Row Source Type and Row Source properties are not set automatically by the Lookup Wizard.

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