Help me with my project

User Generated

Yrr45

Programming

Description

hello,

read the requirement and do my project

let me know if you have any question

please be on time

Unformatted Attachment Preview

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. UWM HCA537 Final Project Report Personal Financial Tracking Database System “Student Name” “Date” 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 of the bills can contain many transactions. 2. Mission Statement The purpose of this Personal Financial Tracking Database application is for easy access, management and tracking of all 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. 1 3.1 Relationships 3.2 Form. Screen Copy 1: Load data through Company Form (User Interface). 2 3.3 Query. (1) Bills Query: Shows Bills ID, Company ID and all the information for a specified company whose name is “Wachovia” and Location is “Milwaukee”. (2) Company Query: Shows Company ID, the name of the company that was searched by and all contact information. (3) Reports Query: Shows Reports ID, Bank Account ID, the balance that was searched by as well as the beginning and ending pay periods. (4) Transaction Query: Shows Transaction ID, Bank Account ID, Date, Amount for the specific Bills ID. (5) Bills Query 2: Shows Due Dates for the Bills for certain days and their Bills ID, Company ID, Name, Account numbers and amounts. 3 3.4 Reports Bills Report: Shows for all the companies the payment due dates and their IDs. 4
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

At...


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags