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.
For the purpose of grading the project you are required to perform the following tasks:
|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.
Hint: On the CREATE tab, in the Tables group, click Table Design.
|3||Set the PubID field as the primary key of the new table. Save the table using the name Publishersand then view the table in Datasheet view.
Hint: To set the primary key, on the DESIGN tab, in the Tools group, click Primary Key. To save the table, right-click the table tab and click Save. To switch views, in the Views group, click View.
|4||Add the following records to the Publishers table:
Close the table.
|5||Open the Books table and create a new record:
Title: The Innocence Game
Hint: On the HOME tab, in the Records group, click New.
|6||Sort the records in the Books table by the PublDate field in descending order. Save and close the table.
Hint: On the HOME tab, in the Sort & Filter group, click Descending.
|7||Open the Maintain Authors form. In record 2 (for Keith Mulbery, AuthorID 12), add a new title to the subform:
Title: Computer Wisdom III
Hint: To navigate to the record, on the Navigation bar, click Next record. In the subform, on the Navigation bar, click New (blank) record.
|8||Use the Navigation bar to search for AuthorID 16, and then edit the subform so that the StockAmt is 6instead of 496 for the book Follow the Stars Home.
Hint: On the Navigation bar, click in the Search box.
|9||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 and then print the report. Open the Publishers, Books, and Authors query. Sort the query by the publisher’s name in ascending order.
Hint: On the FILE tab, click Print.
|10||Use filter by selection to show only the books by the author whose first name is Steven.
Hint: In the Author’s First Name column, click the Sort & Filter arrow.
|11||Sort the query by Title in ascending order. Save and close the query.||6|
|12||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.
Hint: On the HOME tab, in the Sort & Filter group, click Advanced.
|13||Close all database objects. Close the database and then exit Access. Submit the database as directed.||0|