Full Download Illustrated Microsoft Office 365 and Access 2016 Intermediate 1st Edition Friedrichsen Test Bank All Chapter 2024 PDF
Full Download Illustrated Microsoft Office 365 and Access 2016 Intermediate 1st Edition Friedrichsen Test Bank All Chapter 2024 PDF
Full Download Illustrated Microsoft Office 365 and Access 2016 Intermediate 1st Edition Friedrichsen Test Bank All Chapter 2024 PDF
https://testbankfan.com/product/illustrated-microsoft-
office-365-and-access-2016-intermediate-1st-edition-friedrichsen-
solutions-manual/
https://testbankfan.com/product/illustrated-microsoft-
office-365-and-access-2016-comprehensive-1st-edition-
friedrichsen-test-bank/
https://testbankfan.com/product/illustrated-microsoft-
office-365-and-access-2016-introductory-1st-edition-friedrichsen-
test-bank/
https://testbankfan.com/product/illustrated-microsoft-
office-365-and-access-2016-comprehensive-1st-edition-
friedrichsen-solutions-manual/
Illustrated Microsoft Office 365 and Access 2016
Introductory 1st Edition Friedrichsen Solutions Manual
https://testbankfan.com/product/illustrated-microsoft-
office-365-and-access-2016-introductory-1st-edition-friedrichsen-
solutions-manual/
https://testbankfan.com/product/illustrated-course-guide-
microsoft-office-365-and-access-2016-intermediate-spiral-bound-
version-1st-edition-friedrichsen-test-bank/
https://testbankfan.com/product/illustrated-course-guide-
microsoft-office-365-and-access-2016-introductory-1st-edition-
friedrichsen-test-bank/
https://testbankfan.com/product/illustrated-course-guide-
microsoft-office-365-and-access-2016-advanced-1st-edition-
friedrichsen-test-bank/
https://testbankfan.com/product/illustrated-course-guide-
microsoft-office-365-and-access-2016-intermediate-spiral-bound-
version-1st-edition-friedrichsen-solutions-manual/
Name: Class: Date:
1. If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in
any other query that also displays this customer's name.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Access 138
Create Multitable Queries
QUESTION TYPE: True / False
HAS VARIABLES: False
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
2. In Query Design View, a table's name displays in the field list title bar.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 138
Create Multitable Queries
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.095 - Create a multitable query in Query Design View
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
5. A query can display fields from one or more tables in a relational database.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 138
Create Multitable Queries
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.095 - Create a multitable query in Query Design View
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
6. In Query Design View, one-to-many join lines identify linking fields between related tables.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 138
Create Multitable Queries
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.095 - Create a multitable query in Query Design View
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
7. Deleting a field from the query design grid deletes it from the database table that contains that field.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Access 139
Create Multitable Queries
8. You can specify more than one sort field in Query Design View.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 140
Apply Sorts and View SQL
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.097 - Apply sort orders in Query Design View
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
9. Sort orders defined in Query Design View are not saved with the query object.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Access 140
Apply Sorts and View SQL
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.097 - Apply sort orders in Query Design View
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
10. Access helps you with criteria syntax in the query design grid.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 142
Develop AND Criteria
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.100 - Use the Like operator in query criteria
DATE CREATED: 2/26/2016 8:22 PM
Copyright Cengage Learning. Powered by Cognero. Page 3
Name: Class: Date:
11. Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear
in the datasheet.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 142
Develop AND Criteria
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.098 - Define advanced comparison operators
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
13. Each criteria row of the query design grid is evaluated separately.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: Access 144
Develop OR Criteria
QUESTION TYPE: True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.099 - Use AND and OR criteria in the same query
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
14. OR queries narrow the number of records that will appear in the datasheet because a record must be true for all
criteria.
Copyright Cengage Learning. Powered by Cognero. Page 4
Name: Class: Date:
15. To sort records by last name then by payment date, the last name field must be the secondary sort field and the
payment date must be the primary sort field.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Access 140
Apply Sorts and View SQL
QUESTION TYPE: True / False
HAS VARIABLES: False
DATE CREATED: 5/23/2016 5:02 PM
DATE MODIFIED: 5/23/2016 5:03 PM
16. When you enter criteria in a query, you must be aware that criteria are case sensitive, that is, BIO and Bio are not
equivalent.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: Access 142
Develop AND Criteria
QUESTION TYPE: True / False
HAS VARIABLES: False
DATE CREATED: 5/23/2016 6:46 PM
DATE MODIFIED: 5/23/2016 6:48 PM
18. In Query Design View, you can drag the edge of a(n) field list to resize it. _________________________
ANSWER: True
POINTS: 1
REFERENCES: Access 138
Create Multitable Queries
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
20. Filtering refers to reordering records in either ascending or descending order based on the values in the field.
_________________________
ANSWER: False - Sorting
POINTS: 1
REFERENCES: Access 140
Apply Sorts and View SQL
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.097 - Apply sort orders in Query Design View
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
23. In SQL, the FROM keyword determines how records are sorted. _________________________
ANSWER: False - ORDER BY
POINTS: 1
REFERENCES: Access 140
Apply Sorts and View SQL
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.101 - Define SQL keywords
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
24. You can view the SQL code for any query by switching to Code View. _________________________
ANSWER: False - SQL
POINTS: 1
REFERENCES: Access 140
Apply Sorts and View SQL
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.110 - View Structured Query Language
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
25. When you are saving a query, you are saving a set of instructions written in Standard Query Language.
_________________________
Copyright Cengage Learning. Powered by Cognero. Page 7
Name: Class: Date:
26. Syntax are tests, or limiting conditions, that must be true for a record to be selected for a datasheet in a query.
_________________________
ANSWER: False - Criteria
POINTS: 1
REFERENCES: Access 142
Develop AND Criteria
QUESTION TYPE: Modified True / False
HAS VARIABLES: False
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
Multiple Choice
28. Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?
a. Common b. Select
c. Linking d. Web
ANSWER: b
POINTS: 1
REFERENCES: Access 138
Create Multitable Queries
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.095 - Create a multitable query in Query Design View
Copyright Cengage Learning. Powered by Cognero. Page 8
Name: Class: Date:
29. In Query Design View, primary key fields in a field list are ____.
a. underlined b. the first field listed
c. the last field listed d. indicated with a key icon
ANSWER: d
POINTS: 1
REFERENCES: Access 139
Create Multitable Queries
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.095 - Create a multitable query in Query Design View
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
30. An SQL statement determines how the tables are joined after the ____ keyword
a. SELECT b. RELATE
c. FROM d. ORDER BY
ANSWER: c
POINTS: 1
REFERENCES: Access 140
Apply Sorts and View SQL
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.101 - Define SQL keywords
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
31. An SQL statement determines how the resulting records are sorted after the ____ keyword.
a. SELECT b. LINK
c. FROM d. ORDER BY
ANSWER: d
POINTS: 1
REFERENCES: Access 140
Apply Sorts and View SQL
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.101 - Define SQL keywords
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
32. An SQL statement determines what fields are selected after the ____ keyword.
33. ____ criteria are two or more criteria on the same Criteria row of the query design grid.
a. OR b. Expand
c. AND d. Wildcard
ANSWER: c
POINTS: 1
REFERENCES: Access 142
Develop AND Criteria
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.098 - Define advanced comparison operators
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
35. In the query design grid, what characters surround text criteria?
a. Pound signs (#) b. Dollar signs ($)
c. Percent signs (%) d. Quotation marks ("")
ANSWER: d
POINTS: 1
Copyright Cengage Learning. Powered by Cognero. Page 10
Name: Class: Date:
39. When the comparison operator Null is used as criteria in the query design grid, the query finds records in which ____.
a. the value is not equal to the text "Null" b. the field value is equal to the text "Null"
c. any value has been entered for a field d. no value has been entered for a field
ANSWER: d
POINTS: 1
REFERENCES: Access 143
Develop AND Criteria
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.098 - Define advanced comparison operators
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
40. The wildcard character that represents any combination of characters in query criteria is the ____.
a. asterisk (*) b. exclamation point (!)
c. tilde (˜) d. question mark (?)
ANSWER: a
POINTS: 1
REFERENCES: Access 145
Develop OR Criteria
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.102 - Define advanced wildcard characters
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
41. To find all first names that are either Tom or Tim, you would use the____ wildcard character.
a. asterisk (*) b. exclamation point (!)
c. tilde (˜) d. question mark (?)
ANSWER: d
POINTS: 1
REFERENCES: Access 145
Develop OR Criteria
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.102 - Define advanced wildcard characters
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 5/23/2016 6:55 PM
43. Which function should you use to calculate today's current date?
a. CURRENT b. DATE
c. YEAR d. DAY
ANSWER: b
POINTS: 1
REFERENCES: Access 147
Create Calculated Fields
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.104 - Define functions and expressions
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
44. Which function should you use to calculate the monthly payment on a loan?
a. PMT b. LOAN
c. PAY d. RATE
ANSWER: a
POINTS: 1
REFERENCES: Access 147
Create Calculated Fields
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.104 - Define functions and expressions
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
48. When you create a summary query, which row is added to the query design grid?
a. Criteria b. Table
c. Field d. Total
ANSWER: d
POINTS: 1
REFERENCES: Access 148
Build Summary Queries
QUESTION TYPE: Multiple Choice
49. Which aggregate function would NOT work well on a Short Text field?
a. Sum b. Min
c. Max d. Count
ANSWER: a
POINTS: 1
REFERENCES: Access 148
Build Summary Queries
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.106 - Define aggregate functions
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
50. Which aggregate function is used to find the average of values in a field?
a. Avg b. Average
c. Mean d. Mode
ANSWER: a
POINTS: 1
REFERENCES: Access 149
Build Summary Queries
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.106 - Define aggregate functions
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
51. Which aggregate function is used to find the number of values in a field?
a. Values b. Num
c. Number d. Count
ANSWER: d
POINTS: 1
REFERENCES: Access 149
Build Summary Queries
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.106 - Define aggregate functions
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
Copyright Cengage Learning. Powered by Cognero. Page 15
Name: Class: Date:
54. Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?
a. Group By row b. Total row
c. Values row d. Crosstab row
ANSWER: d
POINTS: 1
REFERENCES: Access 150
Build Crosstab Queries
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.107 - Create a crosstab query
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
55. The wildcard character that represents one character in query criteria is the ____.
a. asterisk (*) b. exclamation point (!)
c. tilde (˜) d. question mark (?)
ANSWER: d
Completion
56. The data displayed in a query is sometimes called a(n) ____ view of the data.
ANSWER: logical
POINTS: 1
REFERENCES: Access 138
Create Multitable Queries
QUESTION TYPE: Completion
HAS VARIABLES: False
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
57. Use the ____ check box in the query design grid to select or unselect a field to display in the resulting datasheet.
ANSWER: Show
POINTS: 1
REFERENCES: Access 141
Apply Sorts and View SQL
QUESTION TYPE: Completion
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.097 - Apply sort orders in Query Design View
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
59. The ____ function returns a number of characters from the first part of a field.
Copyright Cengage Learning. Powered by Cognero. Page 17
Name: Class: Date:
60. A(n) ____ query is used to calculate statistics about a group of records.
ANSWER: summary
POINTS: 1
REFERENCES: Access 148
Build Summary Queries
QUESTION TYPE: Completion
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.105 - Create a summary query
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
61. Use the ____ Query Wizard to guide you through the steps of creating a crosstab query.
ANSWER: Crosstab
POINTS: 1
REFERENCES: Access 150
Build Crosstab Queries
QUESTION TYPE: Completion
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.108 - Create a Crosstab query
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
62. ____ queries summarize data in which one or more fields are chosen for the row headings, another for the column
heading, and yet another for the field summarized within the datasheet itself.
ANSWER: Crosstab
POINTS: 1
REFERENCES: Access 150
Build Crosstab Queries
QUESTION TYPE: Completion
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.108 - Create a Crosstab query
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
64. The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.
ANSWER: Unmatched
POINTS: 1
REFERENCES: Access 151
Build Crosstab Queries
QUESTION TYPE: Completion
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.109 - Describe the Find Duplicates and Find Unmatched Query Wizards
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 2/26/2016 8:22 PM
Matching
67. A predefined Access formula that returns a value such as a subtotal or count
ANSWER: c
POINTS: 1
70. A statistic such as a subtotal or count is determined on a given field in a group of records
ANSWER: d
POINTS: 1
71. You want to add the PaymentDate field from the Payments table to the query grid. Describe how you can do this.
ANSWER: Drag the PaymentDate field in the Payments table field list to the query design grid.
or
Double-click the PaymentDate field in the Payments table field list to move it to the next
available column in the query design grid.
POINTS: 1
REFERENCES: Access 138
Create Multitable Queries
QUESTION TYPE: Subjective Short Answer
HAS VARIABLES: False
LEARNING OBJECTIVES: ENHA.FRIE.16.096 - Add and delete fields in Query Design View
TOPICS: Critical Thinking
DATE CREATED: 2/26/2016 8:22 PM
DATE MODIFIED: 5/23/2016 4:31 PM
72. You want to search for all last names beginning with the letter M. The field name for last name is LName. Describe
Copyright Cengage Learning. Powered by Cognero. Page 20
Another random document with
no related content on Scribd:
distributed Project Gutenberg™ eBooks with only a loose
network of volunteer support.
Most people start at our website which has the main PG search
facility: www.gutenberg.org.