Microsoft Office Access 2013 Complete In Practice 1st Edition By Annette Easton and Randy Nordell – Test Bank

$20.00

Pay And Download

 

Complete Test Bank With Answers

 

 

 

Sample Questions Posted Below

 

 

 

 

Access Chapter 05

Templates, Advanced Relationships, and Macros

 

True / False Questions

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

True    False

 

2. Most templates open with the Navigation pane closed.

True    False

 

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

True    False

 

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

True    False

 

5. After completing the Lookup Wizard, Access automatically creates a relationship between the two tables.

True    False

 

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

True    False

 

7. SQL is the underlying language in a relational database system.

True    False

 

8. 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.

True    False

 

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

True    False

 

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

True    False

 

11. When a relationship is created, Access assigns it an inner join type.

True    False

 

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

True    False

 

13. A macro is a database object that allows you to write and attach code to different objects and controls in your database.

True    False

 

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

True    False

 

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

True    False

 

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

True    False

 

17. Comments affect the logic or functionality of macros.

True    False

 

18. A stand-alone macro is a separate Access object that appears in the Navigation pane.

True    False

 

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

True    False

 

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

True    False

 

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

True    False

 

22. Create a stand-alone macro when you want to call a macro from several different objects or controls.

True    False

 

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

True    False

 

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

True    False

 

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

True    False

 

26. Edit a stand-alone macro by right-clicking the macro name from the Navigation pane and selecting design view.

True    False

 

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

True    False

 

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

True    False

 

29. Using a parameter in a named data macro allows you to pass data out of a macro.

True    False

 

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

True    False

 

 

Multiple Choice Questions

31. Which of the following Access templates is used to track information about reported issues that need to be resolved?

A. Desktop asset tracking

 

B. Desktop contacts

 

C. Desktop issue tracking

 

D. Desktop project management

 

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

A. Desktop asset tracking

 

B. Desktop contacts

 

C. Desktop issue tracking

 

D. Desktop project management

 

33. Which of the following Access templates is used to track information about different projects and their related tasks?

A. Desktop asset tracking

 

B. Desktop contacts

 

C. Desktop issue tracking

 

D. Desktop project management

 

34. Which of the following Access templates is used to track information about people, such as team members, customers, etc?

A. Desktop asset tracking

 

B. Desktop contacts

 

C. Desktop issue tracking

 

D. Desktop project management

 

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

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.

 

36. Which of the following happens after completing the Lookup Wizard?

A. Access automatically creates a relationship between the two tables.

 

B. Access does not create a relationship between the two tables.

 

C. Access sometimes creates a relationship between the two tables, depending on your selections.

 

D. Access gives you the option of creating a relationship between the two tables.

 

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

A. Display Control

 

B. List Width

 

C. Limit to List

 

D. Allow Value List Edits

 

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

A. Display Control

 

B. List Width

 

C. Limit to List

 

D. Allow Value List Edits

 

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

A. Display Control

 

B. List Width

 

C. Limit to List

 

D. Allow Value List Edits

 

40. Which of the following Lookup field properties sets the number of choices that display in the list?

A. List Rows

 

B. List Width

 

C. Limit to List

 

D. Allow Value List Edits

 

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

A. Application Log

 

B. Macro Builder

 

C. Lookup Wizard

 

D. Structured Query Language

 

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

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

 

43. Which of the following statements is true about junction tables?

A. A junction table must contain the primary key from each of the related tables.

 

B. Each field is a foreign key that links the related table.

 

C. both A and B

 

D. neither A nor B

 

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

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.

 

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

A. Ctrl

 

B. Shift

 

C. Shift+Tab

 

D. Tab

 

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

A. join type property

 

B. inner join

 

C. left outer join

 

D. right outer join

 

47. Which of the following returns only records that have matching values in both tables?

A. join type property

 

B. inner join

 

C. left outer join

 

D. right outer join

 

48. Which of the following determines how to match the data in two related tables?

A. join type property

 

B. inner join

 

C. left outer join

 

D. right outer join

 

49. 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?

A. join type property

 

B. inner join

 

C. left outer join

 

D. right outer join

 

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

A. inner join

 

B. left outer join

 

C. right outer join

 

D. none of the above

 

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

A. junction table

 

B. concatenated primary key

 

C. macro

 

D. Application Log

 

52. Which of the following statements is true?

A. When a report or form opens, the On Open event occurs.

 

B. When a user hovers the mouse over a button on a form, the On Mouse Move event occurs.

 

C. When a user pushes a button on a form, the On Click event occurs.

 

D. all of the above

 

53. When building a macro, which of the following must you do?

A. decide what event will cause the macro to execute

 

B. plan out the logic behind the steps, or tasks, the macro will perform

 

C. determine the type of macro needed and the best way to build the macro

 

D. all of the above

 

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

A. user interface macros

 

B. data macros

 

C. events

 

D. macro window

 

55. Which of the following occur when an action happens to an object or control?

A. user interface macros

 

B. data macros

 

C. events

 

D. macro window

 

56. Which of the following are attached to tables?

A. user interface macros

 

B. data macros

 

C. events

 

D. macro window

 

57. Which of the following provides organizational structure to a macro?

A. program flow statement

 

B. Action

 

C. Comment

 

