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.
c.Change the PubCity for Pearson to Hoboken.
d.Close the Publishers table.
e.Open the Author table in Datasheet view.
f.Navigate to the last record (Author ID of XXXX01) and replace YourFirstName with your first name and YourLastName with your last name. Close the table.
g.Open the Author table again and notice the changes you made have been stored.
h.Click the plus sign next to your name. Notice the book Social Media: A Student’s View is listed. Close the table again.
i.Open the Books table in Datasheet view. Notice the book with ISBN 9780809400775 (American Cooking: The Northwest) has no items in stock. Delete this record.
j.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.