Is 233

Bookstore Inventory

Project Description:

In the following project, you will open a database containing the inventory of a bookstore, create a new table in which to store publisher information, add records, and then sort the table. You add a record using a form and print a report. You apply a filter by selection to a query and a filter by form to a table and save the results for both filters.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step | Instructions | Points Possible |

1 | Start Access. Open the downloaded Access file named exploring_a01_grader_h1. | 0 |

2 | Create a new table in Design view. Add the following field names to the table: PubID, PubName, PubAddress, PubCity, PubState, and PubZIP (in that order). Accept Short Text as the data type for all fields. | 12 |

3 | Set the PubID field as the primary key of the new table. Save the table using the name Publishers and then view the table in Datasheet view. | 8 |

4 | Add the following records to the Publishers table:

PubID PubName PubAddress PubCity PubState PubZIPKN Knopf 299 Park Avenue New York NY 10171BB Bantam Books 1540 Broadway New York NY 10036PH Pearson/Prentice Hall 1 Lake Street Upper Saddle NJ 07458SS Simon & Schuster 100 Front Street Riverside NJ 08075

Close the table. | 12 |

5 | Open the Books table and create a new record:

AuthorCode: 15

Title: The Innocence Game

ISBN: 0-307-96125-7

PubID: KN

PublDate: 2013

Price: 24.95

StockAmt: 250

| 12 |

6 | Sort the records in the Books table by the PublDate field in descending order. Save and close the table. | 4 |

7 | Open the Maintain Authors form. In record 2...