Final Project: Microsoft Access Database Application

Roman","serif";”>Project Descriptions
Roman","serif";”>:

Roman","serif";”>You are requested to develop a database application using Microsoft Access. The topic of the final project should be of your choice.

Roman","serif";”>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).

Roman","serif"; font-size: 12.0pt; line-height: 115%;”> 
.

Roman","serif"; font-size: 12.0pt; line-height: 115%;”>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

[email protected]

 
.

Click here to get this paper done by our professional writers at an affordable price!!