May 20, 2024

Exporting Tables, Queries, Forms and Reports to XML pages

This is a computer-assisted learning package containing various programs which simulate animal experiments in Pharmacology.

Exporting Tables, Queries, Forms and Reports to XML pages

BP210P Computer Applications in Pharmacy Practical

Aim

Exporting Tables, Queries, Forms and Reports to XML pages


Data export

Data export is actually the opposite of importing data. In importing data, we bring data from other formats in Access, while in exporting we save the data in other formats.

To understand what kind of data you can export from Access data, let us open your database and go to the External Data tab.

In the Export group, you can see the different kind of options available for data export from Access. Following are the most commonly used data export formats-

  • Microsoft Office Excel
  • Microsoft Office Access
  • ODBC Databases (for example, SQL Server)
  • Text files (delimited or fixed-width)
  • XML Files

Example

Let us look at a simple example of data export from Access. Open your database where you want to export the data from. In the Navigation Pane, select the object that you want to export the data from.

You can export the data from table, query, form and report objects etc. Let us select the Patient information query from all Projects and then, go to the External Data tab.

On the External Data tab, click on the type of data that you want to export it. For example, to export data in a XML format. The dialog box as shown below will appear

Then select the information that will be exported.

Access starts the Export wizard. In the Wizard, you can set the information such as the destination file name and format, whether to include formatting and the layout, which records to export. Once you are done with the required information, click OK.

On this screen of the wizard, Access usually asks you if you want to save the details of the export operation. If you think you will need to perform the same operation on a recurring basis, select the Save export steps check box and close the dialog box

Similarly, you can explore exporting of tablet, forms and reports options as well.


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

Recommended readings: