Let us worry about your assignment instead!

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

More InfoMs Access Help

Short Assignment Requirements

I am attaching my work for revision. I built a pharmacy database; Einstein Pharmacy. I need some help with queries, forms, reports. Please review my work and let me know what you think before you start working on revisions.

Assignment Description

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




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 



4th Form: Doc info

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

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



Every form should has: Exit 

Go to the previous page 

Name of Pharmacy 




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) 

Frequently Asked Questions

Is it free to get my assignment evaluated?

Yes. No hidden fees. You pay for the solution only, and all the explanations about how to run it are included in the price. It takes up to 24 hours to get a quote from an expert. In some cases, we can help you faster if an expert is available, but you should always order in advance to avoid the risks. You can place a new order here.

How much does it cost?

The cost depends on many factors: how far away the deadline is, how hard/big the task is, if it is code only or a report, etc. We try to give rough estimates here, but it is just for orientation (in USD):

Regular homework$20 - $150
Advanced homework$100 - $300
Group project or a report$200 - $500
Mid-term or final project$200 - $800
Live exam help$100 - $300
Full thesis$1000 - $3000

How do I pay?

Credit card or PayPal. You don't need to create/have a Payal account in order to pay by a credit card. Paypal offers you "buyer's protection" in case of any issues.

Why do I need to pay in advance?

We have no way to request money after we send you the solution. PayPal works as a middleman, which protects you in case of any disputes, so you should feel safe paying using PayPal.

Do you do essays?

No, unless it is a data analysis essay or report. This is because essays are very personal and it is easy to see when they are written by another person. This is not the case with math and programming.

Why there are no discounts?

It is because we don't want to lie - in such services no discount can be set in advance because we set the price knowing that there is a discount. For example, if we wanted to ask for $100, we could tell that the price is $200 and because you are special, we can do a 50% discount. It is the way all scam websites operate. We set honest prices instead, so there is no need for fake discounts.

Do you do live tutoring?

No, it is simply not how we operate. How often do you meet a great programmer who is also a great speaker? Rarely. It is why we encourage our experts to write down explanations instead of having a live call. It is often enough to get you started - analyzing and running the solutions is a big part of learning.

What happens if I am not satisfied with the solution?

Another expert will review the task, and if your claim is reasonable - we refund the payment and often block the freelancer from our platform. Because we are so harsh with our experts - the ones working with us are very trustworthy to deliver high-quality assignment solutions on time.

Customer Feedback

"Thanks for explanations after the assignment was already completed... Emily is such a nice tutor! "

Order #13073

Find Us On

soc fb soc insta

Paypal supported