Need to be done in 5 HOURS from now.

(Complete forms)

 

Implementation Hint:

1. E-R Diagram (Database Design Stage)

2. Table structures (Database Design Stage)

By Access:

3. Create tables, input some data, set the relationship

4. Create forms (note: need a query for the subform)

5. Create queries to prepare the data for reports

6. Create reports based on queries.

7. Create a blank form, put buttons on it to run forms, reports, etc.

Should be professional working.

 

Access Assignment

Rose Bookstore

  1. Description

 

A small bookstore – Rose Bookstore — mainly sells books to customers by telephone, fax, or email. The store keeps track of the business information by paper (please see the forms below). To reduce the workload and enhance the competitive in market, the owner decided to investigate the possibility of automating some of the record keeping activities of the bookstore. The intention is to increase the efficiency of the staff, and make data-driven decisions.

  Customer Form

 

Customer Name:

Street:

City:

State:

Zip Code:

Phone:

Email: Book Form

 

ISBN:

Title:

Category:

Author(s):

Units on Hand:

Cost:

Selling Price:

Edition:

Description:

Year Published:

Publisher Name: Order Form

 

Order No:

Order Date:

Order Type: (Phone, Email, Fax)

Customer:

Address:

Phone:

Shipping to Same Address:              Or:

Shipping to Name:

Shipping to Address:

Credit Card Type:

Credit Card Number:

ISBN Title Selling Price Quantity Sub Total

Total: The Requirements of Rose Bookstore

 

Track current inventory

 

Track customers

 

Track orders and invoices

 

Generate (business intelligence) reports

 

  Information System Development

 

You ar-users).

 

Note: when testing the implementation, each table needs around 10 records (you can make up the records)

 

Forms: Customer Form, Book Form, Order Form (see below), and other support forms. Comboboxes are needed for forms.

 

 

Order Form

 

 

 

Reports:

 

Invoice

 

Book sale summary report

 

Book sale detail report by ISBN

 

Customer purchase report by Customer No

 

Profit report grouped by publishers, by order types, and by categories

 

Invoice

 

Book Sale Summary Report

 

Book sale detail report by ISBN

 

Customer purchase report by Customer No

 

Profit report grouped by publisher

 

Profit report grouped by order type and category are similar to the profit report grouped by publisher.

 

Implementation Hint: E-R Diagram (Database Design Stage) Table structures (Database Design Stage)

 

By Access: Create tables, input some data, set the relationship Create forms (note: need a query for the subform) Create queries to prepare the data for reports Create reports based on queries. Create a blank form, put buttons on it to run forms, reports, etc.