Microsoft Office Tutorials and References
In Depth Information
Extend Your Knowledge AC 197
2. Format the Customer Number ﬁ eld so any lowercase letters appear in uppercase and make the
Customer Name ﬁ eld a required ﬁ eld.
3. Specify that balance amounts must be between $0.0 and $1,000. Include validation text.
4. Save the changes to the Customer table.
5. Create a simple form for the Customer table and ﬁ nd the record for ME71 and change the customer
name to Mentor Group Limited. Save the form as Customer Simple Form and close the form.
6. Open the Customer table in Datasheet view and use Filter By Selection to ﬁ nd the record for CI76.
Delete the record. Remove the ﬁ lter.
7. Resize all columns to best ﬁ t and remove the gridlines from the datasheet. Save the changes to the
layout of the table. Close the Customer table.
8. Establish referential integrity between the Courier table (the one table) and the Customer table
(the many table). Cascade the update but do not cascade the delete.
9. Submit the revised database in the format speciﬁ ed by your instructor.
Extend Your Knowledge
Extend the skills you learned in this chapter and experiment with new skills. You may need to
use Help to complete the assignment.
Creating Action Queries, Changing Table Properties
Instructions: 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.
Backyard is a retail business that specializes in products for the outdoors. The owner has created
an Access database in which to store information about the products he sells. He recently acquired the
inventory of a store that is going out of business. The inventory currently is stored in the Inventory
Perform the following tasks:
1. The owner needs to add the items stored in the Product table of the Inventory database to the Item
table of the Backyard database. Create and run an append query to create the Item table for the
Backyard database shown in Figure 3–79.