D. Macro Builder

 

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

A. program flow statement

 

B. Action

 

C. Comment

 

D. Macro Builder

 

59. Which of the following is an individual command inside of a macro?

A. program flow statement

 

B. Action

 

C. Comment

 

D. Macro Builder

 

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

A. program flow statement

 

B. Action

 

C. Comment

 

D. Macro Builder

 

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

A. group

 

B. argument

 

C. submacro

 

D. If block

 

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

A. group

 

B. argument

 

C. submacro

 

D. If block

 

63. Which of the following is a named block of actions?

A. group

 

B. argument

 

C. submacro

 

D. If block

 

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

A. group

 

B. argument

 

C. submacro

 

D. If block

 

65. Which of the following lets you paste an action?

A. Ctrl+C

 

B. Ctrl+X

 

C. Ctrl+V

 

D. Ctrl+P

 

66. Which of the following lets you copy an action?

A. Ctrl+C

 

B. Ctrl+X

 

C. Ctrl+V

 

D. Ctrl+P

 

67. Which of the following categories of user interface macros relates to changing the data?

A. Data Entry Operations

 

B. Data Import/Export

 

C. Database Objects

 

D. Filter/Query/Search

 

68. Which of the following categories of user interface macros relates to changing controls and objects in the database?

A. Data Entry Operations

 

B. Data Import/Export

 

C. Database Objects

 

D. Filter/Query/Search

 

69. Which of the following categories of user interface macros relates to filtering, querying, and searching records?

A. Data Entry Operations

 

B. Data Import/Export

 

C. Database Objects

 

D. Filter/Query/Search

 

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

A. Data Entry Operations

 

B. Data Import/Export

 

C. Database Objects

 

D. Filter/Query/Search

 

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

A. Database Objects

 

B. Data Entry Operations

 

C. System Commands

 

D. User Interface Commands

 

72. Which of the following categories of user interface macros relates to changing the database system?

A. Database Objects

 

B. Data Entry Operations

 

C. System Commands

 

D. User Interface Commands

 

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

A. On Click

 

B. On Dbl Click

 

C. On Got Focus

 

D. On Enter

 

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

A. On Click

 

B. On Dbl Click

 

C. On Got Focus

 

D. On Enter

 

75. Which of the following events executes after the object/control is clicked?

A. On Click

 

B. On Dbl Click

 

C. On Got Focus

 

D. On Enter

 

76. 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?

A. On Click

 

B. On Exit

 

C. On Got Focus

 

D. On Enter

 

77. Which of the following executes when the user releases a key that he or she was pressing?

A. On Mouse Up

 

B. On Key Up

 

C. On Open

 

D. On Activate

 

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

A. On Mouse Up

 

B. On Key Up

 

C. On Open

 

D. On Activate

 

79. Which of the following executes after a form or report is already opened and the object gains the focus?

A. On Mouse Up

 

B. On Key Up

 

C. On Open

 

D. On Activate

 

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

A. On Mouse Up

 

B. On Key Up

 

C. On Open

 

D. On Activate

 

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

A. Open macro

 

B. AutoOpen macro

 

C. Exec macro

 

D. AutoExec macro

 

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

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

 

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

A. Ctrl

 

B. Alt

 

C. Shift

 

D. Esc

 

84. Which of the following executes after an existing record is changed?

A. After Update data macro event

 

B. CancelRecordChange data macro action

 

C. RaiseError data macro action

 

D. EditRecord data block macro action

 

85. Which of the following changes the values in the existing record?

A. After Update data macro event

 

B. CancelRecordChange data macro action

 

C. RaiseError data macro action

 

D. EditRecord data block macro action

 

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

A. After Update data macro event

 

B. CancelRecordChange data macro action

 

C. RaiseError data macro action

 

D. EditRecord data block macro action

 

87. Which of the following exits an EditRecord or CreateRecord data block and does not save the current record?

A. After Update data macro event

 

B. CancelRecordChange data macro action

 

C. RaiseError data macro action

 

D. EditRecord data block macro action

 

88. Which of the following in a named data macro allows you to pass data into the macro?

A. parameter

 

B. Single Step tool

 

C. Application Log

 

D. Macro Builder

 

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

A. parameter

 

B. Single Step tool

 

C. Application Log

 

D. Macro Builder

 

90. Which of the following can execute a macro one action, or step, at a time?

A. parameter

 

B. Single Step tool

 

C. Application Log

 

D. Macro Builder

 

 

Essay Questions

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

 

 

 

 

92. Why are junction tables important?

 

 

 

 

93. When working with tables in a many-to-many relationship, what guidelines will help ensure that your database will function correctly?

 

 

 

 

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

 

 

 

 

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

 

 

 

 

96. What is the difference between a stand-alone macro and an embedded macro?

 

 

 

 

97. What are data macros?

 

 

 

 

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

 

 

 

 

99. Explain what submacros are and why they are useful.

 

 

 

 

100. Explain what you know about testing and debugging macros.

 

 

 

 

 

Access Chapter 05 Templates, Advanced Relationships, and Macros Answer Key

 

True / False Questions

1.
(p. A5-286)
When you create a database built from one of these templates, you must link it to a SharePoint server running Access Services.

TRUE

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-01
Skill: Access Templates
 

 

