May 30, 2024

Generating report and printing the report from the patient database

SOAP Notes for various disease conditions

Generating report and printing the report from the patient database

BP210P Computer Applications in Pharmacy Practical


Aim

Generating report and printing the report from the patient database


Reports can be created on a table or a query. Reports are an effective way for presenting data. We can create a report to get the printed view of data. Reports give a complete control to decide design and layout of the printed data.

Using reports we can organize and present data in groups. We can also calculate subtotal, grand total and percentage of totals using report. Various methods to create a report are auto report, report wizard and design view. In MS Access reports can be created by using report design or by report wizard.


Creating report by using report wizard

Step 1: Select ‘report wizard’ option from ribbon. This brings step 1 of report wizard

Step 2: In step 1 of report wizard, select the table or query for which the report is to be created. Also select all the fields, which are to be appeared on the report. Then click on next button

Step 3: In step 2 of report wizard, you can add grouping level. In this case if you do not want any grouping level; so simply click on next button

Step 4: In step 3 of report wizard you can specify the sorting order of report. Select the fields, which are to be sorted. Then click on next button

Step 5: Next step is to specify layout of the report. Select layout and set the page orientation. Click on next button

Step 6: In next step, select the style of report and click next.

Step 7: Finally give name to the report and click finish button.

8: The report is generated as shown below. Once the report is displayed; it can be viewed, printed or transferred into Microsoft word or excel.

Step 9: Click on Print button to get print of Report.


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-IF Y B Pharm Sem-II
BP101T Human Anatomy and Physiology I TheoryBP201T Human Anatomy and Physiology II – Theory
BP102T Pharmaceutical Analysis I TheoryBP202T Pharmaceutical Organic Chemistry I Theory
BP103T Pharmaceutics I TheoryBP203T Biochemistry – Theory
BP104T Pharmaceutical Inorganic Chemistry TheoryBP204T Pathophysiology – Theory
BP105T Communication skills TheoryBP205T Computer Applications in Pharmacy Theory
BP106RBT Remedial BiologyBP206T Environmental sciences – Theory
BP106RMT Remedial Mathematics TheoryBP207P Human Anatomy and Physiology II Practical
BP107P Human Anatomy and Physiology PracticalBP208P Pharmaceutical Organic Chemistry I Practical
BP108P Pharmaceutical Analysis I PracticalBP209P Biochemistry Practical
BP109P Pharmaceutics I PracticalBP210P Computer Applications in Pharmacy Practical
BP110P Pharmaceutical Inorganic Chemistry Practical
BP111P Communication skills Practical
BP112RBP Remedial Biology Practical

Suggested readings