HCA537 homework

HCA-537: Introduction to Health Database and Technologies Instructor: Wu,M

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 (60%) for the final project is requested and a Microsoft

Access database application (40%) should be provided too.

1. Written Report Requirements (60%):

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 (40%)

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.

Helping Line

 Tips: After you click “Shift” and “PrtScr” (Print Screen) buttons at the same time, the current content of the screen will be copied. You can paste it into some Image Editor software, such as Paint, to edit it. Then you

can insert it into your word file in the end.