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

$35.00
Microsoft Office Access 2013 Complete In Practice 1st Edition By Annette Easton and Randy Nordell -Test Bank A+

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

$35.00
Microsoft Office Access 2013 Complete In Practice 1st Edition By Annette Easton and Randy Nordell -Test Bank A+

An action query makes a temporary change to the data in the database and the Undo button is available to reverse the action.

True False

2.Action queries do not display confirmation messages after the action is complete.

True False

3.It is a good practice to make a backup copy of your database before you run any action query.

True False

4.While you could modify each record individually in a table, an update query allows you to make the change to all records using one command.

True False

5.In an update query, unlike the Criteria row, the Update To row is not case sensitive.

True False

6.A delete query deletes the entire record.

True False

7.Unlike the resulting datasheet from a regular select query, you can edit the results from a crosstab query.

True False

8.After you create a crosstab query with the Crosstab Query Wizard, you can edit it in Design view and make changes to any of the selections made during the wizard.

True False

9.If duplicate records are present, two or more records in a table share the same values.

True False

10.Unmatched records are records in one table that do not contain any matching records in a related table.

True False

11.The Top Values query property limits the number of records that display in a query answer.

True False

12.The serial number is designated by the number of days the date is from January 1, 2000.

True False

13.The Now() function retrieves the current date, including the time, from your computer.

True False

14.When you are viewing a report in Layout or Print Preview view, the sections are not as obvious as they are in Design view.

True False

15.Creating a report in Layout view provides you with the most flexibility.

True False

16.An embedded query updates as you add and remove fields from the report.

True False

17.A parameter report asks the user to enter the specific criteria value for a field when the report is run.

True False

18.To change the size of a control on a report, simply select the control and use the sizing handles to adjust the size.

True False

19.If you want to perform the same modification on several controls, select them all before performing the change.

True False

20.A calculated control contains an expression in the Control Source property.

True False

21.Access evaluates expressions with the standard order of operations.

True False

22.When the report is in Design view, the expression is visible inside of the control.

True False

23.You can place calculated controls in any section of a report.

True False

24.A running total is not the same as an aggregate function.

True False

25.Concatenation combines different parts of an expression using the $ operator.

True False

26.The report from the “one” side of the relationship is the main report, while the report from the “many” side of the relationship is the subreport.

True False

27.You can build the main report and the subreport in any order, but the most common approach is to build the main report first.

True False

28.In a subreport, it is common to use a tabular layout for the fields.

True False

29.Use the Subform/Subreport button to launch the SubReport Wizard to add the subreport.

True False

30.When you open the main report, the subreport opens automatically because the objects are now attached.

True False

Multiple Choice Questions

31.How many types of action queries are there in Access?

A.two

B.three

C.four

D.five

32.Which of the following would you use to give all employees a 2% pay raise?

A.update query

B.append query

C.delete query

D.make table query

33.Which of the following makes changes to the data in a database?

A.update query

B.append query

C.delete query

D.make table query

34.Which of the following adds records into an existing table in a database?

A.update query

B.append query

C.delete query

D.make table query

35.Which of the following deletes records from a table in a database?

A.update query

B.append query

C.delete query

D.make table query

36.Which of the following would you use to create a history table, which you could then use to store old records?

A.update query

B.append query

C.delete query

D.make table query

37.Which of the following is a tool that makes it easier to build four different types of queries?

A.Query Wizard

B.crosstab query

C.find duplicates query

D.unmatched records query

38.Which of the following displays query results in a row/column format, which makes the data easier to read and understand?

A.Query Wizard

B.crosstab query

C.find duplicates query

D.unmatched records query

39.On how many dimensions does a crosstab query summarize data?

A.two

B.three

C.four

D.five

40.In a crosstab query, what is the maximum number of fields that you can include as row headings?

A.two

B.three

C.four

D.five

41.Which of the following statements is true about duplicate records?

A.All duplicated data is not bad.

B.Even when you practice good database design, you still may end up with duplicated data.

C.If duplicate records are present, two or more records in a table share the same values.

D.all of the above

42.Which of the following can you use in your criteria to look for partial matches?

A.parameter reports

B.subqueries

C.wildcards

D.controls

43.Which of the following can you use to compare records in two tables and determine which ones are not matched?

A.Query Wizard

B.crosstab query

C.find duplicates query

D.unmatched records query

44.Which of the following is not a fixed number choice provided by the Top Values query?

A.5

B.25

C.75

D.100

45.Which of the following is not a percentage value choice provided by the Top Values query?

A.5%

B.25%

C.75%

D.all

46.In a Top Values query, which of the following is necessary to return the top values?

A.sorting the results in ascending order

B.sorting the results in descending order

C.sorting on the primary key

D.the top values will be returned automatically

47.In a Top Values query, which of the following is necessary to return the bottom values?

A.sorting the results in ascending order

B.sorting the results in descending order

C.sorting on the primary key

D.the top values will be returned automatically

48.The serial number Access assigns to a date is designated by the number of days the date is from _______________.

A.January 1, 1900

B.January 1, 2000

C.December 31, 1900

D.December 31, 2000

49.Which of the following Access date functions determines the difference between two dates?

A.DateSerial()

B.DateAdd()

C.DateDiff()

D.DatePart()

50.Which of the following Access date functions determines a specific piece, or interval, of a date?

A.DateSerial()

B.DateAdd()

C.DateDiff()

D.DatePart()

51.Which of the following Access date functions converts values into a date value?

A.DateSerial()

B.DateAdd()

C.DateDiff()