2.
(p. A5-289)
Most templates open with the Navigation pane closed.

TRUE

Most templates open with the Navigation pane closed.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-01
Skill: Explore the Navigation Pane, Objects, and Relationships
 

 

3.
(p. A5-290)
Design view is an available option for objects in web databases.

FALSE

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-01
Skill: Explore the Navigation Pane, Objects, and Relationships
 

 

4.
(p. A5-290)
For web databases, Access provides enhanced Datasheet view features as well as the Layout view functionality.

TRUE

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-01
Skill: Explore the Navigation Pane, Objects, and Relationships
 

 

5.
(p. A5-294)
After completing the Lookup Wizard, Access automatically creates a relationship between the two tables.

TRUE

After completing the Lookup Wizard, Access automatically creates a relationship between the two tables.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-02
Skill: View, Edit, and Save a Table Relationship
 

 

6.
(p. A5-295)
The Row Source Type and Row Source properties are not set automatically by the Lookup Wizard.

FALSE

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

 

Blooms: Remember
Difficulty: 3 Hard
SLO: 05-02
Skill: Edit Properties of the Lookup Field
 

 

7.
(p. A5-295)
SQL is the underlying language in a relational database system.

TRUE

SQL is the underlying language in a relational database system.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-02
Skill: Edit Properties of the Lookup Field
 

 

8.
(p. A5-298)
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.

FALSE

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-03
Skill: Implement a Many-to-Many Relationship
 

 

9.
(p. A5-298)
Relational databases, like Access, do not directly support many-to-many relationships.

TRUE

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-03
Skill: Implement a Many-to-Many Relationship
 

 

10.
(p. A5-301)
The join type property determines how to match the data in the two related tables.

TRUE

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-03
Skill: Join Properties
 

 

11.
(p. A5-302)
When a relationship is created, Access assigns it an inner join type.

TRUE

When a relationship is created, Access assigns it an inner join type.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-03
Skill: Change the Join Type
 

 

12.
(p. A5-302)
Changing a relationship’s join type only affects the way queries, and any object built from a query, work.

TRUE

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-03
Skill: Change the Join Type
 

 

13.
(p. A5-306)
A macro is a database object that allows you to write and attach code to different objects and controls in your database.

TRUE

A macro is a database object that allows you to write and attach code to different objects and controls in your database.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: Creating and Using a Macro
 

 

14.
(p. A5-306)
Macros in Access are the same as the macros you may have created in Excel or Word.

FALSE

Macros in Access are very different than the macros you may have created in Excel or Word.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-04
Skill: Creating and Using a Macro
 

 

15.
(p. A5-306)
Events are occurring all of the time when you use a database.

TRUE

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-04
Skill: The Purpose of a Macro
 

 

16.
(p. A5-306)
User interface macros are attached to objects and controls, such as forms, reports, and command buttons, that are part of the user interface.

TRUE

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-04
Skill: The Purpose of a Macro
 

 

17.
(p. A5-307)
Comments affect the logic or functionality of macros.

FALSE

Comments do not affect the logic or functionality of macros.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-04
Skill: The Macro Builder and Macro Design
 

 

18.
(p. A5-310)
A stand-alone macro is a separate Access object that appears in the Navigation pane.

TRUE

A stand-alone macro is a separate Access object that appears in the Navigation pane.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: Creating and Using User Interface Macros
 

 

19.
(p. A5-310)
An embedded macro is attached to one specific object or control on an object.

TRUE

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: Creating and Using User Interface Macros
 

 

20.
(p. A5-311)
You can create a stand-alone macro that executes automatically when the database is first opened.

TRUE

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

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-05
Skill: User Interface Macros
 

 

21.
(p. A5-312)
The property sheet of an object or control displays all the possible events on the Event tab.

TRUE

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: User Interface Macros
 

 

22.
(p. A5-315)
Create a stand-alone macro when you want to call a macro from several different objects or controls.

TRUE

Create a stand-alone macro when you want to call a macro from several different objects or controls.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: Build a Stand-Alone Macro
 

 

23.
(p. A5-315)
A macro that runs when a database is first opened is an AutoExec macro.

TRUE

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

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-05
Skill: Build a Stand-Alone Macro
 

 

24.
(p. A5-316)
Before creating an embedded macro, you must first open the property sheet of the object or control.

TRUE

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

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-05
Skill: Build an Embedded Macro
 

 

25.
(p. A5-316)
An embedded macro is automatically created when you use the Command Button Wizard to attach functionality to a button.

TRUE

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: Build an Embedded Macro
 

 

26.
(p. A5-317)
Edit a stand-alone macro by right-clicking the macro name from the Navigation pane and selecting design view.

TRUE

Edit a stand-alone macro by right-clicking the macro name from the Navigation pane and selecting design view.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: Edit or Delete a User Interface Macro
 

 

27.
(p. A5-317)
Edit an embedded macro by right-clicking the macro name from the Navigation pane and selecting design view.

FALSE

Edit an embedded macro by opening the property sheet of the object or control and clicking the Build button in the property box of the event.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: Edit or Delete a User Interface Macro
 

 

28.
(p. A5-326)
A submacro is a named, executable set of actions that perform a specific task.

TRUE

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

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-07
Skill: Build a Submacro
 

 

29.
(p. A5-328)
Using a parameter in a named data macro allows you to pass data out of a macro.

FALSE

Using a parameter in a named data macro allows you to pass data into a macro.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-07
Skill: Add Parameters to a Named Data Macro
 

 

30.
(p. A5-331)
The Macro Builder contains the Single Step tool, which can execute the macro one action, or step, at a time.

TRUE

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

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-07
Skill: The Single Step Tool
 

 

Multiple Choice Questions

31.
(p. A5-286)
Which of the following Access templates is used to track information about reported issues that need to be resolved?

A. Desktop asset tracking

 

B. Desktop contacts

 

C. Desktop issue tracking

 

D. Desktop project management

The Desktop issue tracking template is used to track information about reported issues that need to be resolved.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-01
Skill: Access Templates
 

 

32.
(p. A5-286)
Which of the following Access templates is used to track assets within an organization, such as computers or office equipment?

A. Desktop asset tracking

 

B. Desktop contacts

 

C. Desktop issue tracking

 

D. Desktop project management

The Desktop asset tracking templates is used to track assets within an organization, such as computers or office equipment.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-01
Skill: Access Templates
 

 

33.
(p. A5-286)
Which of the following Access templates is used to track information about different projects and their related tasks?

A. Desktop asset tracking

 

B. Desktop contacts

 

C. Desktop issue tracking

 

D. Desktop project management

The Desktop project management template is used to track information about different projects and their related tasks.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-01
Skill: Access Templates
 

 

34.
(p. A5-286)
Which of the following Access templates is used to track information about people, such as team members, customers, etc?

A. Desktop asset tracking

 

B. Desktop contacts

 

C. Desktop issue tracking

 

D. Desktop project management

The Desktop contacts template is used to track information about people, such as team members, customers, etc.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-01
Skill: Access Templates
 

 

35.
(p. A5-290)
Which of the following statements is not true of online web databases?

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.

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-01
Skill: Explore the Navigation Pane, Objects, and Relationships
 

 

36.
(p. A5-294)
Which of the following happens after completing the Lookup Wizard?

A. Access automatically creates a relationship between the two tables.

 

B. Access does not create a relationship between the two tables.

 

C. Access sometimes creates a relationship between the two tables, depending on your selections.

 

D. Access gives you the option of creating a relationship between the two tables.

After completing the Lookup Wizard, Access automatically creates a relationship between the two tables.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-02
Skill: View, Edit, and Save a Table Relationship
 

 

37.
(p. A5-295)
Which of the following Lookup field properties determines the width of the drop-down list?

A. Display Control

 

B. List Width

 

C. Limit to List

 

D. Allow Value List Edits

The List Width Lookup field property determines the width of the drop-down list.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-02
Skill: Edit Properties of the Lookup Field
 

 

38.
(p. A5-295)
Which of the following Lookup field properties determines whether a user can edit the list of items?

A. Display Control

 

B. List Width

 

C. Limit to List

 

D. Allow Value List Edits

The Allow Value List Edits Lookup field property determines whether a user can edit the list of items.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-02
Skill: Edit Properties of the Lookup Field
 

 

39.
(p. A5-295)
Which of the following Lookup field properties determines whether a user can enter a value into the field?

A. Display Control

 

B. List Width

 

C. Limit to List

 

D. Allow Value List Edits

The Limit to List Lookup field property determines whether a user can enter a value into the field.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-02
Skill: Edit Properties of the Lookup Field
 

 

40.
(p. A5-295)
Which of the following Lookup field properties sets the number of choices that display in the list?

A. List Rows

 

B. List Width

 

C. Limit to List

 

D. Allow Value List Edits

The List Rows field property sets the number of choices that display in the list.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-02
Skill: Edit Properties of the Lookup Field
 

 

41.
(p. A5-295)
Which of the following is the underlying language in a relational database system?

A. Application Log

 

B. Macro Builder

 

C. Lookup Wizard

 

D. Structured Query Language

Structured Query Language is the underlying language in a relational database system.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-02
Skill: Edit Properties of the Lookup Field
 

 

42.
(p. A5-296)
Which of the following statements is true about deleting a relationship created with a Lookup field?

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

All of the statements are true.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-02
Skill: Delete a Relationship Created with a Lookup Field
 

 

43.
(p. A5-299)
Which of the following statements is true about junction tables?

A. A junction table must contain the primary key from each of the related tables.

 

B. Each field is a foreign key that links the related table.

 

C. both A and B

 

D. neither A nor B

Both of the statements in A and B are true.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-03
Skill: Implement a Many-to-Many Relationship
 

 

44.
(p. A5-300)
When implementing a many-to-many relationship, which of the following should you do to ensure your database will function correctly?

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.

When implementing a many-to-many relationship, if you perform each of the tasks listed, your database will most likely function correctly.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-03
Skill: Implement a Many-to-Many Relationship
 

 

45.
(p. A5-300)
Which of the following keys will help you select multiple foreign keys?

A. Ctrl

 

B. Shift

 

C. Shift+Tab

 

D. Tab

Press and hold the Shift key to select multiple foreign keys.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-03
Skill: Implement a Many-to-Many Relationship
 

 

46.
(p. A5-301)
Which of the following returns all the records from the table on the left side of the join and only the records that have a matching value from the table on the right side of the join?

