Access to PDF
Are you looking to convert your Microsoft Access Tables into PDF document?
In this tutorial, we will walk you through the steps in exporting the Access tables to a browsable PDF document.
Launch Access Dashboard Designer and click on the connect button
In the Driver, pick “MS Access .mdf.. “
Click on the “Access/Excel File” and pick the access .mdb file
Click on “Connect”
Click on the “New Blank Dashboard”
Give any descriptive name to the Dashboard
Next, it will show the Query browser and list all the available MS Access tables
Double click on any Table that you wish to export to PDF
Next, click on the alias field to select all the columns (you may select individual columns)
Click on the “Create Table” button
Click on the “Tree Browser icon” in the toolbar
Right click on the node name of the table,
Select ‘Export to PDF’
You may select “Queried Rows” or “All Rows” to PDF
Queried Rows: Will export whatever you have already queried in the dashboard. This means if you have put a restriction in the Qlet to pull only 100 records then it will export only 100 rows to PDF
All Rows: This will re-query the database and export all rows in the table to PDF
Here is the PDF output
You can output multiple tables in the same pdf
Goto Menu Create >> Query Builder
Click on the Reset Button
Now double click and bring any other tables you may need. Keep repeating the process until you have added all the tables on the dashboard.
Once added, rename the Qlet name by editing its properties (Hint: Right click on the “Name” title and select Edit)
Right click on Each node in the tree browser and select to include in the report
Now right click on the “Access Dashboard” node to export all the TAbles to PDF
This is the PDF output with the table names as bookmarks
Changing Colors, Formatting Data
With Access dashboard Designer, you get full control over the formatting options on each individual tables
Right click on the table name and select “Edit”
http://www.infocaptor.com/user_help/qlet_properties.htm
