CRITERION D

Criterion D: Evaluation

Criterion A: Inquiring and Analyzing

This is the first stage of the process where I had to do a lot of research in order to achieve the goals set in the task. I had sent questionnaires to various people such as cancer patients, oncologists, survivors, etc. I had also sent to Mr. James who is the manager of the pharmaceutical company. In addition, I researched on the internet to search for different types of templates and features which I could use for my database. I created a research plan so that I can see which fields must be included in the database.

Self-evaluation:

Although our teacher taught us how to use Microsoft Access, I wanted to research on the internet to find out more programs which can be used for this type of situation. However, I was unable to find easier programs and had to stick with this database.

Since this is my first time trying out Microsoft Access, I wanted to know what other features I can use in my database. My research plan helped me to find out the requirements especially the fields which I can add in my database. The interview questions for oncologist, Mr. Mohandas, helped me to find out the various, existing drugs in the market, their composition as well as what diseases they cure. Although, I feel that I should have added more questions concerning main details such as manufacture date, expiry date, etc. of all the medicines. This would make my work easier and add in the information from the interview. The SWOT Analysis which elaborated on the strengths, weaknesses, opportunities and threats of the product after testing. This can be used later on when improving it.

The design brief was written to show the creation of the software and the new features which will be used by the company. I had to research a few features to add to my database and watch a few YouTube tutorials on how to add these features and their specific function in the database.

Criterion B: Designing

This is the second stage where I had to plan the creation for my database. As usual, I had to research for various features such as checkboxes, combo-boxes, buttons, etc. I had to produce a few sketches for my designs of the database and had to evaluate which one was the better design according to the subject in the task. I created a flowchart as well as the layout for my database which will help me in making my database organized.

Self-Evaluation:

I had eight designs which were about the cancer drug information form, main menu, patient details form and security. Each design was evaluated consistently and the best one was chosen among the two for each. A few features such as combo-boxes, option-group, tab order, buttons, etc. were added in a few of these designs. There were two ways to do the security feature. I took the alternative, short one where I had to open the database in exclusive and encrypt it with a password. I structured the layout for my database, where the fields will be organized. I also followed the flow chart which helped me in creating my database. In addition, I did a test plan for the end product to make sure that there were no malfunctions with the system.

I added another feature which is the expression builder. I was able to make calculations on the total cost of the drug the patient bought (depending on quantity) using this feature. A list-box in patient details form which allowed the user to select the ID of the patient for the record.

Criterion C: Creating the Solution

In this section, I had to create the final product, which is my database. Eventually, I had to do a lot of research to find out the variety of features and templates I can use for this application. I enjoyed this section the most because there were a lot of features in which I wanted explore. Unfortunately, due to the time limit we had for this task, I could not add more. I tested all the features in the database to ensure the success of the final product.

Self-Evaluation:

The research conducted in this stage was particularly difficult but I was able to find the features, how to include them and how they function. When I was creating relationships between patient details and cancer drug information, I experienced trouble because both the fields had to be the same to enforce referential integrity. This problem also occurred when I was trying to enter information onto another table which had no relationship.

For the picture box, when I was trying to add an image with a png format, it did not show the picture only the icon. According to the research done, I found that the picture box could only display the image with a bmp format.

The security feature was easy to input. All I had to do was to open the document in an exclusive format and encrypt it with a password.

The expression builder was used to show the calculations for the total cost of drug (s) purchased by the customer (depending on the quantity). Overall, I followed the design specification throughout this stage and added the features in certain places where they were really required.

Criterion D: Evaluation

This is the last section of the design cycle

CRITERION C: CREATING THE SOLUTION

Criterion C: Creating the Solution

Tables: 

In this table, I have used an expression builder which has allowed to carry out the following calculations:

Queries:

In the following queries, I have added parameters which will take in effect if the user enters specific data:

GENDER AND NATIONALITY:

Manufacturers:

Forms:

Cancer Drug Information:

Patient Details:

Main Menu:

Macros:

Here are some macros:

Reports:

Main Drug Details:

Main Patient Details:

Security:

GANTT CHART

Gantt Chart

CRITERION B: DESIGNING

Criterion B (Designing)

Design Specification

This design specification will provide information about the cancer drugs and the various details such as manufacture date, expiry date, brand name, etc.

The database will have two tables which will contain information about the cancer drugs and patient details, who are buying the drugs. For this, queries, reports and forms will be made based on this information. Forms will contain a few features such as tab control, hyperlinks, auto-dialer, exit, option group, list box and buttons which will make it easy for the user to work on the database. There are also a few validation rules which will reject unnecessary data.

There is also a menu interface and several buttons to select options which will guide the user step by step. It will also take the user to different areas such as cancer drug information, patient details, etc.

I have used a few different features in my Microsoft Access Database. They are the following:

Features	Justification
Key Field	To identify a specific record.
Picture Box	Inserted box which displays the image of the drug/patient.
List Box	Displays a list of values or choices. It is similar to a combo box but contains rows of data.
Buttons	To select different options such as close form, save record, etc.
Tab control	Consists of different pages where you can add features such as buttons, hyperlinks, etc.
Option group	Allows the user to select an option.
Queries	Displays broken down data from different tables such as details about drug, prices, etc.
Forms	I have three forms in my database. Displays data from tables.
Reports	Display a summary of data.
Tables	There will be two tables which will display the data for cancer drug information and patient details.
Combo Boxes	Allows the user to select an option.
Validation Rule	Allows only necessary data to be added into the table.
Validation Text	If unreasonable data has been entered into the table, then this feature will display an error message.
Security	This will secure the database with the help of a password only.

Plan for Cancer drug information table:

Field Name	Datatype	Width	Example
ID	Number		75238749
Name	Text	20	Rituximab
Brand Name	Text	20	Rituxan
Manufacture date	Date/Time		4/7/1998
Expiry date	Date/Time		4/7/2015
Type (s) of Cancer	Text	255	B-cell non-Hodgkin lymphoma and chronic lymphocytic leukemia
Approval of FDA	Text	3	Yes
Composition	Text	255
Price	Currency		$708.17
Quantity	Number		2

Validation rules, texts and other functions have been added from the following table:

Field Name	Validation Rule	Validation text	Input mask
Name	Is Not Null	Please enter name of drug	>L<?????????
Brand name	Is Not Null	Please enter brand name of drug	>L<?????????
Approval of FDA	“Yes” Or “No”	Enter Yes or No only
Dosage (per day)	>=0 And <=10	Enter 0-10 only

Field Name	Display Control	Row Source Type	Row Source
Dosage (per day)	Combo Box	Value list	0;1;2;3;4;5;6;7;8;9;10
Approval of FDA	Combo Box	Value list	Yes;No

Plan for the patient table:

Field Name	Datatype	Width	Example
ID	Number		343242132
First Name	Text	20	Gabriel
Last Name	Text	20	Watson
Gender	Text	1	M
Nationality	Text	20	American
Disease	Text	20	Liver cancer
Preferred drug/therapy	Text	20	Chemotherapy
Contact No.	Text	10	2332424234
Quantity	Number		3
Picture	OLE Object

Validation rules and texts have been added from the following table:

Field Name	Validation Rule	Validation Text	Input mask
First Name	Is Not Null	Please enter name of patient	>L<????????
Last Name	Is Not Null	Please enter last name of patient	>L<????????
Contact Number	Is Not Null	Please enter contact number of patient	>L<?????????
Gender	“M” Or “F”	Enter M or F only
Quantity	>=0 And <=10	Enter 0-10 only

Field Name	Display Control	Row Source Type	Row Source
Gender	Combo Box	Value List	M;F
Quantity	Combo Box	Value List	0;1;2;3;4;5;6;7;8;9;10

Layout of Database:

Form (Design1):

Form (Design 2):

Evaluation between Form Designs 1 and 2:

I prefer design 2 rather than design 1 because:

·          there are more buttons which allows the user to add, delete, duplicate or save records especially close forms.

·         There is an option group which allows the person to select yes or no.

·         This design also gives the picture of that particular drug.

·         There are two combo boxes which allows the user to select which value.

·         An attractive logo.

·         In addition, this design also looks properly organized with the cancer drug information.

Main Menu (Design 1):

Main Menu (Design 2):

Evaluation between Main Menu Designs 1 and 2:

I prefer design 2 rather than design 1 as:

·         Consists of a tab control in which the user could select anyone of the following from several pages.

·         Hyperlinks which can take the user only to tables, queries and reports.

·         Buttons in the page named ‘Forms’ to open the forms.

·         Button ‘Quit application’ which can allow the user to exit the database.

·         Auto dialer allows the user to make phone calls regarding urgent matters.

Patient Details (Design 1):

Patient Details (Design 2):

Evaluation between Patient Details Designs 1 and 2:

I prefer design 1 rather than design 2:

·         There are two combo boxes which allows the user to select his/her gender and the amount of medicines he is taking.

·         There is a list box which lists all the patient ID’s records.

·         Displays the patient’s picture.

·         Has two buttons which allow the user to close form or add records.

Security (Design 1):

Security (Design 2):

Evaluation between Security designs 1 and 2:

I prefer design 1 rather than design 2. There is because there is an encrypted security function which prevents access to people who are trying to take your confidential work.

Flowchart for my database:

Test Plan:

Now that I have made my designs and created my database, I must test the end product and its features. I will do this due to the following:

·         Buttons: Most of buttons must take the user to the required and other buttons must work properly. E.g. Auto dialer which will call anyone by entering a contact number. 

·         Hyperlinks: They have to take the user to the specified area. E.g. The Cancer Drug Information hyperlink must take the user to that table.

·         Tab control: Look at different pages and make sure that all the hyperlinks and buttons are there.

·         Validation Rules and Texts: I will test the validation rules and texts. E.g. If unreasonable data is entered in the gender section in the table, it will display “Enter M or F only”.

·         Security: When I open the database, an encrypted password tab must open.

·         Picture Box: When I open a certain form, the picture of the drug/patient must be displayed.

For the main part of this plan, I will test the validation rules. Here is a table which talks about Gender. I will enter two values and check whether my validation rules and texts are in motion:

Gender (Input Data)	Expected Result	Success or Failure?
M	-	Success
Fail	Enter M or F only	Success