D.DatePart()

52.Which of the following Access date functions adds to a date?

A.DateSerial()

B.DateAdd()

C.DateDiff()

D.DatePart()

53.Which of the following might you use when you have a common starting point (the original query) but want to customize it for additional purposes (the additional query)?

A.parameter report

B.subquery

C.wildcard

D.control

54.Which of the following report sections prints column headings, page numbers, or dates at the top of every page?

A.Report Footer

B.Page Header

C.Page Footer

D.Group Header

55.Which of the following report sections prints page numbers or dates at the bottom of each page?

A.Report Footer

B.Page Header

C.Page Footer

D.Group Header

56.Which of the following report sections prints the group title/value at the top of each group?

A.Report Footer

B.Page Header

C.Page Footer

D.Group Header

57.Which of the following report sections prints report totals or other information at the end of the report?

A.Report Footer

B.Page Header

C.Page Footer

D.Group Header

58.Which of the following does Access automatically include when you create a report in Design view?

A.Page Header section

B.Detail section

C.Page Footer section

D.all of the above

59.Which of the following regulates which database fields are available in a report?

A.Top Values query

B.Record Source property

C.Structured Query Language

D.Query Wizard

60.Which of the following can the data fields for a report come from?

A.reports

B.queries

C.tables

D.both B and C

61.Which of the following is always used to surround parameter text in a parameter report?

A.square brackets

B.plus signs

C.parentheses

D.dollar signs

62.While displaying a report in Design view, which of the following opens the Property Sheet?

A.F2

B.F4

C.F6

D.F8

63.Which of the following are controls that you can add to a report?

A.text boxes

B.labels

C.lines

D.all of the above

64.Which of the following font characteristics of a control can you change in the Property Sheet of that control?

A.Font Name

B.Font Size

C.Font Underline

D.all of the above

65.Which of the following formatting properties of a control sets the font color?

A.Decimal Places

B.Visible

C.Back Color

D.Fore Color

66.Which of the following formatting properties of a control sets a fixed number of decimal places to display?

A.Decimal Places

B.Visible

C.Back Color

D.Fore Color

67.Which of the following formatting properties of a control determines whether a control shows in Report view or Print Preview view?

A.Decimal Places

B.Visible

C.Back Color

D.Fore Color

68.Which of the following formatting properties of a control sets the fill color of a control?

A.Decimal Places

B.Visible

C.Back Color

D.Fore Color

69.Which of the following lets you select more than one control at once?

A.Ctrl

B.Alt

C.Shift

D.Esc

70.Which of the following can you use calculated controls for?

A.mathematical equations

B.aggregate functions

C.text-based equations

D.all of the above

71.Which of the following must go at the beginning of calculated expressions in Access?

A.=

B.+