A. join type property

 

B. inner join

 

C. left outer join

 

D. right outer join

A left outer join returns all the records from the table on the left side of the join and only the records that have a matching value from the table on the right side of the join.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-03
Skill: Join Properties
 

 

47.
(p. A5-301)
Which of the following returns only records that have matching values in both tables?

A. join type property

 

B. inner join

 

C. left outer join

 

D. right outer join

An inner join returns only records that have matching values in both tables.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-03
Skill: Join Properties
 

 

48.
(p. A5-301)
Which of the following determines how to match the data in two related tables?

A. join type property

 

B. inner join

 

C. left outer join

 

D. right outer join

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

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-03
Skill: Join Properties
 

 

49.
(p. A5-302)
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?

A. join type property

 

B. inner join

 

C. left outer join

 

D. right outer join

A right outer join 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.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-03
Skill: Join Properties
 

 

50.
(p. A5-302)
When a relationship is created, what kind of join does Access assign?

A. inner join

 

B. left outer join

 

C. right outer join

 

D. none of the above

When a relationship is created, Access assigns it an inner join type.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-03
Skill: Change the Join Type
 

 

51.
(p. A5-306)
Which of the following is a database object that allows you to write and attach code to different objects and controls in your database?

A. junction table

 

B. concatenated primary key

 

C. macro

 

D. Application Log

A macro is a database object that allows you to write and attach code to different objects and controls in your database.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: Creating and Using a Macro
 

 

52.
(p. A5-306)
Which of the following statements is true?

A. When a report or form opens, the On Open event occurs.

 

B. When a user hovers the mouse over a button on a form, the On Mouse Move event occurs.

 

C. When a user pushes a button on a form, the On Click event occurs.

 

D. all of the above

All of the statements are true.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: The Purpose of a Macro
 

 

53.
(p. A5-306)
When building a macro, which of the following must you do?

A. decide what event will cause the macro to execute

 

B. plan out the logic behind the steps, or tasks, the macro will perform

 

C. determine the type of macro needed and the best way to build the macro

 

D. all of the above

When creating a macro, you need to decide on the event that will cause the macro to execute; plan out the logic behind the steps, or tasks, the macro will perform; determine the type of macro needed; and choose the best way to build the macro.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: The Purpose of a Macro
 

 

54.
(p. A5-306)
Which of the following are attached to objects and controls, such as forms, reports, and command buttons, that are part of the user interface?

A. user interface macros

 

B. data macros

 

C. events

 

D. macro window

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

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: The Purpose of a Macro
 

 

55.
(p. A5-306)
Which of the following occur when an action happens to an object or control?

A. user interface macros

 

B. data macros

 

C. events

 

D. macro window

Events occur when an action happens to an object or control.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: The Purpose of a Macro
 

 

56.
(p. A5-307)
Which of the following are attached to tables?

A. user interface macros

 

B. data macros

 

C. events

 

D. macro window

Data macros are attached to tables.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: The Purpose of a Macro
 

 

57.
(p. A5-307)
Which of the following provides organizational structure to a macro?

A. program flow statement

 

B. Action

 

C. Comment

 

D. Macro Builder

A program flow statement provides organizational structure to a macro.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: The Macro Builder and Macro Design
 

 

58.
(p. A5-307)
Which of the following is the most common type of program flow statement?

A. program flow statement

 

B. Action

 

C. Comment

 

D. Macro Builder

The Comment program flow statement is the most common type of program flow statement.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-04
Skill: The Macro Builder and Macro Design
 

 

59.
(p. A5-307)
Which of the following is an individual command inside of a macro?

A. program flow statement

 

B. Action

 

C. Comment

 

D. Macro Builder

An Action is an individual command inside of a macro.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-04
Skill: The Macro Builder and Macro Design
 

 

60.
(p. A5-307)
Which of the following lets you write and edit he content of all macros?

A. program flow statement

 

B. Action

 

C. Comment

 

D. Macro Builder

You write and edit the content of all macros using the Macro Builder.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: The Macro Builder and Macro Design
 

 

61.
(p. A5-308)
Which of the following lets you integrate conditional logic into the execution of a macro?

A. group

 

B. argument

 

C. submacro

 

D. If block

An If block lets you integrate conditional logic into the execution of a macro.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-04
Skill: The Macro Builder and Macro Design
 

 

62.
(p. A5-308)
Which of the following is a piece of information needed to complete an action?

A. group

 

B. argument

 

C. submacro

 

D. If block

An argument is a piece of information needed to complete an action.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: The Macro Builder and Macro Design
 

 

63.
(p. A5-308)
Which of the following is a named block of actions?

A. group

 

B. argument

 

C. submacro

 

D. If block

A group is a named block of actions.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: The Macro Builder and Macro Design
 

 

64.
(p. A5-308)
Which of the following is a named, executable set of actions that perform a specific task?

A. group

 

B. argument

 

C. submacro

 

D. If block

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

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: The Macro Builder and Macro Design
 

 

65.
(p. A5-310)
Which of the following lets you paste an action?

A. Ctrl+C

 

B. Ctrl+X

 

C. Ctrl+V

 

D. Ctrl+P

Ctrl+V lets you paste an action.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: Copy an Action
 

 

66.
(p. A5-310)
Which of the following lets you copy an action?

A. Ctrl+C

 

B. Ctrl+X

 

C. Ctrl+V

 

D. Ctrl+P

Ctrl+C lets you copy an action.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-04
Skill: Copy an Action
 

 

67.
(p. A5-311)
Which of the following categories of user interface macros relates to changing the data?

A. Data Entry Operations

 

B. Data Import/Export

 

C. Database Objects

 

D. Filter/Query/Search

The Data Entry Operations category of user interface macros relates to changing the data.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: User Interface Macros
 

 

68.
(p. A5-311)
Which of the following categories of user interface macros relates to changing controls and objects in the database?

A. Data Entry Operations

 

B. Data Import/Export

 

C. Database Objects

 

D. Filter/Query/Search

The Database Objects category of user interface macros relates to changing controls and objects in the database.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: User Interface Macros
 

 

69.
(p. A5-311)
Which of the following categories of user interface macros relates to filtering, querying, and searching records?

A. Data Entry Operations

 

B. Data Import/Export

 

C. Database Objects

 

D. Filter/Query/Search

The Filter/Query/Search category of user interface macros relates to filtering, querying, and searching records.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-05
Skill: User Interface Macros
 

 

70.
(p. A5-311)
Which of the following categories of user interface macros relates to importing, exporting, sending, and collecting data?

A. Data Entry Operations

 

B. Data Import/Export

 

C. Database Objects

 

D. Filter/Query/Search

The Data Import/Export category of user interface macros relates to importing, exporting, sending, and collecting data.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: User Interface Macros
 

 

71.
(p. A5-311)
Which of the following categories of user interface macros relates to controlling what is shown on the screen?

A. Database Objects

 

B. Data Entry Operations

 

C. System Commands

 

D. User Interface Commands

The User Interface Commands category of user interface macros relates to controlling what is shown on the screen.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-05
Skill: User Interface Macros
 

 

72.
(p. A5-311)
Which of the following categories of user interface macros relates to changing the database system?

A. Database Objects

 

B. Data Entry Operations

 

C. System Commands

 

D. User Interface Commands

The System Commands category of user interface macros relates to changing the database system.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-05
Skill: User Interface Macros
 

 

73.
(p. A5-312)
Which of the following events executes when an object/control receives focus?

A. On Click

 

B. On Dbl Click

 

C. On Got Focus

 

D. On Enter

The On Got Focus event executes when an object/control receives focus.

 

Blooms: Remember
Difficulty: 3 Hard
SLO: 05-05
Skill: User Interface Macros
 

 

74.
(p. A5-312)
Which of the following events is only used with text box controls?

A. On Click

 

B. On Dbl Click

 

C. On Got Focus

 

D. On Enter

The On Enter event is only used with text box controls.

 

Blooms: Remember
Difficulty: 3 Hard
SLO: 05-05
Skill: User Interface Macros
 

 

75.
(p. A5-312)
Which of the following events executes after the object/control is clicked?

A. On Click

 

B. On Dbl Click

 

C. On Got Focus

 

D. On Enter

The On Click event executes after the object/control is clicked.

 

Blooms: Remember
Difficulty: 3 Hard
SLO: 05-05
Skill: User Interface Macros
 

 

76.
(p. A5-312)
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?

A. On Click

 

B. On Exit

 

C. On Got Focus

 

D. On Enter

The On Exit event executes immediately before a control, on a form or report, loses the focus to another control on the same form or report.

 

Blooms: Remember
Difficulty: 3 Hard
SLO: 05-05
Skill: User Interface Macros
 

 

77.
(p. A5-312)
Which of the following executes when the user releases a key that he or she was pressing?

A. On Mouse Up

 

B. On Key Up

 

C. On Open

 

D. On Activate

The On Key Up event executes when the user releases a key that he or she was pressing.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: User Interface Macros
 

 

78.
(p. A5-312)
Which of the following executes when a mouse button is released after having been pressed?

A. On Mouse Up

 

B. On Key Up

 

C. On Open

 

D. On Activate

The On Mouse Up event executes when a mouse button is released after having been pressed.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: User Interface Macros
 

 

79.
(p. A5-313)
Which of the following executes after a form or report is already opened and the object gains the focus?

A. On Mouse Up

 

B. On Key Up

 

C. On Open

 

D. On Activate

The On Activate event executes after a form or report is already opened and the object gains the focus.

 

Blooms: Remember
Difficulty: 3 Hard
SLO: 05-05
Skill: User Interface Macros
 

 

80.
(p. A5-313)
Which of the following executes when a form or report is opened?

A. On Mouse Up

 

B. On Key Up

 

C. On Open

 

D. On Activate

The On Open event executes when a form or report is opened.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: User Interface Macros
 

 

81.
(p. A5-315)
Which of the following runs when a database is first opened?

A. Open macro

 

B. AutoOpen macro

 

C. Exec macro

 

D. AutoExec macro

The AutoExec macro runs when a database is first opened.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-05
Skill: Build a Stand-Alone Macro
 

 

82.
(p. A5-315)
Which of the following is a way to run a stand-alone macro?

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

All of the methods listed will run a stand-alone macro.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-05
Skill: Run a Stand-Alone Macro
 

 

