We Helped With This ACCESS Database Homework: Have A Similar One?

Design a database using MS Access with the following specifications (at least):

1.      Create appropriate tables (you should have at least 5​ tables)​ and identify relationships. 

2.      Identify clearly the ​primary and ​        ​foreign​ key (s). 

3.      Data should be entered using a data entry form​         .​ 

4.      Design queries that ask for ​user input​ (i.e., ask for a patient id to retrieve patient information.) Patient visits the hospital. First, patients have to register with the registration clerk, where the clerk records patient demographics (name, id, address, gender, race etc.). Then they are called by an assigned nurse to record information such as body temperature, blood pressure etc. After that they will see assigned doctor. Depending on situation, doctors may or may not admit patients for inpatient services. Doctor provides new prescriptions for patients and records all the medications that a patient is currently taking. Each medication has start date as well as end date and physician information who prescribes the medication. Doctor may also order laboratory works for the patient. Laboratory attendant updates the lab test results for 

5.      Generate a report​ on your database to answer questions (for example, how many patients were hospitalized due to cardiac problems) 

6.      Design ​queries to retrieve information​ from multiple tables. 

7.      After any update or manipulation, your database should maintain ​referential integrity​. 

Example database project:

Scenario: Assume you are a new person hired to create and maintain a small hospital patient database. The hospital has the following scenario:

8.      each of the patients with proper order and information. 

Design a hospital patient management database with tables for each of the proper entities (patient, medications, hospital staff, lab test, hospitalization of patients, doctor information, prescriptions etc.). For each patient’s visit, patient should have a primary diagnosis (reason for visit) also. ​Populate your tables with appropriate dummy data​ (make up your own data). This is just a sample to give you an idea about how your database project should be. Please view the attached document for your reference (do not copy).

What to submit:

-            Objective 

-            A detail description of your project

-            Diagram of your database including tables with attributes and relationships.

-            SQL for queries.

-            Screenshots of the queries and results (at least for specifications 4,5 and 6 mentioned above)

-            Your database project in MS Access 

-            Don't use exe ( executable file format)  

My project is about Pharmacy Database

I named my pharmacy Einstein Pharmacy

Structure: 

1st form: is the welcome homepage

Welcome Info (create a label)

Pharmacy Name (label)

Click here (command) to go to the next form

A logo and an image 

Also add an "Exit" option on every page (form)

2nd form: should include

the Pharmacy name (title) Menu (label)

add pt info (command) that leads to another form (3rd form) add doc info (command) that leads to another form (fourth form) an option button to go back to the welcome page an option button to exit the form

3rd Form: Patient Info

navigation button ( next/previous record, etc...)

Add , Save, Delete options 

Go to the homepage

Name of the Pharmacy 

Logo

4th Form: Doc info

navigation button ( next/previous record, etc...)

Add , Save, Delete options  Go to the homepage name of the Pharmacy 

Logo

Every form should has: Exit 

Go to the previous page 

Name of Pharmacy 

Logo

This is an introductory level assignment: 

Important features to use in:

Static and a dynamic Query

Forms, reports 

Look-up wizards

Validation text when inserting invalid email/number/entry

Use a proper validation rule for email. ex. ( Like "?*@?*.??*" And Like "*[!0-9a-z]*" And Is Not Null )

Use a proper validation rule for number. ex. ( Like "##########" )

Don't use exe ( executable file format)