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
- 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
First Year B Pharm Notes, Syllabus, Books, PDF Subjectwise/Topicwise
Suggested readings
Recommended readings:
