Enhanced Database Techniques Test Bank Answers Ch11

Exploring Microsoft Office 365, Access 2019 Comprehensive (Poatsy)

Chapter 11 Enhanced Database Techniques

1) Besides a stand-alone macro, what is the other type of macro?

A) Embedded

B) Inserted

C) Included

D) Automated

Diff: 1

Objective: A10.01 Understand the Purpose of a Macro

2) When a user enters, edits, or deletes data; Access determines that what has occurred?

A) Event

B) Action

C) Incident

D) Function

Diff: 2

Objective: A10.01 Understand the Purpose of a Macro

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

A) Stand-alone

B) Included

C) Embedded

D) Automatic

Diff: 2

Objective: A10.01 Understand the Purpose of a Macro

4) When an On Close event is triggered and there is no macro attached to the event, what does Access do?

A) It closes the form or report without doing anything.

B) The default On Close macro is run

C) The default Event macro is run.

D) There is no On Close event.

Diff: 3

Objective: A10.01 Understand the Purpose of a Macro

5) VBA stands for ________.

A) Virtual Basic for Applications

B) Visual Basic for Applications

C) Viewable Basic for Applications

D) Viewable Basics for Application

Diff: 1

Objective: A10.01 Understand the Purpose of a Macro

6) What is not a good task for a macro?

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

Diff: 2

Objective: A10.01 Understand the Purpose of a Macro

7) Besides an embedded macro, what is the other type of macro?

A) Included

B) Automated

C) Stand-alone

D) Inserted

Diff: 2

Objective: A10.01 Understand the Purpose of a Macro

8) Which is not an argument for the MessageBox action?

A) Message

B) Beep

C) Title

D) Repeat check box

Diff: 2

Objective: A10.02 Create a Stand-Alone Macro

9) A constant used to provide the output for an action is called a(n) ________.

A) function

B) argument

C) equation

D) variable

Diff: 3

Objective: A10.02 Create a Stand-Alone Macro

10) What is true about how Access handles macros when there are multiple actions in the macro?

A) They execute in a nested last-in, first-executed mode.

B) They execute according to an established priority list created by the user.

C) They execute according to an established priority list built into Access.

D) They execute in the order in which they display.

Diff: 3

Objective: A10.02 Create a Stand-Alone Macro

11) What was developed to make it easier to create or modify macros?

A) Macro Creator

B) Macro Developer

C) Macro Designer

D) Visual Basic for Applications (VBA)

Diff: 2

Objective: A10.02 Create a Stand-Alone Macro

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

A) Embedded macros

B) Stand-alone macros

C) Queries

D) Forms

Diff: 1

Objective: A10.01 Understand the Purpose of a Macro

13) Which event is triggered any time you enter or update data on a form?

A) After Update

B) After Enter

C) After Change

D) After Modification

Diff: 2

Objective: A10.03 Attach an Embedded Macro to an Event

14) Which of the following is not true about macros which have been converted to VBA?

A) They appear as modules in Access.

B) They do not appear on the Navigation Pane.

C) They appear on the Navigation Pane.

D) The code will perform the same tasks as the original macro.

Diff: 2

Objective: A10.03 Attach an Embedded Macro to an Event

15) What type of macros allow companies to apply business logic to a database?

A) Embedded

B) Stand-alone

C) Data

D) Event

Diff: 3

Objective: A10.04 Identify When to Use a Data Macro

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

A) Data

B) Embedded

C) Logic

D) Stand-alone

Diff: 2

Objective: A10.04 Identify When to Use a Data Macro

17) Event-driven data macros are triggered by what events?

A) Table

B) Form

C) Form control

D) Report

Diff: 2

Objective: A10.04 Identify When to Use a Data Macro

18) What type of macros associate programming logic to tables?

A) Data

B) Embedded

C) Stand-alone

D) Event

Diff: 3

Objective: A10.04 Identify When to Use a Data Macro

19) Which of the following is not considered a table event?

A) After Insert

B) After Update

C) During Delete

D) After Delete

Diff: 3

Objective: A10.05 Create an Event-Driven Data Macro

20) You can run a named data macro from within another macro by using what action?

A) ExecuteNamedDataMacro

B) ExecuteDataMacro

C) RunDataMacro

D) PerformDataMacro

Diff: 2

Objective: A10.06 Create a Named Data Macro

21) Which of the following is not considered to be an industry-leading DBMS?

A) SQL Server

B) Alpha database software

C) Oracle

D) SAP Sybase

Diff: 2

Objective: A10.07 Understand the Fundamentals of SQL

22) What company developed SQL?

A) Microsoft

B) Apple

C) Adobe

D) IBM

Diff: 3

Objective: A10.07 Understand the Fundamentals of SQL

23) When was SQL developed?

A) Early 1960s

B) Early 1970s

C) Late 1970s

D) Early 1980s

Diff: 3

Objective: A10.07 Understand the Fundamentals of SQL

24) SQL stands for what?

A) Structured Query Language

B) Structural Query Language

C) Simplified Query Language

D) Simple Query Language

Diff: 2

Objective: A10.07 Understand the Fundamentals of SQL

25) Which of the following is not correct about queries and SQL?

A) Access stores SQL statements in the background.

B) When you create a query, Access creates the SQL statements automatically.

C) SQL helps you ask a question of the data in your database.

D) SQL uses the same command set as VBA, except that it is used for queries instead of macros.

Diff: 3

Objective: A10.08 Interpret an SQL Select Statement

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

A) Keyword

B) Definition

C) Code word

D) ScreenTip

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

27) Which of the four is not considered one of the four basic words in SQL statements?

A) SELECT

B) WHERE

C) FROM

D) SORTED

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

28) Which one of the four keywords in SQL is used to establish criteria?

A) WHERE

B) ORDER BY

C) SELECT

D) FROM

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

29) Which one of the four keywords in SQL is used to specify what table the fields can be found?

A) SELECT

B) FROM

C) WHERE

D) ORDER BY

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

30) Which one of the four keywords in SQL is used to pick which fields will be in the query?

A) SELECT

B) FROM

C) WHERE

D) GROUP BY

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

31) Which one of the four keywords in SQL is used to determine how rows will be sorted?

A) SELECT

B) WHERE

C) ORDER BY

D) SORT

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

32) If your SQL query does not include a WHERE statement, then how many records will be selected?

A) All

B) None

C) Your SQL statement must include a WHERE statement.

D) Your query will pause upon execution for user entry, just like a parameter query.

Diff: 3

Objective: A10.08 Interpret an SQL Select Statement

33) In SQL, what is the default sort order when using the ORDER BY keyword?

A) There is no default sort order.

B) The order of data entry

C) Descending

D) Ascending

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

34) Which of the following is not an action which can be used in a data macro?

A) DeleteRecord

B) SetRecord

C) SendEmail

D) SetField

Diff: 3

Objective: A10.06 Create a Named Data Macro

35) Where is the normal location in an SQL statement for the WHERE keyword?

A) Before the FROM keyword

B) First

C) After the FROM keyword

D) Before the SELECT keyword

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

36) According the chapter, what is the easiest way to learn more advanced 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.

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

37) In SQL, what statement is used to retrieve data from a table?

A) RETRIEVE

B) UPDATE

C) GET

D) SELECT

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

38) What is normally the first SQL keyword in an SQL statement?

A) FROM

B) WHERE

C) SELECT

D) ORDER BY

Diff: 1

Objective: A10.09 Use an SQL Select Statement as a Record Source

39) When you create a command button, an embedded macro is automatically created.

Diff: 2

Objective: A10.03 Attach an Embedded Macro to an Event

40) A data macro performs a series of actions when a specific form event occurs.

Diff: 2

Objective: A10.05 Create an Event-Driven Data Macro

41) Stand-alone macros display as objects in the Navigation Pane.

Diff: 2

Objective: A10.01 Understand the Purpose of a Macro

42) It is easier to automate tasks by using a VBA procedure than by using macros.

Diff: 1

Objective: A10.01 Understand the Purpose of a Macro

43) Access creates macros automatically when you add certain controls to forms or reports.

Diff: 2

Objective: A10.01 Understand the Purpose of a Macro

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

Diff: 2

Objective: A10.01 Understand the Purpose of a Macro

45) When there are multiple actions in a macro, Access executes the actions according to an established priority list.

Diff: 3

Objective: A10.02 Create a Stand-Alone Macro

46) An embedded macro displays as an object in the Navigation Pane and can be run independently of other objects.

Diff: 2

Objective: A10.02 Create a Stand-Alone Macro

47) When you add an action to a macro and that action has several arguments, each of the arguments are required.

Diff: 2

Objective: A10.02 Create a Stand-Alone Macro

48) If you drag a table, query, form, or report to the Macro Designer, Access adds an action that opens the table, query, form, or report in edit/design mode.

Diff: 2

Objective: A10.02 Create a Stand-Alone Macro

49) You can use the Macro Designer to edit existing macros.

Diff: 1

Objective: A10.02 Create a Stand-Alone Macro

50) Macros can be converted to VBA.

Diff: 1

Objective: A10.03 Attach an Embedded Macro to an Event

51) The On Close event is triggered only if there is a macro attached to it.

Diff: 3

Objective: A10.01 Understand the Purpose of a Macro

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

Diff: 2

Objective: A10.03 Attach an Embedded Macro to an Event

53) Macros allow more complex functionality than just using VBA.

Diff: 2

Objective: A10.03 Attach an Embedded Macro to an Event

54) Embedded macros can be attached to an event on a control on a form or to the form itself.

Diff: 1

Objective: A10.03 Attach an Embedded Macro to an Event

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

Diff: 1

Objective: A10.04 Identify When to Use a Data Macro

56) Standalone macros are listed in the Navigation Pane.

Diff: 1

Objective: A10.01 Understand the Purpose of a Macro

57) A standalone macro can be used independent of other controls or objects.

Diff: 1

Objective: A10.01 Understand the Purpose of a Macro

58) The actions available in the Macro Designer are the same for data macros as for standalone or embedded macros.

Diff: 2

Objective: A10.04 Identify When to Use a Data Macro

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

Diff: 1

Objective: A10.04 Identify When to Use a Data Macro

60) Table validation rules can only work with one field.

Diff: 2

Objective: A10.04 Identify When to Use a Data Macro

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

Diff: 2

Objective: A10.04 Identify When to Use a Data Macro

62) To test a data macro, open the table and perform whatever the event was to which the macro has been attached and see if the proper action is performed.

Diff: 2

Objective: A10.05 Create an Event-Driven Data Macro

63) ExecuteDataMacro is an action that can be chosen in the Macro Designer.

Diff: 3

Objective: A10.06 Create a Named Data Macro

64) Since data macros are connected to tables, they can be attached to events in a form.

Diff: 3

Objective: A10.06 Create a Named Data Macro

65) Macros can be created to run other macros inside of them.

Diff: 1

Objective: A10.06 Create a Named Data Macro

66) Microsoft uses IBMs version of SQL in Access.

Diff: 2

Objective: A10.07 Understand the Fundamentals of SQL

67) The version of SQL that is found in Access has a graphical user interface to make creating SQL statements much easier.

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

68) Since SQL statements are considered text, you can copy and paste them just like any other text.

Diff: 1

Objective: A10.09 Use an SQL Select Statement as a Record Source

69) A(n) ________ macro is a macro that executes when an event attached to a control or object occurs.

Diff: 2

Objective: A10.01 Understand the Purpose of a Macro

70) There are two types of macros: stand-alone macros and ________ macros.

Diff: 2

Objective: A10.01 Understand the Purpose of a Macro

71) A(n) ________ macro is a database object that you create and use independently of other controls or objects.

Diff: 1

Objective: A10.01 Understand the Purpose of a Macro

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

Diff: 2

Objective: A10.01 Understand the Purpose of a Macro

73) A(n) ________ is a series of actions that can be programmed to automate tasks.

Diff: 1

Objective: A10.01 Understand the Purpose of a Macro

74) The Macro ________ makes it easier to create or modify macros.

Diff: 2

Objective: A10.02 Create a Stand-Alone Macro

75) A(n) ________ is a variable, constant, or expression that is used to produce the output for an action.

Diff: 2

Objective: A10.02 Create a Stand-Alone Macro

76) You can use the ________ Button Wizard to create an embedded macro automatically.

Diff: 2

Objective: A10.03 Attach an Embedded Macro to an Event

77) The ________ Update event is triggered any time you enter or update data on a form.

Diff: 2

Objective: A10.03 Attach an Embedded Macro to an Event

78) Event-driven data macros are triggered by ________ events.

Diff: 2

Objective: A10.04 Identify When to Use a Data Macro

79) A form that is based on a table that contains a(n) ________ macro inherits the logic of the table.

Diff: 2

Objective: A10.04 Identify When to Use a Data Macro

80) A(n) ________ data macro can be attached to an event in a form.

Diff: 2

Objective: A10.06 Create a Named Data Macro

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

Diff: 1

Objective: A10.07 Understand the Fundamentals of SQL

82) ________ are the individual steps that make up a macro.

Diff: 2

Objective: A10.02 Create a Stand-Alone Macro

83) In SQL, the ________ statement is used to retrieve data from a table.

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

