In Chapter 9 you created a database for the Snick's Board Shop consisting of a Products table, a Category table, and a Manufacturer table. You also created an initial query, form, and report. Caitlin has now asked you to make some changes to those files.

Make the following changes for Caitlin, using the ch9-05_student_name file you created in Chapter 9.

a. Add Category ID 6, Category Name T-shirts to the category table.

b. Add Manufacturer ID AH, Manufacturer Name Anti-Hero to the manufacturer table.

c. Add Product ID 62-01296, Product Name Anti-Hero Logo T-Shirt, Category ID 6, Manufacturer ID AH, Price $14,99, Style Red, Quantity 30 to the product table

d. Change Product ID 65-23174 to 61 -23174

e. Delete Product ID 65-01837 from the product table.

f. Enforce referential integrity between the tables.

g. Print the Relationships report.

h. Add a Picture field for OLE objects to the Products table.

i. Add pictures to the products table. {Note: Pictures for these products are provided in the Images folder and are labeled with the Product ID.)

j. Add a Phone Number field to the manufacturer table with a standard phone number input mask and then add the following phone numbers to the manufacturer table.

Manufacturer IDPhone Number

AH...................... 619-555-8521

EMT .................... 305-555-7861

S9........................ 415-555-7142

Create a validation rule for the Price field of the product table, making the price field required and making sure the price is greater than $ 1 but less than $500. Create your own feedback statement and enter it as the validation text. Save the changes you made.

1. Establish a default value of 20 for the Quantify field of the product table.

m. Resize the column width of the product table so that it can fit on one page when printed in landscape orientation.

n. Use Access's help feature to learn how to sort tables alphabetically by a certain field. Then sort and save each table by its primary key.

o. Print each table.

p. Print documentation on the properties of the Phone Number field of the manufacturer table and the quantity field of the product table.