Microsoft Office Tutorials and References
In Depth Information
AC 198
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 fi 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 specifi ed by your instructor. Submit the revised database in the
format specifi 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 fi 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 fi eld that lists the various types of pets
her customers have. She created the fi eld shown in Figure 3–80 but forgot to add Rabbit as one of the
pet types. Modify the multivalued Lookup fi eld to include Rabbit as a pet type.
Figure 3–80
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 fi xed. She does not want to
cascade the update or the delete.
Search JabSto ::

Custom Search