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