84) The keyword used in SQL to establish criteria is ________.

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

85) A(n) ________ can be used to automate repetitive tasks or perform specific actions.

Diff: 2

Objective: A10.01 Understand the Purpose of a Macro

86) Macros that work with ““user interface”” objects, such as forms, reports, and buttons, are known as ________ macros.

Diff: 1

Objective: A10.01 Understand the Purpose of a Macro

87) ________ macros can help to validate and ensure the accuracy of data in a table.

Diff: 1

Objective: A10.04 Identify When to Use a Data Macro

88) ________ is the data retrieval and data manipulation language of all the industry-leading databases.

Diff: 2

Objective: A10.07 Understand the Fundamentals of SQL

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

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

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

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

91) An SQL ________ defines the purpose and the structure of an SQL statement.

Diff: 2

Objective: A10.08 Interpret an SQL Select Statement

92) When business logic requires the comparison of two or more fields, you need to use a(n) ________ macro.

Diff: 2

Objective: A10.04 Identify When to Use a Data Macro

93) Match the following terms with their descriptions:

I. SELECT keyword

II. WHERE keyword

III. ORDER BY keyword

IV. FROM keyword

V. SQL keyword

A. Determines any criteria that will be applied to records in an SQL statement

B. Determines the table or tables which will supply the fields used in an SQL statement

C. Determines the sort order in an SQL statement

D. Determines which fields will be included in an SQL statement

E. Defines the purpose and structure of an SQL statement

Diff: 1

Objective: Multiple Objectives

94) Match the following terms with their descriptions:

I. Argument

II. SQL

III. Stand-alone macro

IV. Data macro

V. SQL SELECT statement

A. Triggered by table events

B. A variable, constant, or expression that is used to produce the output for an action

C. Industry-standard language for working with data in databases

D. Statement used to retrieve data from tables

E. Can be used independently of other objects

Diff: 1

Objective: Multiple Objectives

95) Match the following terms with their descriptions:

I. Event

II. Macro

III. Macro Designer

IV. Embedded macro

V. Data macro

A. Used to automate tasks

B. Executes when an event is triggered

C. Triggered by table events

D. User interface for working with macros

E. Occurs when users open, use, or close forms and reports

Diff: 1

Objective: Multiple Objectives

96) Match the following terms with their descriptions:

I. SQL

II. Stand-alone macro

III. Macro

IV. Argument

V. Event

A. Developed by IBM in the early 70s

B. The MessageBox action has four of these

C. Is displayed on the Navigation Pane

D. Occurs when a user enters, edits, or deletes data

E. Automated series of actions

Diff: 1

Objective: Multiple Objectives

97) Match the following SQL keywords with their purposes:

I. SELECT

II. FROM

III. WHERE

IV. GROUP BY

V. ORDER BY

A. This is not a SQL keyword.

B. Specifies the sort order of the records

C. Specifies which table or tables contain the necessary fields

D. Specifies any criteria which will be applied to the records

E. Specifies which fields will be displayed

Diff: 1

Objective: Multiple Objectives

I. How many fields will be involved?

II. Where are these fields coming from?

III. What is the name of the new table?

IV. What are the criteria being applied?

V. How are the records being sorted?

A. Paydate

B. Contribution

C. Archive

D. Six

E. (((Contribution.SSN)="456667778"))

Diff: 3

Objective: A10.08 Interpret an SQL Select Statement

I. What would need to be done to delete the criteria?

II. What would need to be done to change the name of the new database to "Old"?

III. What would need to be done to sort the records in descending order?

IV. What would need to be done to sort by the default field?

V. What would need to be done to not create the new table?

A. Delete INTO Archive

B. Delete WHERE (((Contribution.SSN)="456667778"))

C. Delete ORDER BY Contribution.PayDate

D. ORDER BY Contribution.PayDate DESC

E. INTO Old

Diff: 3

Objective: A10.08 Interpret an SQL Select Statement

100) Match the SQL keywords at the top with what would follow those words from the list at the bottom to accomplish the following: display three fields (Field1, Field2, Field3) from the Sample table, sorted by Field1 in ascending order, and with only those records where Field2 equals "FrogLegs" and put all those in a new table called "Delicacies".

I. SELECT

II. WHERE

III. ORDER BY

IV. FROM

V. INTO

A. Sample

B. Field2="FrogLegs"

C. Field2 DESC

D. Field1, Field2, Field3

E. Delicacies

Diff: 3

Objective: A10.08 Interpret an SQL Select Statement