Validation controls are given to create some rules for your assignment E.g. Validity check you can put minimum or maximum range. Validation rule gives you some rules witch you have to follow. The big advantage of using a validation rule is that there will be fewer changes of errors and making mistakes in my database this is why I think a validation rule is important in my database.
➔ Relationship- A relationships works when you extract information from both of the tables. It is a common link between the two tables. It gives your database a good overall structure.
I will be creating a relationship between the doctors and patients table; in Microsoft Access for my database. The relationship will be showing what the two tables have in common as I will identify and explain below.
A relationship between the two tables is needed in Whipps Cross Hospital as then doctors will be able to read it easily as well as they can take any information from both of the tables which they want directly. Relationships are important because it shows the relationship between the two tables and what the have in common just like common family DNA cells. Relationship between two tables will allow Whipps Cross Hospital to search lots of tables at the same time.
This is how I will create a relationship in my database; the first step into creating my relationship between the two tables is, to click on the ‘start’, and go to programmes to find ‘Microsoft Access’. After, this document is open I will have to select the button which says ‘open existing files’ then click ‘ok’. After this stage, I will have to go on the file where I have saved the patients and doctor’s table under and click ‘ok’. Then I would have to click on this icon which is located on the toolbars, after that a table will show saying doctors table on one line and the line below says the patients table. I would select one of the two tables and then click ‘add’ and I have to do the same for the other remaining table and then close that table. Then the patients and doctors table would appear. After that, I will have to find out what the two tables have in common. For example ‘Doctors ID’ witch will be common in both tables in my database. Then on one of the two tables I will have to click on the ‘Doctor’s ID’ and drag it to the other table where it says Doctor’s ID and, then I can find any other relationship if so between the two tables. That is how I would create a relationship between two tables however to see the relationship again I can always click on the save icon as before and it will illustrate the direct relationships that has been created.
- This is the icon used to create a relationship witch is located on the top of the database toolbar.
➔Forms- a form is like a blank document witch allows you to enter information in to the database.
In my database a form will work as a piece of paper where information needs to be filled in about the Doctor and Patients. It is useful because it will tell the information about the Doctor and Patient and updates the patients and doctors information about them witch will narrow my search when I am finding out information about the staff and the patients in Whipps cross hospital. I will also give each field its suitable form to access the information required. I will create a separate form for each doctor and patient in Whipps Cross Hospital so the information don’t get mixed and makes it less complicated to store. Whipps Cross Hospital will need the different forms as it will be easy to find out any information about them and also updates their database system on the patients and doctors.
Doctor’s Form:
Doctor ID:
Forename:
Surname:
Address:
Phone number:
Gender:
Salary:
Ward:
Specialist:
Patient’s Form:
Patient’s ID: Date discharged:
Doctor’s ID: Ward:
Surname: Phone number:
Forename: Postcode:
Gender: Illness:
Data of birth:
Address:
NSH number:
Date admitted:
➔ Queries – This is a selection of data from the table in a database where a single query can extract data from different tables. Queries are particular searches that can be run on the database. This is better than going through each and every data and it will waste time. Queries are much quicker and it will save time leaving the hospital staff to do other stuff.
Whipps Cross Hospital can just run the queries and check if there database is working effectively it will save there time and make things easier to find and store. They can find the information needed very easily. This will also affect the general running of the database it will make it faster, quicker and more efficient for the hospital stuff.
Now I am going to plan how I will be creating queries in my database and a brief design of what my queries will look like. For each of my queries I will have the following layouts:
Query Design - this is what the 1st query will actually look like in my Microsoft access database document:
Criteria- there is a rule behind how to input a data under the criteria, the word entered must contain a = sign and explanation marks before and after the criteria data for example; if I want to find out certain type of illness witch maybe ‘ENT’ I will enter this information in the criteria row like this, ="ENT" (without leaving any gaps).
Query Design - this is what the 2nd query will look like in my Microsoft access database document:
Query Design - this is what the 3rd query will look like in my Microsoft access database document:
Query Design - this is what the 4th query will look like in my Microsoft access database document:
Query Design - this is what the 5th query will look like in my Microsoft access database document:
Query Design - this is what the 6th query will look like in my Microsoft access database document:
Query Design - this is what the 7th query will look like in my Microsoft access database document:
Query Design - this is what the 8th query will look like in my Microsoft access database document:
Query Design - this is what the 9th query will look like in my Microsoft access database document:
Query Design - this is what the 10th query will look like in my Microsoft access database document:
➔ Reports - a report in Microsoft access will allow me to see information from the database in a presentable form. Whipps Cross will need reports in their database so they can see the out come of they results. This saves time, as you don’t have to go through a long process of making reports where as Microsoft access produces the reports for you depending on what to want the output to come out as. The reports produced using Microsoft access is more accurate and reliable.
The reports will be linked to the queries that I will design so; the information from the queries will be used to design my report for Whipps Cross Hospital. In the report all the information is extracted from the Queries, which I will design.
I will be using reports to extract data for my doctor’s table, patients table as well as all my queries so the information is more presentable.
This is the design of my
Doctor’s report:
Doctors Forename Surname Address Phone Gender Salary Ward Special
09 July 2007 Page 1 of 1
This is the design of my
Patients report:
Patie Docto Surna Foren Ge Date Addre NHS Data Date Ward Phon Postco Ill
09 July 2007 Page 1 of 2
This is the design of my
Query 1 report:
Doctors ID Forename Surname Illness
11 July 2007 Page 1 of 1
This is the design of my
Query 2 report:
Doctors ID Forename Surname Patients ID Ward Illness
11 July 2007 Page 1 of 1
This is the design of my
Query 3 report:
Patients ID Forename Surname Gender Ward
11 July 2007 Page 1 of 1
This is the design of my
Query 4 report:
Doctors ID Forename Surname Specialist Ward
11 July 2007 Page 1 of 1
This is the design of my
Query 5 report:
Doctors ID Forename Surname Gender Specialist Ward
11 July 2007 Page 1 of 1
This is the design of my
Query 6 report:
Doctors ID doctors.Forena doctors.Surna Patients ID patient.Forena patient.Surnam
11 July 2007 Page 1 of 1
This is the design of my
Query 7 report:
Patients ID Forename Surname Illness Ward
11 July 2007 Page 1 of 1
This is the design of my
Query 8 report:
Doctors ID Forename Surname Specialist Ward
11 July 2007 Page 1 of 1
This is the design of my
Query 9 report:
Patie Docto Foren Surna Ge Date Addre NHS Data Date Ward Phon Postco Ill
11 July 2007 Page 1 of 1
This is the design of my
Query10 report
Doctors doctors.F doctors.S Gender Patients patient.F patient.S Ward Illness
11 July 2007 Page 1 of 1
End of my database