Answer Happy

EX16_AC_CH01_GRADER_CAP_HW - Bookstore Inventory Project Description: In the following project, you will open a database containing the inventory of a bookstore, work with tables, add records, and sort a 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 Steps to Perform: Step 1 2 3 4 5 6 Start Access. Open the downloaded Access file named exploring a01_grader_h1. Open the Publishers table in Datasheet view. Add the following records to the Publishers table: PubID PubZIP KN 10171 BB 10036 PH 07030 SS 08075 PubAddress 299 Park Avenue 1540 Broadway Pearson/Prentice Hall 211 River Street Simon & Schuster 100 Front Street PubName Knopf Bantam Books Close the table. Instructions 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 Title: Computer Wisdom III ISBN: 0-684-80417-5 PubCity PubID: PH PubDate: 2017 Price: 32 StockAmt: 42 New York New York Hoboken Riverside PubState NY NY NJ Sort the records in the Books table by the PublDate field in descending order. Save and close the table. NJ Open the Maintain Authors form. In record 2 (for Keith Mulbery, AuthorID 12), add a new title to the subform: Use the Navigation bar to search for AuthorID 16, and then edit the subform so that the StockAmt is 6 instead of 496 for the book Follow the Stars Home Points Possible 0 16 12 8 12 10

Step 7 8 9 10 11 Instructions Open the Publishers, Books, and Authors report and check that the report shows three books listing Keith Mulbery as author. View the layout of the report in Print Preview. Open the Publishers, Books, and Authors query. Sort the query by the publisher's name in ascending order. Use filter by selection to show only the books by the author whose first name is Steven. Sort the query by Title in ascending order. Save and close the query. Open the Books table. Use Filter by Form to create a filter that will identify all books published after 2010 with fewer than 100 items in stock. Apply the filter and preview the filtered table. Close the table and save the changes. Close all database objects. Close the database and then exit Access. Submit the database as directed. Total Points Points Possible 10 10 10 12 0 100