PRACTICAL FILE
OF
COMPUTER APPLICATION IN
PHARMACY PRACTICAL
B PHARMACY
DEPAREMENT OF PHARMACEUTICAL SCIENCES
GURU JAMBHESHWAR UNIVERSITY OF SCIENCE AND
TECHNOLOGY
Hisar – Haryana (India)
Submitted to: Submitted by:
Ms. Jyoti Anushka
Department of CSE 240121250046
Sr. Experiment Page Signature
No. No.
2-3
1. Design a questionnaire using MS Word
4-6
Create a HTML web page to show
2.
personal information
Retrieve information about a drug and 7
3.
its adverse effects using online tools
Creating mailing labels using Label
4. 8-9
Wizard and generating in MS Word
Create a database in MS Access for 10-11
5.
storing patient information
Design a form in MS Access to view, 12
6.
add, delete and modify patient records
Generate and print a report from patient
7. 13
database
Drug information storage and retrieval 14-15
8.
using MS Access
Experiment 1: Design a Questionnaire Using MS Word
Objective: To design a questionnaire to gather information about asthma.
ASTHMA : HEALTH SURVEY
Section A: Demographic Information
PATIENT INFORMATION
Name of Patient Age
Gender Male/Female/Other Date of Birth
Address
Section B: Diagnosis & Medical Background
1. Have you been diagnosed with asthma?
☐Yes ☐No
If yes, how long ago? _____________________________________years/months
2. What type of asthma do you have (if known)?
☐Allergic ☐Exercise-induced ☐Occupational ☐Other:_________________
3. Do you have a family history of asthma or allergies?
☐Yes ☐No
4. Have you ever been hospitalized for asthma?
☐Yes(how many times?):____________________________ ☐No
5. Do you have any of the following related conditions?
☐Allergic rhinitis ☐Eczema ☐Sinusitis ☐GERD ☐None Section
Section C: Triggers and Symptoms
6. What triggers your asthma symptoms?
☐Dust ☐Pollen ☐Smoke ☐Cold air ☒Exercise ☐Pets ☐Stress
other__________________________________________________________
7. How often do you experience the following symptoms?(Tick frequency: Never/
Occasionally/ Often/ Always)
Wheezing : ☐☐☐☐
Shortness of breath: ☐ ☐ ☐ ☐
Coughing : ☐☐☐☐
2
Chest Tightness : ☐☐☐☐
8. Do your symptoms worsen at night or early morning?
☐Yes ☐No
9. Do you experience symptoms after physical activity?
☐Yes ☐No
Section D: Treatment and Management
10. Are you currently using any asthma medication?
☐Yes ☐No
If yes, list them :_____________________________________________________
11. What type of treatment are you on?
☐Inhaler ☐Nebulizer ☐Oral medications ☐Steroids ☐None
12. How often do you use a reliever inhaler(e.g, salbutamol)?
☐Daily ☐Weekly ☐Rarely ☐Never
13. Do you carry your inhaler at all times?
☐Yes ☐No
14. Do you have an asthma action plan from your doctor?
☐Yes ☐No
Section E: Lifestyle and Knowledge
15. Do you avoid known triggers actively?
☐Yes ☐No
16. Are you aware of emergency steps during an asthma attack?
☐Yes ☐No
17. Have you received education about asthma management?
☐Yes ☐No
18. Rate your asthma control over the past month:
☐Excellent ☐Good ☐Fair ☐Poor
Section F: Additional Comments
19. What difficulties do you face in managing asthma?
3
Experiment 2: Create an HTML Web Page to Show Personal
Information
Objective: To create a basic HTML page displaying student details.
<html>
<head>
<title> Resume </title>
</head>
<body><BODY BGCOLOR="LIGHTYELLOW" TOPMARGIN=100
LEFTMARGIN=60><strong><h1>RESUME</h1></strong>
<h3> Anushka Duhan</h3>
<IMG Src="C:\Users\Hp\Pictures\WhatsApp Image 2025-06-27 at [Link]">
<p align="left"><i> anuduhan0305@[Link]</i><br>
<i><b>7988479577</i></b><br>
<i>Hisar, Haryana, India</i><br>
</p>
<p><h2>CAREER OBJECTIVE</H2>
<FONT FACE="times new roman" SIZE=4 >
<H3> Dedicated and enthusiastic Bachelors of pharmacy student with a strong foundation in
human physiology, biochemistry and healthcare science.
seeking opportunities to enhance practical skills and contribute meaningfully in academic
and healthcare settings.</h3></font></P>
<P><H2>EDUCATIONAL QUALIFICATION</H2>
<TABLE>
<THEAD BGCOLOR="YELLOW">
<TR><TH>QUALIFICATION</TH><TH>INSTITUTION
NAME</TH><TH>BOARD/UNIVERSITY</TH><TH>YEAR</TH></TR></THEAD>
<TBODY BGCOLOR="WHITE">
<TR><TH>[Link](1st year)</TH><TH>Dept. of pharmaceutical
science</TH><TH>GJU</TH><TH>2024-Present</TH></TR>
<TR><TH>12TH(Science stream)</TH><TH>Holy angel
school</TH><TH>CBSE</TH><TH>YEAR</TH></TR>
<TR><TH>10TH</TH><TH>Holy angel
school</TH><TH>CBSE</TH><TH>YEAR</TH></TR></TBODY>
</TABLE>
<P><H2><B>KEY POINTS</B></H2>
<FONT FACE="times new roman" SIZE 6>
<LI>Knowledge of Human Anatomy & Physiology
<li>Basic understanding of biochem
<li>MS Word, Powerpoint, HTML, Python, MySQL
<li>Communication & teamwork
<li>Time management
</font><br>
<P><H2>ACADEMICS PROJECTS/ACTIVITIES</H2>
<LI>Designed a Asthma Awareness Questionnaire for health education.
<li>Developed a simple HTML based hospital prescription format.
4
<li>Actuve participant in class seminars and poster presentation.
</p>
<p><H2>HOBBIES & INTERESTS</H2>
<LI>Reading biology and medical books.
<li>Watching crime webseries.
<li>Drawing & art and craft work.
</p>
<p><h2>PERSONAL DETAILS</H2>
<h3>Date of Birth: 05 March 2005<br>
Gender: Female<br>
Nationality: Indian<br>
Languages known: English , Hindi<br></h3>
</p>
<p><h2>DECLARATION</H2><h3>
I hereby declare that the above information is true and correct to the best of my
knowledge.<br>
Date:(6/25/2025)<br>
Place:(Hisar)<br>
Signature:<IMG Src="C:\Users\Hp\Pictures\WhatsApp Image 2025-06-25 at 15.38.44
(1).jpg">
</h3></p>
</body>
</html>
5
OUTPUT:
6
Experiment 3: Retrieve Information of a Drug and Its Adverse
Effects Using Online Tools
Objective: Use online databases and Websites like [Link] or Medline Plus
to collect drug data.
RETRIEVING DRUG INFORMATION AND
ADVERSE EFFECTS USING ONLINE TOOLS
A Case Study on Paracetamol Using Trusted Medical Databases
Anushka | [Link] |27 June 2025
OBJECTIVE
To explore and utilize trusted online medical databases to retrieve information about a commonly
used drug, including its pharmacological use and potential adverse effects.
DRUG CHOSEN
Paracetamol ( Acetaminophen )
Tools Used and Information Retrieved
TOOL LINK USES ADVERSE
EFFECT
[Link] [Link] General drug info Nausea, liver
including uses, dosage, damage, skin rash
and side effects
MEDLINEPLUS [Link] To get details about drug Liver failure (in
safety and usage. overdose),
allergic reaction
DAILYMED [Link] To access official FDA- Hepatotoxicity,
approved drug labels and skin disorders
clinical information.
WHO [Link] To check global reports Skin,
VIGIACCESS of adverse drug reactions gastrointestinal,
(ADRs). liver problems
7
Experiment 4: Creating Mailing Labels Using Label Wizard in
MS Word
Objective: To generate medicine labels using Label Wizard.
Steps:
1. Open Word → Mailings → Labels → Options → Choose Label type
2. Fill the information about medicine in the address column.
3. Click New Document and Print
8
9
Experiment 5: Create a Database in MS Access to Store Patient
Information
Objective: Create a simple patient database.
Table Fields and Data Type:
Patients table
Doctors table
Visits table
10
11
Experiment 6: Design a Form in MS Access to View, Add, Delete
and Modify Patient Record
Objective: Create a form to manage patient records easily.
Steps:
1. Open your patient database
2. Go to Create → Form Wizard
3. Select fields → Click Finish
12
Experiment 7: Generating Report and Printing from Patient
Database
Objective: Generate a structured report for print.
Steps:
1. Go to Create → Report Wizard
2. Select fields, set layout
3. Click Finish to generate report
13
Experiment 8: Drug Information Storage and Retrieval Using MS
Access
Objective: Build a small drug database.
Fields:
Steps: Create table → Add data → Use search/filter
14
\
15