C.(

D.[

72.Which of the following must you use to view the expression inside a calculated control?

A.Layout view

B.Design view

C.Print Preview view

D.Page Layout view

73.Which of the following must fields be enclosed with in a calculated expression?

A.square brackets

B.plus signs

C.parentheses

D.dollar signs

74.Which of the following can a running total field show?

A.running balance

B.cumulative total

C.counting

D.all of the above

75.What is the default value of the Running Sum property?

A.No

B.Over Group

C.Over All

D.none of the above

76.To number rows using a running total, which of the following should you type in the Control Source property?

A.=1

B.=2

C.=3

D.=4

77.Which of the following operators is used to concatenate data?

A.[

B.+

C.&

D.(

78.Which of the following would you use to combine the first and last name fields to produce a more readable report?

A.concatenation

B.running total

C.one-to-many relationship

D.SQL

79.In a concatenation formula, how would you insert a comma and a blank space between two fields?

A.&” “&

B.&”, “&

C.=”, “&

D.[“, “]

80.Which of the following would you use to hide repeated values in a report?

A.concatenation formulas

B.calculated controls

C.Hide Duplicates property

D.Delete query

81.Which of the following is inserted within another report?

A.subreport

B.main report

C.separate object

D.SQL view

82.In a report that shows data from a one-to-many relationship, which of the following is a report from the “one” side of the relationship?

A.subreport

B.main report

C.separate object

D.SQL object

83.Once you add a subreport, it still exists as a ____________________.

A.subreport

B.main report

C.separate object

D.SQL view

84.What steps are involved in create a report that includes a subreport?

A.Create the main report.

B.Create the subreport.

C.Add the subreport to the main report.

D.all of the above

85.Which of the following views will you want to use when you work to edit a report?

A.Design view

B.Layout view

C.Print Preview view

D.all of the above

86.Which of the following is a common report modification?

A.adjust the size and spacing of the text box and label controls

B.modify font characteristics or formatting

C.change the border property or back color property of the controls or sections

D.all of the above

87.When using an aggregate function in a report, where should you place the calculation?

A.Report Header section

B.Report Footer section

C.Detail section

D.both A and B

88.Which of the following statement is true about action queries?

A.An action query makes a permanent change to the data in the database.

B.You can use the Undo button to reverse the action.

C.It is not recommended to make a backup copy of your database before you run an action query.

D.all of the above

89.Which of the following statements is not true about append queries?

A.An append query moves records from one table to another.

B.An append query puts a copy of the records into a destination table.

C.An append query adds records into an existing table in a database.

D.Using an append query, you can copy records from one or multiple tables into the destination table.

90.Which of the following statements is true about queries?

A.As the number of records in your database increases, you can use query properties to limit the number of records that display in a result.

B.As the processing of your database becomes more sophisticated, you may need to write queries that use more complex functions.

C.Queries provide a great deal of power and flexibility to help you accomplish many tasks in your database.

D.all of the above

Essay Questions

91.Provide some examples of when you might need to use an action query.

92.Why is it a good idea to make a backup copy of your database before running any action query?

93.What is a crosstab query? Why are crosstab queries useful?

94.Describe some situations in which you may end up with duplicated data.

95.What is a subquery? Why are subqueries helpful?

96.What is a parameter report? Why are parameter reports useful?

97.Why is it sometimes necessary to change the height of a report section?

98.What are calculated controls? Explain what you know about using calculated controls in reports.

99.What is concatenation and why might you want to use it?

100.What is a subreport? How do they work?

Access Chapter 06 Creating Advanced Queries and Reports and Using SQL Answer Key

True / False Questions

1.
(p. A6-370)
An action query makes a temporary change to the data in the database and the Undo button is available to reverse the action.

FALSE

An action query makes a permanent change to the data in the database and the Undo button is not available to reverse the action.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-01
Skill: Understand Action Queries

2.
(p. A6-370)
Action queries do not display confirmation messages after the action is complete.

TRUE

Action queries do not display confirmation messages after the action is complete.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-01
Skill: Understand Action Queries

3.
(p. A6-370)
It is a good practice to make a backup copy of your database before you run any action query.

TRUE

It is a good practice to make a backup copy of your database before you run any action query.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-01
Skill: Understand Action Queries

4.
(p. A6-371)
While you could modify each record individually in a table, an update query allows you to make the change to all records using one command.

TRUE

While you could modify each record individually in a table, an update query allows you to make the change to all records using one command.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-01
Skill: Create an Update Query

5.
(p. A6-372)
In an update query, unlike the Criteria row, the Update To row is not case sensitive.

FALSE

In an update query, unlike the Criteria row, the Update To row is case sensitive.

Blooms: Remember
Difficulty: 2 Medium
SLO: 06-01
Skill: Create an Update Query

6.
(p. A6-374)
A delete query deletes the entire record.

TRUE

A delete query deletes the entire record.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-01
Skill: Create a Delete Query

7.
(p. A6-377)
Unlike the resulting datasheet from a regular select query, you can edit the results from a crosstab query.

FALSE

Unlike the resulting datasheet from a regular select query, you cannot edit the results from a crosstab query.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-02
Skill: Understand and Build a Crosstab Query

8.
(p. A6-379)
After you create a crosstab query with the Crosstab Query Wizard, you can edit it in Design view and make changes to any of the selections made during the wizard.

TRUE

After you create a crosstab query with the Crosstab Query Wizard, you can edit it in Design view and make changes to any of the selections made during the wizard.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-02
Skill: Understand and Build a Crosstab Query

9.
(p. A6-380)
If duplicate records are present, two or more records in a table share the same values.

TRUE

If duplicate records are present, two or more records in a table share the same values.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-02
Skill: Find Duplicate Records

10.
(p. A6-381)
Unmatched records are records in one table that do not contain any matching records in a related table.

TRUE

Unmatched records are records in one table that do not contain any matching records in a related table.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-03
Skill: Find Unmatched Records

11.
(p. A6-383)
The Top Values query property limits the number of records that display in a query answer.

TRUE

The Top Values query property limits the number of records that display in a query answer.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-03
Skill: Find the Top Values in a Query

12.
(p. A6-384)
The serial number is designated by the number of days the date is from January 1, 2000.

FALSE

The serial number is designated by the number of days the date is from January 1, 1900.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-03
Skill: Understand and Use Date Functions in a Query

13.
(p. A6-385)
The Now() function retrieves the current date, including the time, from your computer.

TRUE

The Now() function retrieves the current date, including the time, from your computer.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-03
Skill: Understand and Use Date Functions in a Query

14.
(p. A6-390)
When you are viewing a report in Layout or Print Preview view, the sections are not as obvious as they are in Design view.

TRUE

When you are viewing a report in Layout or Print Preview view, the sections are not as obvious as they are in Design view.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Understand Report Sections

15.
(p. A6-392)
Creating a report in Layout view provides you with the most flexibility.

FALSE

Creating a report in Design view provides you with the most flexibility.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Create a Report in Design View

16.
(p. A6-393)
An embedded query updates as you add and remove fields from the report.

TRUE

An embedded query updates as you add and remove fields from the report.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Understand the Report Data Source

17.
(p. A6-395)
A parameter report asks the user to enter the specific criteria value for a field when the report is run.

TRUE

A parameter report asks the user to enter the specific criteria value for a field when the report is run.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Create a Parameter Report

18.
(p. A6-396)
To change the size of a control on a report, simply select the control and use the sizing handles to adjust the size.

TRUE

To change the size of a control on a report, simply select the control and use the sizing handles to adjust the size.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-05
Skill: Adjust the Size of a Control

19.
(p. A6-399)
If you want to perform the same modification on several controls, select them all before performing the change.

TRUE

If you want to perform the same modification on several controls, select them all before performing the change.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-05
Skill: Use the Size/Space Button with Multiple Controls

20.
(p. A6-400)
A calculated control contains an expression in the Control Source property.

TRUE

A calculated control contains an expression in the Control Source property.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Using Calculated Controls on a Report

21.
(p. A6-400)
Access evaluates expressions with the standard order of operations.

TRUE

Access evaluates expressions with the standard order of operations.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Understand and Perform Calculations

22.
(p. A6-400)
When the report is in Design view, the expression is visible inside of the control.

TRUE

When the report is in Design view, the expression is visible inside of the control.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Understand and Perform Calculations

23.
(p. A6-400)
You can place calculated controls in any section of a report.

TRUE

You can place calculated controls in any section of a report.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Understand and Perform Calculations

24.
(p. A6-401)
A running total is not the same as an aggregate function.

TRUE

A running total is not the same as an aggregate function.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Use a Running Total

25.
(p. A6-402)
Concatenation combines different parts of an expression using the $ operator.

FALSE

Concatenation combines different parts of an expression using the & operator.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Use a Running Total

26.
(p. A6-407)
The report from the “one” side of the relationship is the main report, while the report from the “many” side of the relationship is the subreport.

TRUE

The report from the “one” side of the relationship is the main report, while the report from the “many” side of the relationship is the subreport.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-07
Skill: Understand Subreports

27.
(p. A6-408)
You can build the main report and the subreport in any order, but the most common approach is to build the main report first.

TRUE

You can build the main report and the subreport in any order, but the most common approach is to build the main report first.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-07
Skill: Create a Report that Includes a Subreport

28.
(p. A6-408)
In a subreport, it is common to use a tabular layout for the fields.

TRUE

In a subreport, it is common to use a tabular layout for the fields.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-07
Skill: Create a Report that Includes a Subreport

29.
(p. A6-409)
Use the Subform/Subreport button to launch the SubReport Wizard to add the subreport.

TRUE

Use the Subform/Subreport button to launch the SubReport Wizard to add the subreport.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-07
Skill: Create a Report that Includes a Subreport

30.
(p. A6-412)
When you open the main report, the subreport opens automatically because the objects are now attached.

TRUE

When you open the main report, the subreport opens automatically because the objects are now attached.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-07
Skill: Customize the Main Report and Subreport

Multiple Choice Questions

31.
(p. A6-370)
How many types of action queries are there in Access?

A.two

B.three

C.four

D.five

There are four types of action queries in Access.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-01
Skill: Creating and Using Action Queries

32.
(p. A6-371)
Which of the following would you use to give all employees a 2% pay raise?

A.update query

B.append query

C.delete query

D.make table query

You would use an update query to give all employees a 2% pay raise.

Blooms: Remember
Difficulty: 2 Medium
SLO: 06-01
Skill: Create an Update Query

33.
(p. A6-371)
Which of the following makes changes to the data in a database?

A.update query

B.append query

C.delete query

D.make table query

An update query makes changes to the data in a database.

Blooms: Remember
Difficulty: 2 Medium
SLO: 06-01
Skill: Create an Update Query

34.
(p. A6-372)
Which of the following adds records into an existing table in a database?

A.update query

B.append query

C.delete query

D.make table query

An append query adds records into an existing table in a database.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-01
Skill: Create an Append Query

35.
(p. A6-374)
Which of the following deletes records from a table in a database?

A.update query

B.append query

C.delete query

D.make table query

A delete query deletes records from a table in a database.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-01
Skill: Create a Delete Query

36.
(p. A6-375)
Which of the following would you use to create a history table, which you could then use to store old records?

A.update query

B.append query

C.delete query

D.make table query

You would use the make table query to create a history table, which you could use to store old records.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-01
Skill: Create a Make Table Query

37.
(p. A6-376)
Which of the following is a tool that makes it easier to build four different types of queries?

A.Query Wizard

B.crosstab query

C.find duplicates query

D.unmatched records query

The Query Wizard is a tool that makes it easier to build four different types of queries.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-02
Skill: Exploring the Query Wizard

38.
(p. A6-376)
Which of the following displays query results in a row/column format, which makes the data easier to read and understand?

A.Query Wizard

B.crosstab query

C.find duplicates query

D.unmatched records query

A crosstab query displays query results in a row/column format, which makes the data easier to read and understand.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-02
Skill: Understand and Build a Crosstab Query

39.
(p. A6-376)
On how many dimensions does a crosstab query summarize data?

A.two

B.three

C.four

D.five

A crosstab query summaries data on two dimensions.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-02
Skill: Understand and Build a Crosstab Query

40.
(p. A6-377)
In a crosstab query, what is the maximum number of fields that you can include as row headings?

A.two

B.three

C.four

D.five

In a crosstab query, the maximum number of fields that you can include as row headings is three.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-02
Skill: Understand and Build a Crosstab Query

41.
(p. A6-380)
Which of the following statements is true about duplicate records?

A.All duplicated data is not bad.

B.Even when you practice good database design, you still may end up with duplicated data.

C.If duplicate records are present, two or more records in a table share the same values.

D.all of the above

All of the statements are true.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-02
Skill: Find Duplicate Records

42.
(p. A6-380)
Which of the following can you use in your criteria to look for partial matches?

A.parameter reports

B.subqueries

C.wildcards

D.controls

You can use wildcards in your criteria to look for partial matches.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-02
Skill: Find Duplicate Records

43.
(p. A6-381)
Which of the following can you use to compare records in two tables and determine which ones are not matched?

A.Query Wizard

B.crosstab query

C.find duplicates query

D.unmatched records query

You can use an unmatched records query to compare records in two tables and determine which ones are not matched.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-02
Skill: Find Unmatched Records

44.
(p. A6-383)
Which of the following is not a fixed number choice provided by the Top Values query?

A.5

B.25

C.75

D.100

The number 75 is not a fixed number choice provided by the Top Values query.

Blooms: Remember
Difficulty: 2 Medium
SLO: 06-03
Skill: Find the Top Values in a Query

45.
(p. A6-383)
Which of the following is not a percentage value choice provided by the Top Values query?

A.5%

B.25%

C.75%

D.all

The percentage 75% is not a percentage value choice provided by the Top Values query.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-03
Skill: Find the Top Values in a Query

46.
(p. A6-383)
In a Top Values query, which of the following is necessary to return the top values?

A.sorting the results in ascending order

B.sorting the results in descending order

C.sorting on the primary key

D.the top values will be returned automatically

In a Top Values query, to have the query results return the top values, you must sort the query results in descending order on the desired field.

Blooms: Remember
Difficulty: 2 Medium
SLO: 06-03
Skill: Find the Top Values in a Query

47.
(p. A6-383)
In a Top Values query, which of the following is necessary to return the bottom values?

A.sorting the results in ascending order

B.sorting the results in descending order

C.sorting on the primary key

D.the top values will be returned automatically

In a Top Values query, to have the query results return the bottom values, you must sort the query results in ascending order on the desired field.

Blooms: Remember
Difficulty: 2 Medium
SLO: 06-03
Skill: Find the Top Values in a Query

48.
(p. A6-384)
The serial number Access assigns to a date is designated by the number of days the date is from _______________.

A.January 1, 1900

B.January 1, 2000

C.December 31, 1900

D.December 31, 2000

The serial number Access assigns to a date is designated by the number of days the date is from January 1, 1900.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-03
Skill: Understand and Use Date Functions in a Query

49.
(p. A6-385)
Which of the following Access date functions determines the difference between two dates?

A.DateSerial()

B.DateAdd()

C.DateDiff()

D.DatePart()

The DateDiff() function determines the difference between two dates.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-03
Skill: Access Date Functions

50.
(p. A6-385)
Which of the following Access date functions determines a specific piece, or interval, of a date?

A.DateSerial()

B.DateAdd()

C.DateDiff()

D.DatePart()

The DatePart() function determines a specific piece, or interval, of a date.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-03
Skill: Access Date Functions

51.
(p. A6-385)
Which of the following Access date functions converts values into a date value?

A.DateSerial()

B.DateAdd()

C.DateDiff()

D.DatePart()

The DateSerial() date function converts values into a date value.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-03
Skill: Access Date Functions

52.
(p. A6-385)
Which of the following Access date functions adds to a date?

A.DateSerial()

B.DateAdd()

C.DateDiff()

D.DatePart()

The DateAdd() function adds to a date.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-03
Skill: Access Date Functions

53.
(p. A6-386)
Which of the following might you use when you have a common starting point (the original query) but want to customize it for additional purposes (the additional query)?

A.parameter report

B.subquery

C.wildcard

D.control

It is helpful to use a subquery when you have a common starting point (the original query) but want to customize it for additional purposes (the additional query).

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-03
Skill: Create a Subquery

54.
(p. A6-390)
Which of the following report sections prints column headings, page numbers, or dates at the top of every page?

A.Report Footer

B.Page Header

C.Page Footer

D.Group Header

The Page Header report section prints column headings, page numbers, or dates at the top of every page.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Understand Report Sections

55.
(p. A6-390)
Which of the following report sections prints page numbers or dates at the bottom of each page?

A.Report Footer

B.Page Header

C.Page Footer

D.Group Header

The Page Footer report section prints page numbers or dates at the bottom of each page.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Understand Report Sections

56.
(p. A6-390)
Which of the following report sections prints the group title/value at the top of each group?

A.Report Footer

B.Page Header

C.Page Footer

D.Group Header

The Group Header report section prints the group title/value at the top of each group.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Understand Report Sections

57.
(p. A6-390)
Which of the following report sections prints report totals or other information at the end of the report?

A.Report Footer

B.Page Header

C.Page Footer

D.Group Header

The Report Footer report section prints report totals or other information at the end of the report.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Understand Report Sections

58.
(p. A6-391)
Which of the following does Access automatically include when you create a report in Design view?

A.Page Header section

B.Detail section

C.Page Footer section

D.all of the above

When you create a report in Design view, Access automatically includes Page Header, Detail, and Page Footer sections.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Add or Delete Page and Report Sections in Design View

59.
(p. A6-393)
Which of the following regulates which database fields are available in a report?

A.Top Values query

B.Record Source property

C.Structured Query Language

D.Query Wizard

The Record Source property regulates which database fields are available in a report.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Understand the Report Data Source

60.
(p. A6-394)
Which of the following can the data fields for a report come from?

A.reports

B.queries

C.tables

D.both B and C

The data fields for a report can come from tables or queries.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Add and Delete Fields in Design View

61.
(p. A6-395)
Which of the following is always used to surround parameter text in a parameter report?

A.square brackets

B.plus signs

C.parentheses

D.dollar signs

Square brackets are always used to surround parameter text in a parameter report.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Create a Parameter Report

62.
(p. A6-395)
While displaying a report in Design view, which of the following opens the Property Sheet?

A.F2

B.F4

C.F6

D.F8

While displaying a report in Design view, F4 opens the Property Sheet.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-04
Skill: Create a Parameter Report

63.
(p. A6-396)
Which of the following are controls that you can add to a report?

A.text boxes

B.labels

C.lines

D.all of the above

You can add controls such as text boxes, labels, images, or lines to a report.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-05
Skill: Add a Control to a Report

64.
(p. A6-397)
Which of the following font characteristics of a control can you change in the Property Sheet of that control?

A.Font Name

B.Font Size

C.Font Underline

D.all of the above

You can change the font characteristics of a control in the Property Sheet of that control by changing the Font Name, Font Size, Text Align, Font Weight, Font Underline, Font Italic, or Fore Color properties.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-05
Skill: Change the Font Characteristics of a Control

65.
(p. A6-398)
Which of the following formatting properties of a control sets the font color?

A.Decimal Places

B.Visible

C.Back Color

D.Fore Color

The Fore Color formatting property sets the font color.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-05
Skill: Change Formatting Properties of a Control

66.
(p. A6-398)
Which of the following formatting properties of a control sets a fixed number of decimal places to display?

A.Decimal Places

B.Visible

C.Back Color

D.Fore Color

The Decimal Places formatting property sets a fixed number of decimal places to display.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-05
Skill: Change Formatting Properties of a Control

67.
(p. A6-398)
Which of the following formatting properties of a control determines whether a control shows in Report view or Print Preview view?

A.Decimal Places

B.Visible

C.Back Color

D.Fore Color

The Visible formatting property of a control determines whether a control shows in Report view or Print Preview view.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-05
Skill: Change Formatting Properties of a Control

68.
(p. A6-398)
Which of the following formatting properties of a control sets the fill color of a control?

A.Decimal Places

B.Visible

C.Back Color

D.Fore Color

The Back Color formatting property of a control sets the fill color of a control.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-05
Skill: Change Formatting Properties of a Control

69.
(p. A6-399)
Which of the following lets you select more than one control at once?

A.Ctrl

B.Alt

C.Shift

D.Esc

The Shift key lets you select more than one control at once.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-05
Skill: Use the Size/Space Button with Multiple Controls

70.
(p. A6-400)
Which of the following can you use calculated controls for?

A.mathematical equations

B.aggregate functions

C.text-based equations

D.all of the above

You can use calculated controls to show the results of a mathematical equation, an aggregate function, or a text-based equation.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Using Calculated Controls on a Report

71.
(p. A6-400)
Which of the following must go at the beginning of calculated expressions in Access?

A.=

B.+

C.(

D.[

An equals sign (=) must go at the beginning of calculated expressions in Access.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Understand and Perform Calculations

72.
(p. A6-400)
Which of the following must you use to view the expression inside a calculated control?

A.Layout view

B.Design view

C.Print Preview view

D.Page Layout view

You must use Design view to view the expression inside a calculated control.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Understand and Perform Calculations

73.
(p. A6-400)
Which of the following must fields be enclosed with in a calculated expression?

A.square brackets

B.plus signs

C.parentheses

D.dollar signs

Enclose any fields used in a calculated expression inside square brackets.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Understand and Perform Calculations

74.
(p. A6-401)
Which of the following can a running total field show?

A.running balance

B.cumulative total

C.counting

D.all of the above

You can use a running total field to show a running balance, cumulative total, or counting.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Use a Running Total

75.
(p. A6-401)
What is the default value of the Running Sum property?

A.No

B.Over Group

C.Over All

D.none of the above

No is the default value in the Running Sum property, indicating that the text box is not a running total.

Blooms: Remember
Difficulty: 2 Medium
SLO: 06-06
Skill: Use a Running Total

76.
(p. A6-402)
To number rows using a running total, which of the following should you type in the Control Source property?

A.=1

B.=2

C.=3

D.=4

To number rows using a running total, enter =1 in the Control Source property.

Blooms: Remember
Difficulty: 2 Medium
SLO: 06-06
Skill: Number Rows in a Report

77.
(p. A6-402)
Which of the following operators is used to concatenate data?

A.[

B.+

C.&

D.(

Concatenation combines different parts of an expression using the & operator.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Concatenate Text Data

78.
(p. A6-402)
Which of the following would you use to combine the first and last name fields to produce a more readable report?

A.concatenation

B.running total

C.one-to-many relationship

D.SQL

You would use concatenation to combine the first and last name fields to produce a more readable report.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Concatenate Text Data

79.
(p. A6-402)
In a concatenation formula, how would you insert a comma and a blank space between two fields?

A.&” “&

B.&”, “&

C.=”, “&

D.[“, “]

In a concatenation formula, &”, “& would insert a comma and a blank space between two fields.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Concatenate Text Data

80.
(p. A6-403)
Which of the following would you use to hide repeated values in a report?

A.concatenation formulas

B.calculated controls

C.Hide Duplicates property

D.Delete query

To hide repeated values in a report, use the Hide Duplicates property.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-06
Skill: Hide Repeated Values

81.
(p. A6-407)
Which of the following is inserted within another report?

A.subreport

B.main report

C.separate object

D.SQL view

A subreport is a report inserted within another report.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-07
Skill: Understand Subreports

82.
(p. A6-407)
In a report that shows data from a one-to-many relationship, which of the following is a report from the “one” side of the relationship?

A.subreport

B.main report

C.separate object

D.SQL object

In a report that shows data from a one-to-many relationship, the report from the “one” side of the relationship is the main report.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-07
Skill: Understand Subreports

83.
(p. A6-407)
Once you add a subreport, it still exists as a ____________________.

A.subreport

B.main report

C.separate object

D.SQL view

Once you add a subreport, it still exists as a separate object.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-07
Skill: Understand Subreports

84.
(p. A6-408)
What steps are involved in create a report that includes a subreport?

A.Create the main report.

B.Create the subreport.

C.Add the subreport to the main report.

D.all of the above

All of the steps listed above are involved with creating a subreport.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-07
Skill: Create a Report that Includes a Subreport

85.
(p. A6-412)
Which of the following views will you want to use when you work to edit a report?

A.Design view

B.Layout view

C.Print Preview view

D.all of the above

Anticipate switching back and forth frequently between Design view, Layout view, and Print Preview view as you work to edit a report.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-07
Skill: Customize the Main Report and Subreport

86.
(p. A6-412)
Which of the following is a common report modification?

A.adjust the size and spacing of the text box and label controls

B.modify font characteristics or formatting

C.change the border property or back color property of the controls or sections

D.all of the above

All of the tasks are commonly performed when modifying reports.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-07
Skill: Customize the Main Report and Subreport

87.
(p. A6-412)
When using an aggregate function in a report, where should you place the calculation?

A.Report Header section

B.Report Footer section

C.Detail section

D.both A and B

To use an aggregate function, place the calculation in either the Report Header or Report Footer section of the subreport.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-07
Skill: Customize the Main Report and Subreport

88.
(p. A6-370)
Which of the following statement is true about action queries?

A.An action query makes a permanent change to the data in the database.

B.You can use the Undo button to reverse the action.

C.It is not recommended to make a backup copy of your database before you run an action query.

D.all of the above

An action query makes a permanent change to the data in the database.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-01
Skill: Understand Action Queries

89.
(p. A6-372)
Which of the following statements is not true about append queries?

A.An append query moves records from one table to another.

B.An append query puts a copy of the records into a destination table.

C.An append query adds records into an existing table in a database.

D.Using an append query, you can copy records from one or multiple tables into the destination table.

An append query does not move records from one table to another; rather it puts a copy of the records into a destination table.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-01
Skill: Create an Append Query

90.
(p. A6-383)
Which of the following statements is true about queries?

A.As the number of records in your database increases, you can use query properties to limit the number of records that display in a result.

B.As the processing of your database becomes more sophisticated, you may need to write queries that use more complex functions.

C.Queries provide a great deal of power and flexibility to help you accomplish many tasks in your database.

D.all of the above

All of the statements are true.

Blooms: Remember
Difficulty: 1 Easy
SLO: 06-03
Skill: Creating Advanced Queries and Changing Query Properties

Essay Questions

91.
(p. A6-370)
Provide some examples of when you might need to use an action query.

When creating action queries, it is important that you clearly define and understand the business task you need the query to accomplish. Sometimes a business task needs to be done only one time or very infrequently (for example, a company closing a branch office and assigning employees to a different branch). Other times, a task might be part of a recurring process (for example, periodically manufacturers who supply goods to a store raise product prices). Each time this happens, the manager at the store needs to update the purchase cost of each item. Occasionally, a business task may involve using several action queries together (for example, at the end of every semester, a clerk in a university equipment office needs to remove the equipment reservations from the reservation table). However, the school still needs to keep the reservation records in a history table. This business task requires that the clerk append the old reservations into a history table before deleting the records from the reservation table. You can automate each of the tasks described in this paragraph using an action query.

Blooms: Understand
Difficulty: 3 Hard
SLO: 06-01
Skill: Understand Action Queries

92.
(p. A6-383)
Why is it a good idea to make a backup copy of your database before running any action query?

An action query makes a permanent change to the data in the database and the Undo button is not available to reverse the action. As a result, it is a good practice to make a backup copy of your database before you run any action query. This will allow you to restore your original data if the query does not work correctly. As additional protection, Access displays a message box alerting you to the change before executing an action query. The exact message varies depending on the type of action query.

Blooms: Understand
Difficulty: 2 Medium
SLO: 06-03
Skill: Understand Action Queries

93.
(p. A6-376)
What is a crosstab query? Why are crosstab queries useful?

A crosstab query summarizes data on two dimensions. The results of a crosstab query display in a row/column format, which makes the data easier to read and understand (compared to the results of a select query). Crosstab queries are not appropriate in all databases. You must have data that can be summarized across two dimensions. Unlike the resulting datasheet from a regular select query, you cannot edit the results from a crosstab query. You can create a crosstab query using Query Design; however, it is much easier to create the query using the Crosstab Query Wizard.

Blooms: Understand
Difficulty: 2 Medium
SLO: 06-02
Skill: Understand and Build a Crosstab Query

94.
(p. A6-380)
Describe some situations in which you may end up with duplicated data.

Unfortunately, even when you practice good database design, you still may end up with duplicated data. Consider customers who forget their login IDs and passwords and create new accounts or a salesperson who accidently enters the same order twice. Having two records for the same customer, even though the login ID is different, or two records of the same order, even though the order number is different, results in duplicate data. You need to remove duplicated records in situations like these. Additionally, sometimes you may inherit a database that was poorly designed and does not have primary keys created, or you may import data from another source that contains duplicate data. Before you can create and enforce a primary key, you need to find and remove duplicate data.

Blooms: Understand
Difficulty: 3 Hard
SLO: 06-02
Skill: Find Duplicate Records

95.
(p. A6-386)
What is a subquery? Why are subqueries helpful?

The query examples used so far have all used a table as the data source for a query. A query can also use another query as the data source. A subquery is a query that is used inside another query. Creating a query and then using it inside of another query can be helpful when you have a common starting point (the original query) but want to customize it for additional purposes (the additional query). Sometimes using a subquery is a more efficient way to get the results you are seeking, but it depends on the size of the database and the design of the query. To incorporate a subquery, in general you follow the process to create a query, but the only thing you do differently is to select the Query Name from the Queries tab of the Show Table dialog box, instead of selecting the Table Name from the Tables tab. Occasionally, you may need to use a subquery when the business question is too complex for a single query. For example, suppose Placer Hills Real Estate wants to find out which agents have listings greater than the average listing price for all properties.

Blooms: Understand
Difficulty: 2 Medium
SLO: 06-03
Skill: Create a Subquery

96.
(p. A6-395)
What is a parameter report? Why are parameter reports useful?

Using parameter queries can increase the efficiency and flexibility of your database. By creating a parameter report, you can also apply those benefits to the reports in your database. A parameter report asks the user to enter the specific criteria value for a field when the report is run. This allows you to create one report but have the contents displayed vary based on the value of the parameter that is entered. Also, the parameter text is enclosed inside of square brackets in the criteria row of the desired field.

Blooms: Understand
Difficulty: 2 Medium
SLO: 06-04
Skill: Create a Parameter Report

97.
(p. A6-397)
Why is it sometimes necessary to change the height of a report section?

Many times the initial size of a section is larger or smaller than you need it to be. Additionally, as you add controls into a section or modify the sizes of various controls, you may need to adjust the height of a section. In particular, you should pay attention to the height of the detail section since that section repeats once for each record in the report. If you are printing many records, changing the height of a section could make a significant difference in how many pages are in the report.

Blooms: Understand
Difficulty: 2 Medium
SLO: 06-05
Skill: Change the Height of a Section

98.
(p. A6-400)
What are calculated controls? Explain what you know about using calculated controls in reports.

A calculated control contains an expression in the Control Source property. You can use calculated controls to show the results of a mathematical equation, an aggregate function, or a text-based equation. You can use a calculated control in any report section. While there are several controls you can use as calculated controls, the most common choice is a text box.

Blooms: Understand
Difficulty: 2 Medium
SLO: 06-06
Skill: Using Calculated Controls on a Report

99.
(p. A6-402)
What is concatenation and why might you want to use it?

Concatenation combines different parts of an expression using the & operator. In a report, you may wish to concatenate different fields to improve the way the results appear. For example, combining the first and last name, or the city, state, and zip code together, can produce a more readable report. The concatenated expression can combine fields from a table or query, along with constants. Also, a constant is a hard coded value.

Blooms: Understand
Difficulty: 2 Medium
SLO: 06-06
Skill: Concatenate Text Data

100.
(p. A6-407)
What is a subreport? How do they work?

A subreport is a report inserted within another report. To work correctly, there must be a relationship between the two reports. Typically, the reports represent the different sides of a one-to-many relationship. The report from the “one” side of the relationship is the main report, while the report from the “many” side of the relationship is the subreport. You create the main report and subreport as two separate reports. Then you add the subreport to the main report. Once you add the subreport, it still exists as a separate object. The main report, however, contains both the original “one” side fields from the main report, plus all of the “many” side fields on the subreport. Before you create a subreport, you need to plan out the design of the finished report. Determine what tables or fields will be on the main report and what tables or fields will be on the report.

Blooms: Understand
Difficulty: 2 Medium
SLO: 06-07
Skill: Understand Subreports

Access Chapter 07

Creating Advanced Forms

True / False Questions

1.Design view provides you with the most flexibility in creating forms.

True False

2.The Page Footer form section displays information when a form is printed, and is only visible in Design or Print Preview view.

True False

3.When you create a form in Design view, all sections, including the Detail section, are automatically added to the form.

True False

4.If you are unable to reduce the height of a section or the width of the form, it is because a control somewhere in the form requires the space.

True False

5.The order that Access navigates from one control to another is determined by the value in the Tab Stop property.

True False

6.By default, the tab order is initially set based on the order that fields have been added to the form.

True False

7.Focus determines whether the cursor stops at a control when the user presses Tab or Enter.

True False

8.Setting the Enabled property to No does not affect the way the label displays.

True False

9.In a one-to-many form, the main form displays data from the “one” side of the relationship.

True False

10.If Access was not able to determine the correct linking fields between the subform and the main form or if you created an incorrect link, you can manually establish the link.

True False

11.The linking fields are typically the primary key in the “one” table and the foreign key in the “many” table.

True False

12.Because the subform uses a datasheet layout, it is possible to customize the font characteristics of individual fields on the subform.

True False

13.Navigation buttons can be removed from any form.

True False

14.When a calculated expression is longer than the size of the control, you can use the Expression Builder or Zoom window to see the entire expression.

True False

15.To aggregate over a group of records on the subform, you must place the aggregate function calculation in the Detail section of the subform.

True False

16.If you switch to Form view after adding the aggregate function onto the subform, you will not see any differences in the form.

True False

17.The #Error error means that you have used a name for a field, control, form, or function that is not valid.

True False

18.The #Error error indicates that Access can’t evaluate the expression that provides the control’s value.

True False

19.You can save images as a .bmp file, which results in a smaller file size, instead of using a larger .jpg file.

True False

20.The Image button inserts an embedded image.

True False

21.The Insert Image button inserts an embedded image.

True False

22.After applying a new theme, you can modify any parts that you don’t like.

True False

23.When you click a tab in a navigation form, the most current data is loaded.

True False

24.You can include navigation forms in databases that you publish to a SharePoint server to make them available on the web.

True False

25.You can attach a table to a navigation form.

True False

26.Some database designers prefer to create their own form to collect the parameters and then pass those along to the query or report.

True False

27.Most forms used to capture parameters have an OK button and a Cancel button.

True False

28.If you make changes to the properties of a form, be sure to save the form after you make the changes.

True False

29.After the form has been created and the query has been updated, you need to write the macro code that is attached to the form buttons.

True False


+
-
Only 0 units of this product remain

You might also be interested in