Recall from Chapter 2 that Kelly's Boutique sells books as well as women's shoes. Kelly's son Casey, a college accounting student who is home for the holidays, is eager to help his mom incorporate computers in her business. In this chapter (and in those that follow), Casey will try teaching Kelly the use of Access as it applies to her accounting and business needs.

Casey suggests that Kelly use a database to keep a record of her book inventory. Kelly has a partial list of books she has purchased that she thinks should be part of the database. This list includes each book's ISBN, department name, related supervisor and phone number of the supervisor, book title, publisher, publisher contact, publisher phone number, author, and list price.

Create a new database file using the following information and name the file ch9-03_student_name (replacing student name with your name).

a. Use the information below to create a book table, department table, and publisher table in Access. Then print each table.

b. Establish the appropriate relationship between each table. Print the relationships report.
c. Create and print a query that lists department, book title, author, supervisor, publisher, and contact. Save this query as Books by Department.
d. Create a form that shows all fields from the book table in a columnar format with. Save it as Book Form, and print the first record.
e. Create and print a report that contains the book title, ISBN, publisher, and phone number. The report should have no grouping, be sorted by book title in ascending order, and be formatted in a tabular portrait layout and the title Book Report. All field information should be visible.

ISBN Dept Book Title Pub Num Author List Price 684872153 Adult Angela's Ashes 7 McCourt 7.99 2Lovelace 1295 5 McCloskey 16.99 17.00 Mitchard 12.95 6024415 Children Betsy-Tacy 670175919 Children Blueberries for Sal 27136701 Children Caddie Woodlawn Brink 140286276 Adult Deep End of the Ocean ISBN Book Title Divine Secrets of the YaYa Sisterhood Pub Num Author List Price $24.00 S7.99 60173289 Adult Wells 394800168 Childre Green Eggs and Ham Seuss 439064864 Children Harry Potter and the 439136350 Children 590353403 Children Chamber of Secrets Harry Potter and the Prisoner of Azkaban Harry Potter and the Sorcerer's Stone Rowling Rowling Rowling 17.95 17.95 17.95 Dept Adult Children Barbara Manchester Supervisor Nancy Wine Phone 555-9754 555-1974 Pub Num Publisher Contact Phone Mass Market Paperback Harper Collins Penguin Simon & Schuster Viking Press Random House Scholastic Press Touchstone Books Arthur A. Levine Books Smith Potter Frued Gonzalez 555-9745 555-7481 555-8974 555-9874 555-1654 555-9144 555-9888 555-1112 555-5118 4 Ouimet Salazar Chi Robinsorn