Question: Create a new table in Design view. Add the following eld names to the table: Pule. 2 PubName, PubAddress, PubCity, PubState. and PubZIP (in that

 Create a new table in Design view. Add the following eld

Create a new table in Design view. Add the following eld names to the table: Pule. 2 PubName, PubAddress, PubCity, PubState. and PubZIP (in that order). Accept Short Text as the data type for all elds. Set the Pule eld as the primary key of the new table. Save the table using the name 3 Publishers and then view the table in Datasheet view. Add the following records to the Publishers table: Pule PubName PubAddress PubCity PubState PubZlP KN Knopf 299 Park Avenue New York NY 10171 BB Bantam Books 1540 Broadway New York NY 4 10036 PH Pearson/Prentice Hall 1 Lake Street Upper Saddle N] 07458 SS Simon 5: Schuster 100 Front Street Riverside N] 08075 Close the table. Open the Books table and create a new record: AuthorCode: 15 Title: The Innocence Game ISBN: 0-307-96125-7 5 Pule: KN Puleate: 2013 Price: 24.95 StockAmt: 250 Sort the records in the Books table by the Puleate eld in descending order. Save and close the table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!