Database Project
HCA 447 – Healthcare Informatics
Fall 2017 (1 credit hour course)
Instructions for Database Project
Create a Microsoft Access database with mock data including creating relationships between tables,
creating a query, and creating a form that allows you to add, delete, or update a record. The Database
should contain the following tables: Patient, Physician, Clinic, etc. Unique keys need to be included for
each table like a medical record number.
Create joins/relationships between tables as needed using the unique key/foreign key. Write a simple
Select query that uses the Where clause to select a subset of records. Build a simple form to add, delete,
or update a patient.
Tips
– Use the Relationship button on the Database Tools menu to create relationships between tables
as needed.
– Use the Query Design button on the Create menu to create the query. Once the Design View
screen loads, right click on the query tab and select the SQL View to type in your SQL Query
o Sample Select Query (do not use this query):
Select ClinicName, TIN
From Clinic
Where TIN = ‘123456789’
– Use the Form Wizard on the Create menu to create the form.
o Select the Design view and add Text boxes and Buttons to the form for adding, deleting,
or updating patient information.
Upload to Blackboard or e-mail Microsoft Access file along with a short description of the database.
Evaluation Criteria
Evaluation for grade
1. Correct use of database tables
2. Correct use of unique key/foreign key
3. Successful join created between alike fields in at least two tables
4. Successful form built to add, update, or delete a patient
5. Successful query written to select a subset of records from the table(s) of your choice
Needs help with similar assignment?
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp Order Paper Now