Microsoft Office Tutorials and References
In Depth Information
In the Lab
AC 201
7. Use the split form to change the item type for item numbers 3663 and 7930 to CAP. Change the
item type for item numbers 5923 and 7810 to CLO.
8. Add the following items to the Item table.
3673
Blanket
NOV
5
$29.90
$34.00
AC
6078
Key Chain
NOV
20
$3.00
$5.00
MN
7550
Sweatshirt
CLO
8
$19.90
$22.95
LG
9. Create an advanced fi lter for the Item table. The fi lter should display the item number, item type,
description, and number on hand for all items with less than 10 items on hand. Sort the fi lter by
item type and description. Save the fi lter settings as a query and name the fi lter Reorder Filter.
10. Resize all columns in the Item table and the Supplier table to best fi t.
11. Using a query, delete all records in the Item table where the description starts with the letter F.
Save the query as Delete Query.
12. Specify referential integrity between the Supplier table (the one table) and the Item table (the many
table). Cascade the update but not the delete.
13. Compact the database.
14. Submit the revised database in the format specifi ed by your instructor.
In the Lab
Lab 3: Maintaining the Ada Beauty Supply Database
Problem: The management of Ada Beauty Supply has determined that some changes must be made to
the database structure. A multivalued fi eld must be added. Validation rules need to be added. Finally,
some additions and deletions are required to the database.
Instructions: Use the Ada Beauty Supply database created in the In the Lab 3 of Chapter 1 on page
AC 69 for this assignment, or see your instructor for information on accessing the fi les required for
this topic. Submit the revised database in the format specifi ed by your instructor.
Instructions Part 1: Several changes must be made to the database structure. For example, management
would like a multivalued fi eld that lists the type of services each beauty salon offers. This knowledge
can help the sales representatives better meet the needs of their customers. Table 3-2 lists the service
abbreviations and descriptions that management would like in a Services Offered multivalued fi eld.
Table 3–2 Service Abbreviations and Descriptions
Service Abbreviation
Description
FAC
Facial
HRS
Hair Styling
MNC
Manicure
PED
Pedicure
MST
Massage Therapy
TAN
Tanning
Management wants to ensure that an entry always appears in the Customer Name fi eld and that
any letters entered in the Customer Number fi eld appear in uppercase. It also requires that the amount
in the Balance fi eld is never less than 0 or greater than $1,000. Make the changes to the database
structure. Place the Services Offered fi eld after the Telephone fi eld.
Continued >
Search JabSto ::




Custom Search