Creating and working with queries in MS Access

Creating and working with queries in MS Access

BP210P Computer Applications in Pharmacy Practical

---

Aim

Creating and working with queries in MS Access

---

Construction of query can be accomplished by using

• Query wizard
• Query design view

---

Construction of query using query wizard

Steps to create the query using query wizard

1: Open Microsoft access 2007 database

2: Select ‘create’ tab on ribbon.

3: Click on ‘Query Wizard’ option. A ‘New Query’ dialog box will be displayed.

Step 4: Select ‘Simple Query Wizard’ and click ok button. Simple Query Wizard dialog box will be displayed as shown below

Step 5: In simple Query Wizard dialog box, select the table you want to use for query. Also select the fields for query. Then click next button

Step 6: Assign title for the query and click on finish button. The query is as given below

---

Construction of Query using Design view

Following steps are required to create the query using design view.

Step 1: Select ‘create tab’ on ribbon

Step 2: Click on ‘Query Design’ option. This brings a ‘Shown Table’ dialog box with Query in

design view in background.

Step 3: Select the table for the query and click add, and then click close. The selected tables appear in the Query dialog box.

Step 4: Select the fields for the query from the selected table: you can perform calculation on these input fields. You can also apply various the options on query such as sort, show, criteria, etc. the output of the query is displayed as given below.

Step 5: After giving all the required conditions, save the query.

---

BP210P Computer Applications in Pharmacy Practical

1. Design a questionnaire using a word processing package to gather information about a particular disease.
2. Create an HTML web page to show personal information.
3. Retrieve the information of a drug and its adverse effects using online tools
4. Creating mailing labels Using Label Wizard, generating labels in MS WORD
5. Create a database in MS Access to store the patient information with the required fields Using access
6. Design a form in MS Access to view, add, delete and modify the patient record in the database
7. Generating report and printing the report from the patient database
8. Creating invoice table using MS Access
9. Drug information storage and retrieval using MS Access
10. Creating and working with queries in MS Access
11. Exporting Tables, Queries, Forms and Reports to web pages
12. Exporting Tables, Queries, Forms and Reports to XML pages

---

First Year B Pharm Notes, Syllabus, Books, PDF Subjectwise/Topicwise

F Y B Pharm Sem-I	F Y B Pharm Sem-II
BP101T Human Anatomy and Physiology I Theory	BP201T Human Anatomy and Physiology II – Theory
BP102T Pharmaceutical Analysis I Theory	BP202T Pharmaceutical Organic Chemistry I Theory
BP103T Pharmaceutics I Theory	BP203T Biochemistry – Theory
BP104T Pharmaceutical Inorganic Chemistry Theory	BP204T Pathophysiology – Theory
BP105T Communication skills Theory	BP205T Computer Applications in Pharmacy Theory
BP106RBT Remedial Biology	BP206T Environmental sciences – Theory
BP106RMT Remedial Mathematics Theory	BP207P Human Anatomy and Physiology II Practical
BP107P Human Anatomy and Physiology Practical	BP208P Pharmaceutical Organic Chemistry I Practical
BP108P Pharmaceutical Analysis I Practical	BP209P Biochemistry Practical
BP109P Pharmaceutics I Practical	BP210P Computer Applications in Pharmacy Practical
BP110P Pharmaceutical Inorganic Chemistry Practical
BP111P Communication skills Practical
BP112RBP Remedial Biology Practical

---

Suggested readings

• Generating report and printing the report from the patient database
• Create a database in MS Access to store the patient information
• Design a form in MS Access to view, add, delete and modify the patient record in the database
• BP210P Computer Applications in Pharmacy Practical
• Materials of construction Pharmaceutical engineering MCQ with answers
• BIOSTATISTICS AND RESEARCH METHODOLOGY Theory