Recall from Chapter 2 that Kelly's Boutique sells books as well as women's shoes. Kelly's son Casey,

Question:

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.

Recall from Chapter 2 that Kelly's Boutique sells books as

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.