Question 1

Which of the following categories of user interface macros relates to controlling what is shown on the screen?

Accepted Answer

A)  Database Objects 
B)  Data Entry Operations 
C)  System Commands 
D)  User Interface Commands 
A)  Database Objects 
B)  Data Entry Operations 
C)  System Commands 
D)  User Interface Commands

Question 2

Which of the following events executes immediately before a control,on a form or report,loses the focus to another control on the same form or report?

Accepted Answer

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

Question 3

An embedded macro is attached to one specific object or control on an object.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following executes when a form or report is opened?

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 5

For web databases,Access provides enhanced Datasheet view features as well as the Layout view functionality.

Accepted Answer

A) True 
 B)False

Question 6

Before creating an embedded macro,you must first open the property sheet of the object or control.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following Lookup field properties determines whether a user can enter a value into the field?

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 8

Most templates open with the Navigation pane closed.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following lets you write and edit he content of all macros?

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 10

User interface macros are attached to objects and controls,such as forms,reports,and command buttons,that are part of the user interface.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following keys lets you bypass the AutoExec macro when opening a database?

Accepted Answer

A)  Ctrl 
B)  Alt 
C)  Shift 
D)  Esc 
A)  Ctrl 
B)  Alt 
C)  Shift 
D)  Esc

Question 12

An embedded macro is automatically created when you use the Command Button Wizard to attach functionality to a button.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following Access templates is used to track assets within an organization,such as computers or office equipment?

Accepted Answer

A)  Desktop asset tracking 
B)  Desktop contacts 
C)  Desktop issue tracking 
D)  Desktop project management 
A)  Desktop asset tracking 
B)  Desktop contacts 
C)  Desktop issue tracking 
D)  Desktop project management

Question 14

A macro that runs when a database is first opened is an AutoExec macro.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is the underlying language in a relational database system?

Accepted Answer

A)  Application Log 
B)  Macro Builder 
C)  Lookup Wizard 
D)  Structured Query Language 
A)  Application Log 
B)  Macro Builder 
C)  Lookup Wizard 
D)  Structured Query Language

Question 16

Events are occurring all of the time when you use a database.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is a database object that allows you to write and attach code to different objects and controls in your database?

Accepted Answer

A)  junction table 
B)  concatenated primary key 
C)  macro 
D)  Application Log 
A)  junction table 
B)  concatenated primary key 
C)  macro 
D)  Application Log

Question 18

When working with macros,what is an event? Provide a few examples.

Accepted Answer

Most macros execute because an event occ

Question 19

When implementing a many-to-many relationship,which of the following should you do to ensure your database will function correctly?

Accepted Answer

A)  Build the tables on the "one" side of the relationship first. 
B)  Define the primary key for each of the "one" side tables. 
C)  Build the junction table and define the primary key for the junction table. 
D)  all of the above. 
A)  Build the tables on the "one" side of the relationship first. 
B)  Define the primary key for each of the "one" side tables. 
C)  Build the junction table and define the primary key for the junction table. 
D)  all of the above.

Question 20

The Macro Builder contains the Single Step tool,which can execute the macro one action,or step,at a time.

Accepted Answer

A) True 
 B)False

Which of the following categories of user interface macros relates to controlling what is shown on the screen?

Which of the following events executes immediately before a control,on a form or report,loses the focus to another control on the same form or report?

An embedded macro is attached to one specific object or control on an object.

Which of the following executes when a form or report is opened?

For web databases,Access provides enhanced Datasheet view features as well as the Layout view functionality.

Before creating an embedded macro,you must first open the property sheet of the object or control.

Which of the following Lookup field properties determines whether a user can enter a value into the field?

Most templates open with the Navigation pane closed.

Which of the following lets you write and edit he content of all macros?

User interface macros are attached to objects and controls,such as forms,reports,and command buttons,that are part of the user interface.

Which of the following keys lets you bypass the AutoExec macro when opening a database?

An embedded macro is automatically created when you use the Command Button Wizard to attach functionality to a button.

Which of the following Access templates is used to track assets within an organization,such as computers or office equipment?

A macro that runs when a database is first opened is an AutoExec macro.

Which of the following is the underlying language in a relational database system?

Events are occurring all of the time when you use a database.

Which of the following is a database object that allows you to write and attach code to different objects and controls in your database?

When working with macros,what is an event? Provide a few examples.

When implementing a many-to-many relationship,which of the following should you do to ensure your database will function correctly?

The Macro Builder contains the Single Step tool,which can execute the macro one action,or step,at a time.

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

Which of the following categories of user interface macros relates to controlling what is shown on the screen?

Which of the following events executes immediately before a control,on a form or report,loses the focus to another control on the same form or report?

An embedded macro is attached to one specific object or control on an object.

Which of the following executes when a form or report is opened?

For web databases,Access provides enhanced Datasheet view features as well as the Layout view functionality.

Before creating an embedded macro,you must first open the property sheet of the object or control.

Which of the following Lookup field properties determines whether a user can enter a value into the field?

Most templates open with the Navigation pane closed.

Which of the following lets you write and edit he content of all macros?

User interface macros are attached to objects and controls,such as forms,reports,and command buttons,that are part of the user interface.

Which of the following keys lets you bypass the AutoExec macro when opening a database?

An embedded macro is automatically created when you use the Command Button Wizard to attach functionality to a button.

Which of the following Access templates is used to track assets within an organization,such as computers or office equipment?

A macro that runs when a database is first opened is an AutoExec macro.

Which of the following is the underlying language in a relational database system?

Events are occurring all of the time when you use a database.

Which of the following is a database object that allows you to write and attach code to different objects and controls in your database?

When working with macros,what is an event? Provide a few examples.

When implementing a many-to-many relationship,which of the following should you do to ensure your database will function correctly?

The Macro Builder contains the Single Step tool,which can execute the macro one action,or step,at a time.

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