Microsoft Office Tutorials and References
In Depth Information
Access Chapter 3 Maintaining a Database
Extend Your Knowledge continued
2. Open the Item table in the Backyard database and change the description for WF10 to Window
Bird Feeder. Resize all columns to best ﬁ t the data.
3. Sort the datasheet in ascending order by Description.
4. Add a totals row to the datasheet and display the sum of the on hand items, and the average cost
and average selling price.
5. Save the changes to the layout of the table. Close the table and rename it Product.
6. Update the table properties for the Product table to include the description, Updated to include
items from Inventory database.
7. Using a query, delete all records in the Product table where the description starts with the letter S.
Save the query as Delete Query.
8. Change the database properties, as speciﬁ ed by your instructor. Submit the revised database in the
format speciﬁ ed by your instructor.
Make It Right
Analyze a database and correct all errors and/or improve the design.
Correcting Table Design Errors
Instructions: Start Access. Open the Care4Pets database. See the inside back cover of this topic for
instructions for downloading the Data Files for Students, or see your instructor for information on
accessing the ﬁ les required in this topic.
Care4Pets provides a variety of services to pet owners. The owner of Care4Pets has decided that
she could better manage her business if she added a multivalued ﬁ eld that lists the various types of pets
her customers have. She created the ﬁ eld shown in Figure 3–80 but forgot to add Rabbit as one of the
pet types. Modify the multivalued Lookup ﬁ eld to include Rabbit as a pet type.
Finally, she wanted to add referential integrity between the Groomer table and the Customer
table. The relationship shown in Figure 3–81 is not correct and must be ﬁ xed. She does not want to
cascade the update or the delete.