Fill This Form To Receive Instant Help
Homework answers / question archive / Chapter 18: Maintaining and Querying a Database TRUE/FALSE 1) The deletion of a record is permanent and cannot be undone
Chapter 18: Maintaining and Querying a Database
TRUE/FALSE
1) The deletion of a record is permanent and cannot be undone.
2. The design grid in a Query window contains the fields in the table or query used to create the query.
3. Hiding a field’s values in query results does not remove the field from the query design.
4. When sorting, the pivot field is the field used to determine the order of records in the datasheet.
5. A filter is a set of restrictions you place on the records in a datasheet or form to temporarily isolate a subset of the records.
6. In a one-to-many relationship, the primary table is the “one” table, and the related table is the “many” table.
7. You navigate and update an open subdatasheet the same way as a table datasheet.
8. Use the Both logical operator when you want a record selected only if all of the specified conditions are met.
9. Unless you are expert in creating expressions for calculated fields, you should avoid using Expression Builder.
10. The AutoSort operator divides the selected records from a query into groups based on values in the specified field.
MODIFIED TRUE/FALSE
1. The Esc key is a toggle that you use to switch between navigation mode and editing mode.
2. QED retrieves the information that precisely matches the example you provide of the information being requested.
3. A(n) select query is a query in which you specify the fields and records you want Access to select.
4. Sorting is the process of rearranging records in a specified order or sequence.
5. To sort fields in nonadjacent columns, you must specify the sort fields in Datasheet view.
6. You use a(n) common field to relate one table to another.
7. To create a multitable query, the tables must have a common primary key.
8. The join line in the figure above indicates a(n) one-to-one relationship between the tables.
9. Use the Or logical operator when you want a record selected if at least one of the specified conditions is met.
10. A(n) allocated field displays the results of an expression.
MULTIPLE CHOICE
1. You use ____ to navigate a datasheet.
a. |
the F2 key |
c. |
navigation buttons |
b. |
keystroke combinations |
d. |
any of the above |
2. You use the ____ dialog box to locate a specific field value in a table, query, datasheet, or form.
a. |
Search |
c. |
Find and Replace |
b. |
Fields |
d. |
Help |
3. Before you delete a record, you must ____.
a. |
compact the database |
b. |
perform an entity integrity check |
c. |
select the entire row for the record in the datasheet |
d. |
all of the above |
4. After deleting a record with an AutoNumber field, ____.
a. |
there may be gaps in the numbers used for the field values |
b. |
you must re-sort the database on the AutoNumber field |
c. |
you must run an entity integrity check |
d. |
AutoNumbering will be turned off until you restore it |
5. You work with a query in the ____ window.
a. |
Layout |
c. |
Design |
b. |
Query |
d. |
Interact & Navigate |
6. The bottom portion of the Query window contains the ____.
a. |
field list |
c. |
QBE drop-down list |
b. |
design grid |
d. |
record sorter |
7. The result of a query is referred to as a(n) ____.
a. |
minisheet |
c. |
intra-list |
b. |
subdatasheet |
d. |
recordset |
8. All of the following are true of a query datasheet EXCEPT ____.
a. |
it shows the permanent data in a table |
b. |
it resembles a table datasheet |
c. |
its contents are based on the criteria set in the query design grid |
d. |
it can display selected fields from a table in the order you specify |
9. The answer to a select query is returned in a query ____.
a. |
window |
c. |
datasheet |
b. |
grid |
d. |
report |
10. To transfer all the fields from the query field list to the design grid at once, ____.
a. |
double-click the asterisk at the top of the field list |
b. |
select a field in the list, then press the Tab key |
c. |
click and drag the last field in the list to the design grid |
d. |
right-click a field in the list, then click “Transfer All” |
11. If the results of a query are not what you expected or require, you can ____.
a. |
remove fields from the query |
b. |
change the order in which fields appear in query results |
c. |
hide a field’s values in query results |
d. |
all of the above |
12. To select a field in the design grid, click ____.
a. |
the center of the field |
c. |
the thin bar above a column |
b. |
the asterisk in the field list |
d. |
the padlock icon to the right of the field |
13. The figure above shows ____.
a. |
the query datasheet |
c. |
the field list |
b. |
the design grid |
d. |
the QBE |
14. In the figure above, box ____ denotes the field that is being moved.
a. |
A |
c. |
D |
b. |
C |
d. |
E |
15. In the figure above, the ____ field will NOT appear in query results.
a. |
CustomerID |
c. |
City |
b. |
FirstName |
d. |
none of the above |
16. To sort records, you must select the ____ field.
a. |
sort |
c. |
first |
b. |
primary key |
d. |
query |
17. In Datasheet view, when you click the arrow to the right of a column heading, the ____ menu opens.
a. |
Query |
c. |
AutoFilter |
b. |
Find & Replace |
d. |
Sort Type |
18. All of the following may be Sort fields EXCEPT ____.
a. |
Hyperlink |
c. |
Currency |
b. |
Yes/No |
d. |
AutoNumber |
19. In ____ view, the sort fields must be in adjacent columns in the datasheet, and you can specify only one type of sort for the selected columns.
a. |
Design |
c. |
Datasheet |
b. |
Filter |
d. |
Layout |
20. All of the following are true of filters EXCEPT ____.
a. |
they let you temporarily isolate a subset of records |
b. |
they let you focus on only the data you need |
c. |
a filtered datasheet has the word Filtered on the status bar |
d. |
an object cannot be saved with a filter applied |
21. You use a(n) ____ to relate one table to another.
a. |
common field |
c. |
foreign key |
b. |
primary key |
d. |
AutoLink |
22. A one-to-many relationship exists between two tables when one record in the first table matches ____ in the second table, and when each record in the second table matches at most one record in the first table.
a. |
zero records |
c. |
several records |
b. |
one record |
d. |
any of the above |
23. The ____ table is the “one” table in a one-to-many relationship.
a. |
common |
c. |
secondary |
b. |
related |
d. |
primary |
24. The ____ table is the “many” table in a one-to-many relationship.
a. |
common |
c. |
secondary |
b. |
related |
d. |
primary |
25. ____ is a set of rules to maintain consistency between related tables when data in a database is updated.
a. |
Entity alignment |
c. |
Referential integrity |
b. |
QBE |
d. |
Orphanation |
26. When no matching record already exists in the primary table, placing a record in a related table causes ____.
a. |
referential disintegration |
c. |
broken relations |
b. |
orphaned records |
d. |
widowed links |
27. After defining a relationship between tables, the “one” table in the one-to-many relationship contains a ____ for each record, which is collapsed until you expand it.
a. |
subdatasheet |
c. |
query report |
b. |
link |
d. |
multitable query |
28. The one-to-many relationship between two tables is shown in the Query window with a ____, just as in the Relationships window.
a. |
translucent overlay |
c. |
join line |
b. |
hyperlink |
d. |
chain and lock icon |
29. A join line with ____ indicates that the relationship is set to enforce referential integrity.
a. |
a padlock icon |
c. |
a dotted line |
b. |
two infinity symbols |
d. |
thick ends |
30. You can refine a query to display only selected records by specifying a(n) ____ as part of the query.
a. |
condition |
c. |
priority |
b. |
relation |
d. |
expression |
31. You use ____ to combine two or more conditions in a query.
a. |
parentheses |
c. |
expressions |
b. |
logical operators |
d. |
targeted queries |
32. To create a query with the ____ operator, you specify all of the conditions in the same Criteria row of the design grid.
a. |
Equals |
c. |
Not |
b. |
Or |
d. |
And |
33. With the And operator, you ____ the results of a query; with the Or operator, you ____ the results of a query.
a. |
narrow, broaden |
c. |
broaden, narrow |
b. |
narrow, maintain |
d. |
broaden, broaden |
34. A(n) ____ field displays the results of an expression.
a. |
iterated |
c. |
calculated |
b. |
filtered |
d. |
sorted |
35. In Access, calculations are performed ____.
a. |
right to left |
c. |
using the standard order of precedence |
b. |
in DBMS Sort order |
d. |
from initial field to final field |
36. ____ is an Access tool that makes it easy for you to create an expression.
a. |
QBE |
c. |
MS Express |
b. |
Expression Builder |
d. |
The Formulator |
37. The Calculated Field data type is available only for tables in ____ view.
a. |
Query |
c. |
Layout |
b. |
Datasheet |
d. |
Design |
38. You add a Total row by clicking the ____ button in the ____ group on the Home tab.
a. |
Sum, Function |
c. |
Functions, Expressions |
b. |
Total, Function |
d. |
Totals, Records |
39. If you use the Maximum function on the SalesQ4 field in a query, the resulting query datasheet will give the default column name ____.
a. |
Max-SalesQ4 |
c. |
MaxOfSalesQ4 |
b. |
MaximumSal |
d. |
SalesQ4MAXIMUM |
40. The ____ operator divides the selected records into groups based on the values in the specified field.
a. |
Group By |
c. |
Sort Select |
b. |
Filter On |
d. |
Amass |
Case-Based Critical Thinking Questions
Case 18-1
For each of the following questions, choose the answer that represents how the fields would be sorted given the kind of sort chosen.
41. Last Name | First Name
Jacobson Marvin
Jacobs Marvin
Jenkins Marc
Ascending sort on Last Name
a. |
Jacobs Marvin Jacobson Marvin Jenkins Marc |
c. |
Jenkins Marc Jacobson Marvin Jacobs Marvin |
b. |
Jacobson Marvin Jacobs Marvin Jenkins Marc |
d. |
Jacobs Marc Jacobson Marvin Jenkins Marvin |
42. Last Name | First Name
Jacobson Marvin
Jacobs Marvin
Jenkins Marc
Descending sort on Last Name
a. |
Jacobs Marvin Jacobson Marvin Jenkins Marc |
c. |
Jenkins Marc Jacobson Marvin Jacobs Marvin |
b. |
Jacobson Marvin Jacobs Marvin Jenkins Marc |
d. |
Jacobs Marc Jacobson Marvin Jenkins Marvin |
43. ID | Price
3 $5.00
17 $12.75
5 $18.00
1 $0.00
Ascending on ID
a. |
1 $5.00 3 $12.75 5 $18.00 17 $0.00 |
c. |
1 $0.00 3 $5.00 5 $18.00 17 $12.75 |
b. |
1 $0.00 3 $5.00 5 $18.00 17 $12.75 |
d. |
5 $18.00 17 $12.75 3 $5.00 1 $0.00 |
44. ID | Price
3 $5.00
17 $12.75
5 $18.00
1 $0.00
Descending on Price
a. |
1 $5.00 3 $12.75 5 $18.00 17 $0.00 |
c. |
1 $0.00 3 $5.00 5 $18.00 17 $12.75 |
b. |
1 $0.00 3 $5.00 5 $18.00 17 $12.75 |
d. |
5 $18.00 17 $12.75 3 $5.00 1 $0.00 |
45. ID | Price
3 $5.00
17 $12.75
5 $18.00
1 $0.00
Descending on ID
a. |
17 $12.75 5 $18.00 3 $5.00 1 $0.00 |
c. |
1 $0.00 3 $5.00 5 $18.00 17 $12.75 |
b. |
1 $0.00 3 $5.00 5 $18.00 17 $12.75 |
d. |
5 $18.00 17 $12.75 3 $5.00 1 $0.00 |
Case-Based Critical Thinking Questions
Case 18-2
Answer the following questions based only on the figure shown below. (Don’t let your recollections from the chapter influence how you answer.)
46. The figure above shows ____.
a. |
the table datasheet view |
c. |
the Query window field list |
b. |
the Query window design grid |
d. |
the query datasheet view |
47. Which of the following is known to be TRUE from the figure above?
a. |
This is going to be a multitable query. |
b. |
FirstName is the primary key of the Customer table. |
c. |
Customer and Contract are in a one-to-one relationship. |
d. |
ContractID is the common field. |
48. What obvious problem with the figure above will keep it from working properly?
a. |
All of the fields are being shown. |
b. |
There is no obvious connection between the Customer and Contract tables. |
c. |
There is only one condition; there must be at least two. |
d. |
None of the above poses a problem. |
49. You know that the Contract table is the ____.
a. |
primary table |
b. |
related table |
c. |
secondary table |
d. |
none of the above; you don’t know the relation just from this figure |
50. Given the condition, you know that this query uses a(n) ____ operator.
a. |
Or |
c. |
Not |
b. |
And |
d. |
none of the above |
COMPLETION
1. The ____________________ dialog box lets you locate a specific field value in a table, query datasheet, or form.
2. In Design view, you specify the data you want to view by constructing a query by ____________________.
3. The result of a query is referred to as a(n) ____________________.
4. The answer to a select query is returned in a query ____________________.
5. ____________________ is the process of rearranging records in a specified order or sequence.
6. When you use a(n) ____________________ sort field, records with the same sort field value are grouped together, but are not sorted in a specific order within the group.
7. The restrictions placed by a(n) ____________________ on the records in a datasheet will temporarily isolate a subset of those records.
8. The two tables that form a relationship are called the ____________________ and ____________________ tables.
9. ____________________ records are those that appear in a related table but have no matching record that exists in the primary table.
10. After you create a relation, when you open the primary table, the ____________________ for each record in the primary table is collapsed until you expand it.
11. A one-to-many relationship shown in the Query window will have a number 1 on the “one” side, and a(n) ____________________ on the “many” side.
12. A condition is a(n) ____________________, or rule, that determines which records are selected.
13. ____________________ is the Access “not equal to” operator.
14. Unlike a Field box, the Zoom box and ____________________ are large enough to display longer expressions that you are creating.
15. To quickly perform a calculation using a function in a query datasheet, you can add a(n) ____________________ row at the bottom of the datasheet.
MATCHING
a. |
field list |
g. |
design grid |
b. |
F2 |
h. |
referential integrity |
c. |
filter |
i. |
sorting |
d. |
subdatasheet |
j. |
And |
e. |
Group By |
k. |
calculated field |
f. |
QBE |
l. |
join line |
1. displays the results of an expression
2. shows a relationship between tables in a Query window
3. retrieves information precisely matching the example you provide
4. the bottom portion of a Query window
5. rearranging records in a specified order or sequence
6. maintaining consistency between related tables when data is updated
7. a logical operator
8. a set of restrictions that temporarily isolates a subset of records
9. used to navigate a datasheet and select field values
10. displays, in a primary table, records from the related table
11. an operator that divides selected records based on values in a specified field
12. the top portion of the Query window
ESSAY
1. What is referential integrity? Discuss the three rules for maintaining it.
2. Name and briefly discuss the three reasons database experts caution against storing calculations in a table.
3. Briefly explain how to use the Query window design grid to create a query with an And logical operator, and then a query with an Or logical operator. What will each kind of query display for its results?
please use this google drive link to download the answer file.
https://drive.google.com/file/d/1S7UItYLNfXhW4xHblan3o3bVPKe5z_Ye/view?usp=sharing
note: if you have any trouble in viewing/downloading the answer from the given link, please use this below guide to understand the whole process.
https://helpinhomework.org/blog/how-to-obtain-answer-through-googledrive-link