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 of your choice.
You will use graphic user interfaces of Microsoft Access to implement that database logical design. Firstly, you need to create and name a new database in Microsoft Access for your project. Then you need to create tables and establish relationships among them. The “Relationships” diagram will represent the tables, attributes of the tables and their relationships. At that time, you can directly load some data into your tables. You should design Queries in correspondence to your mission statement or objectives. Based on your tables and queries, you should be able to create Reports. The interface of that Queries and Reports can be saved as an image using “Screen Copy” method (See Tips below).
A written report for the final project is requested and a Microsoft Access database application should be provided too.
Written Report Requirements:
The format of the written report for the final project is listed as follows.
1. Cover page with title and your name
2. Description of the system
3. Mission Statement and Objectives
4. Physical Design and Implementation
4.1 Creates tables and relationships Show the “Relationships” diagram which includes information of tables, attributes and their relationships.
4.2 Create forms For each table, create a form for entering records to the table; provide Screen-Copy of each form.
4.3 Load data
4.4 Design queries to data retrieval
List at least 3 queries based on your mission statement or objectives, and provide Screen-Copy for a Query
Design View of each query.
4.5 Create reports based on queries
Show a screen copy of the final interface of your reports.
Software Requirements
Your Microsoft Access database should include at least 3 tables and there at least 10 records in each table. At least one table should contain at least 15 records. At least 3 queries and 2 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.
Contact me plezz
