You are employed as a technical supervisor at a chain of book- stores. One of the store managers has expressed confusion about Access. You have offered to train her on the basics of Access. To avoid mistakes in the main database, you will save the file with a new name. You will then train her on the basics of the data- base system, including making data modifications, sorting and filtering, adding a table using an application part, and creating a backup.

Modify Data in a Table

You will open an original database file and save the database with a new name. You will then demonstrate adding, updating, and deleting information.

a.Open the a01c1Books file and save the database as a01c1Books_LastFirst.

b.Open the Publishers table in Datasheet view. Notice that some of the publisher city and state information is missing. Update the database with the information below and close the table.

Sort a Table and Apply a Selection Filter

You will sort the publisher's table by name and then apply a filter to display only publishers located in New York.

a.Open the Publishers table in Datasheet view. Notice Time Life appears after Triumph Books. This is because the table is sorted by the PubID field.

b.Click in any record in the PubName field and sort the field in ascending order.

c.Apply a Selection filter to display only publishers with a PubCity equal to New York.

d.Close the table and save the changes. Use Filter By Form

You will obtain a list of all books with more than 50 units in stock. This will help the management decide on what books to put on sale. You will use Filter By Form to accomplish this. You will also demonstrate how filters are saved.

a.Open the Books table in Datasheet view. b.Use Filter By Form to display books with more than 50

units in stock. Save and close the table.

c.Open the Books table in Datasheet view. Click Toggle Filter in the Sort & Filter group to demonstrate that the filter is saved.

Back Up a Database and Add an Application Part

You will demonstrate adding an application part to the manager to show how tables are created. You will first back the database up to reinforce the importance of backing up the data.

a.Create a backup copy of your database, accepting the default file name.

b.Add a Comments application part, selecting the option One 'Books' to many 'Comments'. Select the Title field for the Field from Books and Sort Ascending for Sort this field. Name the lookup column Book.

c.Open the Comments table in Datasheet view. Add a new comment. Select Social Media: A Student's View for the Book. Use the current date and add A fun and insightful book! for the Comment field.

d.Close the database and exit Access. Based on your instructor's directions, submit the following:

a01c1Books_LastFirst a01c1Books_LastFirst_CurrentDate

Attachments:

• 1515069348-a01c1Books.accdb