+
Exploring - Access Chapter 1: Homework Project 1 Bookstore Inventory

Exploring - Access Chapter 1: Homework Project 1 Bookstore Inventory

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/exploring-access-chapter-1-homework-project-1-bookstore-inventory/

Bookstore Inventory
 
Project Description:
In the following project, you will open a database containing the inventory of a bookstore, create a new table in which to store publisher information, add records, and then sort the table. You add a record using a form and print a report. You apply a filter by selection to a query and a filter by form to a table and save the results for both filters.
 
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

Start Access. Open the downloaded Access file namedexploring_a01_grader_h1.

0

2

Create a new table in Design view. Add the following field names to the table: PubID, PubName, PubAddress, PubCity, PubState, andPubZIP (in that order). Accept Short Text as the data type for all fields.

12

3

Set 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

4

Add the following records to the Publishers table:PubID       PubName                           PubAddress                PubCity            PubState          PubZIP
KN           Knopf                                299 Park Avenue       New York            NY              10171
BB           Bantam Books                  1540 Broadway         New York            NY              10036
PH           Pearson/Prentice Hall     1 Lake Street             Upper Saddle      NJ               07458
SS           Simon & Schuster            100 Front Street        Riverside             NJ               08075  Close the table.

12

5

Open the Books table and create a new record:AuthorCode: 15Title: The Innocence GameISBN: 0-307-96125-7PubID: KNPublDate: 2013Price: 24.95StockAmt: 250

12

6

Sort the records in the Books table by the PublDate field in descending order. Save and close the table.

4

7

Open the Maintain Authors form. In record 2 (for Keith Mulbery, AuthorID 12), add a new title to the subform:Title: Computer Wisdom IIIISBN: 0-684-80417-5PubID: PHPubDate: 2014Price: 32StockAmt: 42

12

8

Use the Navigation bar to search for AuthorID 16, and then edit the subform so that the StockAmt is 6 instead of 496 for the bookFollow the Stars Home.

8

9

Open 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. Open the Publishers, Books, and Authors query. Sort the query by the publisher’s name in ascending order.

6

10

Use filter by selection to show only the books by the author whose first name is Steven.

8


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial