Exporting Tables, Queries, Forms and Reports to web pages

-

Objective: Exporting Tables, Queries, Forms and Reports to Web Pages using simplest steps in MS Access

   MS Access allows users to built a powerful integrated platforms of inserting, saving, retrieving the information into the database. There are many platforms for these facilities in MS Access for example Tables, Quires, Forms, Reports, etc.
   In previous posts we have learnt how to create the Tables, Quires, Forms and Reports, etc. But if we want to open the data into another application then it provides  a way to do the same. We can export the table, queries, etc. into another format such as XML, web pages.
   In this tutorial, you will come to know how to export the tables or queries into the web page format which allow you to open the table in web browsers.
  If you don't know how to create the data tables, queries, and reports then please read those articles before it.
We just follow some easy steps to do the same as follow:

Procedure:

1. Open a database table that is created previously or create a new database table.


2. Go to the External Data ribbon and click on More and then click on HTML Document in the Export group.



3. Now Click on browse to specify the destination of the file where you want to save it in your computer.
4. Select the Formatting option for the better look of the table. and click OK.


4. Now select the layout of the table, query form or report whatever you are exporting. For example in case of table select either a HTML Template or choose encoding type of the HTML File. And click OK.


5. A popup window appear showing the message of finishing the exporting and option to save export steps. Simply click on Close.


6. Exporting Finished. Open the destination folder of the HTML file, and open the HTML File in the Web Browsser.

Preview of the table without formatting ( in step 4 ).


 Preview of the table with formatting ( in step 4 ).


6. Similarly follow step 1 to 5 to create HTML file for Queries, Forms and Report databases.


For further queries please contact or comment below.

Comments

Post a Comment

Popular posts from this blog

Exporting Tables, Queries, Forms and Reports to XML pages

-
Image
Objective: Exporting Tables, Queries, Forms and Reports to XML Pages using simplest steps in MS Access     Tables , Quires , Forms and Reports generation in the features supported by the MS Access in order to influence more convenience and beneficial data insertion and retrieving to the database. It is used in many professional, social and professional works and Also in many companies to manipulate the data.    It is important to backup some date  or to export  these data. In today's tutorial you will come to know about how to export the table. queries and reports in the XML format.     If you don't know how to create the data tables, queries, and reports then please read those articles before it. Procedure: 1. Open a database table that is created previously or create a new database table. 2. Go to the External Data ribbon and click on  XML File from the Export group. 3. Now Click on browse to specify the destination of the XML fi...
Read more

Drug information storage and retrieval using MS Access

-
Image
Drug information storage and retrieval using MS Access      The storage, retrieval, and dissemination of information constitutes a major function of any drug information service (DIS). We developed a computerized system for the storage and retrieval of data from drug information requests (DIR) using a MUMPS-based information system. In the past, DIR forms were stored in looseleaf binders and filed chronologically. Due to the success and increased use of our DIS, this manual filing system became inadequate and awkward to use. Our solution was to develop a computer system where data could be entered from DIR forms and retrieved rapidly and easily. Each DIR was reviewed and key data elements were selected for input. The DIS files may now be searched online rapidly and efficiently. The MUMPS-based information system has provided open access for all staff pharmacists, 24 hours a day. The benefits have been an increase in both the quantity and quality of drug information p...
Read more