83.
(p. A5-315)
Which of the following keys lets you bypass the AutoExec macro when opening a database?

A. Ctrl

 

B. Alt

 

C. Shift

 

D. Esc

To bypass the execution of the AutoExec macro, a user can hold the Shift key down when opening the database.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-05
Skill: Build a Stand-Alone Macro
 

 

84.
(p. A5-320)
Which of the following executes after an existing record is changed?

A. After Update data macro event

 

B. CancelRecordChange data macro action

 

C. RaiseError data macro action

 

D. EditRecord data block macro action

The After Update data macro event executes after an existing record is changed.

 

Blooms: Remember
Difficulty: 3 Hard
SLO: 05-06
Skill: Data Macros
 

 

85.
(p. A5-321)
Which of the following changes the values in the existing record?

A. After Update data macro event

 

B. CancelRecordChange data macro action

 

C. RaiseError data macro action

 

D. EditRecord data block macro action

The EditRecord data block macro action changes the values in the existing record.

 

Blooms: Remember
Difficulty: 3 Hard
SLO: 05-06
Skill: Data Macros
 

 

86.
(p. A5-321)
Which of the following notifies the application that an error has occurred?

A. After Update data macro event

 

B. CancelRecordChange data macro action

 

C. RaiseError data macro action

 

D. EditRecord data block macro action

The RaiseError data macro action notifies the application that an error has occurred.

 

Blooms: Remember
Difficulty: 3 Hard
SLO: 05-06
Skill: Data Macros
 

 

87.
(p. A5-320)
Which of the following exits an EditRecord or CreateRecord data block and does not save the current record?

A. After Update data macro event

 

B. CancelRecordChange data macro action

 

C. RaiseError data macro action

 

D. EditRecord data block macro action

The CancelRecordChange data macro action exits an EditRecord or CreateRecord data block and does not save the current record.

 

Blooms: Remember
Difficulty: 3 Hard
SLO: 05-06
Skill: Data Macros
 

 

88.
(p. A5-328)
Which of the following in a named data macro allows you to pass data into the macro?

A. parameter

 

B. Single Step tool

 

C. Application Log

 

D. Macro Builder

Using a parameter in a named data macro allows you to pass data into the macro.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-07
Skill: Add Parameters to a Named Data Macro
 

 

89.
(p. A5-332)
In data macros, which of the following is available to help you debug a macro?

A. parameter

 

B. Single Step tool

 

C. Application Log

 

D. Macro Builder

In data macros, the Application Log is available to help you debug a macro.

 

Blooms: Remember
Difficulty: 2 Medium
SLO: 05-07
Skill: The Application Log Table
 

 

90.
(p. A5-331)
Which of the following can execute a macro one action, or step, at a time?

A. parameter

 

B. Single Step tool

 

C. Application Log

 

D. Macro Builder

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

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 05-07
Skill: The Single Step Tool
 

 

Essay Questions

91.
(p. A5-286)
What do you need in order to work with templates that run on the web? What templates are included with Access?

You can choose from several templates that are included with Access. Additionally, there are other templates available on Office.com. Some of the Access templates are designed to work on the web. When you create a database built from one of these templates, you must link it to a SharePoint server running Access Services. The non-web-based databases are designated as desktop databases in Access. The following database templates are included with Access: Desktop asset tracking, Desktop contacts, Desktop issue tracking, Desktop project management, and Desktop task management.

 

Blooms: Understand
Difficulty: 2 Medium
SLO: 05-01
Skill: Access Templates
 

 

92.
(p. A5-298)
Why are junction tables important?

Relational databases, like Access, do not directly support many-to-many relationships. You must create a junction or intersection table to match up the records. A junction table changes the many-to-many relationship into two one-to-many relationships. The guidelines for creating a junction table are fairly straightforward; however the application of these guidelines takes a little bit of practice.

 

Blooms: Understand
Difficulty: 3 Hard
SLO: 05-03
Skill: Implement a Many-to-Many Relationship
 

 

93.
(p. A5-300)
When working with tables in a many-to-many relationship, what guidelines will help ensure that your database will function correctly?

After designing the tables in a many-to-many relationship, you must create the tables and set the field properties in your Access database. Keep in mind the following tips to ensure your database will function correctly:

• Build the tables on the “one” side of the relationship first.
• Define the primary key for each of the “one” side tables.
• Build the junction table. The foreign key fields should be the same data type and size as the matching field in the “one” side table. If the primary key in a “one” side table is an AutoNumber data type, then the foreign key field should use a Number data type. Both fields should have the same number subtype, as indicated in the Field Size property.
• Define the primary key for the junction table. Remember that this table represents the “many” side of each relationship.

 

Blooms: Understand
Difficulty: 3 Hard
SLO: 05-03
Skill: Implement a Many-to-Many Relationship
 

 

94.
(p. A5-306)
When working with macros, what is an event? Provide a few examples.

Most macros execute because an event occurred in the database. An event is something that occurs when an action happens to an object or control. Events are occurring all of the time when you use a database. For example, when a report or form opens, the On Open event occurs. Likewise, when a user hovers the mouse over a button on a form, the On Mouse Move event occurs. Or when a user presses a button on a form, the On Click event occurs. Even table objects have events. For example, when a user changes a value in a field, the Before Change event occurs. The Event tab of the property sheet contains all the events that a form or report object, or a control placed on one of those objects, can respond to.

 

