Final Project: Microsoft Access Database Application

Project Descriptions:

You are requested to develop a database application using Microsoft Access. The topic of the final project should be the same topic in your ER project in this course.

A written report for the final project is requested and a Microsoft Access database application should be provided too.

1. Written Report Requirements :

The format of the written report for the final project is listed as follows.

0. Cover page with title and your name

1. Description of the system

2. Mission Statement and Objectives

3. Physical Design and Implementation

3.1 Creates tables and relationships

Show the "Relationships" diagram which includes information of tables, attributes and their relationships.

3.2 Load data (make-up data)

3.3 Design queries to retrieval data

List at least 5 queries based on your mission statement or objectives, and provide Screen-Copy for a Query

Design View of one query.

3.4 Create reports based on queries

Show a screen copy of the final interface of one report.

2. Access DB Software Requirements

Your Microsoft Access database should include more than 5 tables and there are more 5 records in each table. More than 5 queries and reports are required.

Attachment:- Description of system.rar