In Chapter 9 you created a database for Kelly's Boutique consisting of a Book table, a Department table, and a Publisher table. You also created an initial form, query, and report. Kelly would now like you to make some adjustments to the tables previously created by adding and deleting some records, adding some OLE fields and pictures, and changing the structure of the database. Make the following changes for Kelly using the ch9-03_student_name file you created in Chapter 9. (Note: Open your ch9-03_student_name file first, save it as chl0-03_student_name, and then make the listed changes.)

a. Add Warner as the tenth publisher to the Publisher table with a contact Yee and phone 555-7894.

b. Add the following records to the Book table:

c. Add a Picture field for OLE objects to the Book table.
d. Add pictures to the Book table for Green Eggs and Ham, Hop on Pop, Harry Potter and the Prisoner of Azkaban, Divine Secrets, and Deep End of the Ocean. Picture files are labeled by book name and are located on your student disk.
e. Resize the column width of each field and the record's row height of each table so that they fit on one page when printed.
f. Establish a phone number input mask for the Phone field of the Publisher and Department tables.
g. Enforce referential integrity between the Book table and the Department and Publisher tables.
h. Create a validation rule for the List price field of the Book table, making the field a required one and making sure the price is no less than $ 1 but no more than $100. Create your own feedback statement and insert it as the validation text.
i. Establish Children as the default value for the Department field of the Book table.
j- Print the Book, Department, and Publisher tables.
k. Print the Relationships report.
l. Print documentation on the properties of the List Price field of the Book table and the Phone field of the Publisher table.

Transcribed Image Text:

S8N Dept Book Title Author Price Seuss 7.99 Seuss 7.99 Sparks 16.95 Num 039480029 Children Hop on Pop 039480001 Children The Cat in the Hat 6 446676098 Adult The Notebook 10