You will open an original database file and save the database with a new name. You will then demonstrate adding, updating, and deleting information.
others
Description
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.
PubID
PubName
PubCity
PubState
DC
DC Comics
New York
NY
SM
St. Martin
Boston
MA
TB
Triumph Books
Chicago
IL
TL
Time Life
Pueblo
CO
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.
