Microsoft Access Case

In this report we are highlighting significance of real life general store and how the transactions are carried there. Our report consists of 8 tables, 7 forms, 5 queries, 3 reports, 2 macros and a main switch board.

TABLES:

1. CATEGORY: This table consists of three fields i.e. category id, category name and description. There are three records in each field. Primary key category id.

2. CUSTOMER: This table consists of seven fields i.e. customer id, first name, last name, address 1, address 2, city and phone. There are four records in each field except for phone which has two records. Primary key customer id.

3. EMPLOYEE: This table consists of eight fields i.e. employee id, first name, last name, date of birth, hire date, address 1, address 2 and city. There are five records in each field. Primary key employee id.

4. ORDER: This table consists of four fields i.e. order id, customer id, employee id and order date. There are five records in each field. Primary key order id.

5. ORDER DETAIL: This table consists of five fields i.e. order id, product id, unit price, quantity and amount. There are eight records in each field.

6. PRODUCTS: This table consists of four fields i.e. product id, product name, supplier id and category id. There are eleven records in each field. Primary key product id.

7. SUPPLIERS: This table consists of six fields’ i.e. supplier id, first name, last name, company name, address 1 and address 2. There are four records in each field. Primary key supplier id.

FORMS:

1. CATEGORY: Form of category table with a sub form of products table. Includes buttons of previous record, next record, add record, save record, delete record, close form and open report.

2. CUSTOMER: Form of customer table with a sub form of order table. Includes buttons of last record, previous record, next record, add record, save record,