access assignment 1 in xlsx

Dec 10th, 2014
Anonymous
Category:
Engineering
Price: $20 USD

Question description

Start Access. Open the downloaded Access file named exploring_a01_grader_h1.0
2Create a new table in Design view. Add the following field names to the table: PubID, PubName, PubAddress, PubCity, PubState, and PubZIP (in that order). Accept Short Text as the data type for all fields.12
3Set the PubID field as the primary key of the new table. Save the table using the name Publishers and then view the table in Datasheet view.8
4Add the following records to the Publishers table:
PubIDPubNamePubAddressPubCityPubStatePubZIP
KNKnopf299 Park AvenueNew YorkNY10171
BBBantam Books1540 BroadwayNew YorkNY10036
PHPearson/Prentice Hall1 Lake StreetUpper SaddleNJ07458
SSSimon & Schuster100 Front StreetRiversideNJ08075

Close the table.
12
5Open the Books table and create a new record:
AuthorCode: 15
Title: The Innocence Game
ISBN: 0-307-96125-7
PubID: KN
PublDate: 2013
Price: 24.95
StockAmt: 250
12
6Sort the records in the Books table by the PublDate field in descending order. Save and close the table.4
7Open the Maintain Authors form. In record 2 (for Keith Mulbery, AuthorID 12), add a new title to the subform:
Title: Computer Wisdom III
ISBN: 0-684-80417-5
PubID: PH
PubDate: 2014
Price: 32
StockAmt: 42
12
8Use the Navigation bar to search for AuthorID 16, and then edit the subform so that the StockAmt is 6 instead of 496 for the book Follow the Stars Home.8
9Open the Publishers, Books, and Authors report and check that the report shows three books listing Keith Mulbery as author. View the layout of the report in Print Preview and then print the report. Open the Publishers, Books, and Authors query. Sort the query by the publisher's name in ascending order.6
10Use filter by selection to show only the books by the author whose first name is Steven.8
11Sort the query by Title in ascending order. Save and close the query.6
12Open the Books table. Use Filter by Form to create a filter that will identify all books published after 2010 with fewer than 100 items in stock. Apply the filter and preview the filtered table. Close the table and save the changes.12
13Close all database objects. Close the database and then exit Access. Submit the database as directed.
exploring_a01_grader_h1.accdb 

Tutor Answer

(Top Tutor) Collin P
School: UT Austin
PREMIUM TUTOR

Studypool has helped 1,244,100 students

Review from student
Anonymous
" Outstanding Job!!!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1824 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors