Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Probability and Random Processes With Applications to Signal Processing and Communications

Authors: Scott Miller, Donald Childers

2nd edition

123869811, 978-0121726515, 121726517, 978-0130200716, 978-0123869814

More Books

Students also viewed these Mathematics questions