Final Project: Microsoft Access Database Application Project Descriptions : You

Question

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.

Cover page with title and your name

Description of the system

Mission Statement and Objectives

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

1. Description Personal Financial Tracking Database System is designed for more personal use to organize and keep track of bill payments and transactions in bank accounts. It also contains quick access to any additional information of all companies that are involved with a user. One user can have many bank accounts which can have many transactions as well as many reports. At the same time any of the companies can have many bills for the user and any ofthe bills can contain many transactions. 2.Mission Statement The purpose of this Personal Financial Tracking Database application is for easy access, management and tracking ofall deposits, withdrawals, transfers and any other activity in the bank account. 3. Mission objectives To keep track of transactions in bank accounts. To keep bill payments organized. To have all needed information on the companies. To keep information on reports To have all information handy with a quick access for a user.

Explanation / Answer

1.Select billsid,companyid from company c,bills b where companyname=”Wachovia” and location=”Milwaukee”

2.

Select companyid,location,compnayname,telephone,website,agent from company c where c.compnyid=101

Or

Select * from company c where c.compnyid=101

3. Select bankaccountid,reportsid,balance from reports r where payperiod=1 and payperiod=10

4 .Select tranctionid,bankaccountid ,date,amount from bills b,transaction t where b.billsid=67

5.select billsid,company id ,companyname,account numbers,amounts from bills b,company c where b.duedates=11-12-2015

3.4

Select compnayname ,due date ,billsid,company id from bills,company;

Tables:

CREATE TABLE company
(
companyid int NOT NULL PRIMARY KEY,
telephone int NOT NULL,

companyname int NOT NULL,
location varchar(10) NOT NULL,
website varchar(10) NOT NULL,

agent varchar(10) NOT NULL,
PRIMARY KEY (companyid),
FOREIGN KEY (billsid) REFERENCES bills(billsid)
)

CREATE TABLE bills
(

billsid int,
duedate date NOT NULL,
companyid int NOT NULL,
accountnumbers int,

amount int,

PRIMARY KEY (billsid),
FOREIGN KEY (reportsid) REFERENCES reports(reportsid)
)

CREATE TABLE reports
(

reportsid int,
date date NOT NULL,
bankaccountid int NOT NULL,

balance int,
payperiods int,
PRIMARY KEY (reportsid),
FOREIGN KEY (bankaccountid) REFERENCES bankaccount(bankaccountid)
)

CREATE TABLE transction
(

transcation id int,
date date NOT NULL,
billsid int NOT NULL,

bankaccountid int NOT NULL,

amount int,

PRIMARY KEY (transctionid),
FOREIGN KEY (bankaccountid) REFERENCES bankaccount(bankaccountid)
)

CREATE TABLE bankaccount
(

billsid int NOT NULL,

bankaccountid int NOT NULL,

amount int,

PRIMARY KEY (bankaccountid),

FOREIGN KEY (transctionid) REFERENCES transction(transctionid)

)

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.