Blooms: Understand
Difficulty: 3 Hard
SLO: 05-04
Skill: The Purpose of a Macro
 

 

95.
(p. A5-307)
What is the Macro Builder used for? Describe the different components of the Macro Builder.

You write and edit the content of all macros using the Macro Builder. The Macro Builder contains the macro window, the area where you enter and edit the action steps of the macro. The right side of the Macro Builder displays the Action Catalog. The Action Catalog contains a Search box, Program Flow folder, and Actions folder. Use the Search box to locate an action. The Program Flow folder contains four macro statements. A program flow statement provides organizational structure to the macro. The Actions folder contains the different actions, grouped by category, that are available to add into a macro. An Action is an individual command inside of a macro. You can expand any of the categories in the macro window to view the specific actions.

 

Blooms: Understand
Difficulty: 3 Hard
SLO: 05-04
Skill: The Macro Builder and Macro Design
 

 

96.
(p. A5-310)
What is the difference between a stand-alone macro and an embedded macro?

Many of the macros you build will be attached to different parts of your database’s user interface. There are two types of user interface macros, stand-alone macros and embedded macros. A stand-alone macro is a separate Access object that appears in the Navigation pane. You can use a stand-alone macro independently of any other object. Additionally you can assign it to events in many different objects, allowing you to reuse the same macro. For example, you may want to create a message box to display the same message in many different forms or reports. You can create a stand-alone macro to display the message box and then attach that macro to each form or report. An embedded macro is attached to one specific object or control on an object. Embedded macros do not display in the Navigation pane. They are automatically executed by the object or control. Embedded macros are useful to automate tasks that are unique to a specific form or report in the database.

 

Blooms: Understand
Difficulty: 3 Hard
SLO: 05-05
Skill: Creating and Using User Interface Macros
 

 

97.
(p. A5-320)
What are data macros?

In contrast to user interface macros, data macros allow you to automate tasks related to the database tables. You can use data macros to ensure that the data in tables is accurate. Additionally, you can use them to automate tasks related to adding, deleting, or changing data. Because these macros are attached to a table, they execute any time a table’s data is updated.

 

Blooms: Understand
Difficulty: 2 Medium
SLO: 05-06
Skill: Building and Using Data Macros
 

 

98.
(p. A5-322)
What is a named data macro? What characteristics do named data macros have?

A named data macro is associated with a specific table, but it is not attached to any particular event. Instead, a named data macro is run by another event-driven macro or by a stand-alone macro. Named data macros have the following characteristics:

• They can use all of the data block actions and all of the event actions.
• They can use an additional action, SetReturnVar. SetReturnVar sets the value of a variable to be returned, or passed back, to the object that called the named data macro.
• They can use parameters, if needed. Parameters pass a value or an object reference into a macro. The name you assign to the parameter (in the name box) is the name you use to refer to the parameter inside of your macro.
• Named data macros are executed by using the RunDataMacro action to call the named data macro. Call a named data macro from an event-driven data macro or from a user interface macro.

 

Blooms: Understand
Difficulty: 3 Hard
SLO: 05-06
Skill: Named Data Macros
 

 

99.
(p. A5-326)
Explain what submacros are and why they are useful.

Occasionally you may need to create a submacro, which is a named, executable set of actions that perform a specific task. Once you create a submacro, you can call that submacro when you need to execute that task. Creating submacros can be a useful organizational approach; you end up with fewer separate, smaller macros when you use submacros. You can only create a submacro in a stand-alone macro, and the submacro must appear at the end of the stand-alone macro. The only thing that can follow a submacro is another submacro.

 

Blooms: Understand
Difficulty: 3 Hard
SLO: 05-07
Skill: Build a Submacro
 

 

100.
(p. A5-330)
Explain what you know about testing and debugging macros.

After you create a macro it is important to test it to ensure that it performs as planned. With some macros you may not be sure that they are performing as expected unless you develop a plan to test the macro. This may involve creating test data and test scenarios in your database. As you are developing your databases, you may need to create or modify the sample data in the table(s) in order to test all possible conditions of a macro. With some macros you may discover that a logic error results from selecting the wrong event to trigger the macro. For example, imagine that you want to create a stand-alone macro that executes whenever a form is closed. You have a Close Form button on every form, so it is logical to attach the macro to the On Click event of the button. However, you need to think of different scenarios and ways the database may be used. For example, is it possible that someone might close the form by clicking the X in the corner? In that situation, your macro would not be executed. In this case, the correct event to attach the macro to is the On Close event for the form. In addition to creating test data, there are other tools available to help you debug macros. With user interface macros, you can debug a macro by adding error handling into a macro or by using the single step utility. With data macros, you can use Error Handling and the application log table.

 

Blooms: Understand
Difficulty: 3 Hard
SLO: 05-07
Skill: Test and Debug a Macro
 

 

There are no reviews yet.

Add a review

Be the first to review “Microsoft Office Access 2013 Complete In Practice 1st Edition By Annette Easton and Randy Nordell – Test Bank”

Your email address will not be published. Required fields are marked *

Category:
Updating…
  • No products in the cart.