Allowing Others to Analyze Data On the Web To convert a report to a set of static Web pages
On the Objects bar, click Reports, and double-click the report you want to convert.
On the File menu, click Export to display the Export dialog box.
Navigate to the folder where you want to save the Web pages, in the File name box, type a name for the pages, in the Save as type box, click HTML Documents, select the Autostart check box, and then click Export.
In the HTML Output Options dialog box, make sure the Select a HTML Template check box is cleared, and then click OK.
If you don’t see the HTML page, click the file name on the taskbar to display it. Click the Next hyperlink to scroll through the pages of the file.
Creating a Data Access Page with AutoPage To create a data access page with AutoPage
With the database open, on the Objects bar, click Pages.
On the database window’s toolbar, click the New button to display the New Data Access Page dialog box.
Click the AutoPage option you want, display the list of tables and queries, click the table or query you want, and then click OK.
Click the Save button on the toolbar to save your new page.
In the Save As Data Access Page dialog box, navigate to the folder where you want to store the file, give the file a name, and click Save.
If Access warns you that the connection string for this page uses an absolute page, click OK to dismiss the message. (A UNC path is appropriate if you are using a file on a network computer.)
Creating a Data Access Page Using the Page Wizard To create a data access page with the Page Wizard
With the database open, on the Objects bar, click Pages.
At the top of the database window, click the New button.
In the New Data Access Page dialog box, click Page Wizard. In the list of tables and queries, click the table on which you want to base the data access page, and then click OK.
Click the ≫ button to move fields from the Available Fields list to the Selected Fields list, and then click Next.
Double-click CategoryName, and then click Next.
In the first sort box, click ProductName, and click Next.
Select the Do you want to apply a theme to your page check box, and click Finish.
Allowing Others to Analyze Data On the Web To create a data access page by hand
With the database open, on the Objects bar, click Pages.
Double-click Create data access page in Design view to open a blank data access page.
Allowing Others to Analyze Data On the Web To add a PivotTable to a data access page
Open the data access page that you want to add a PivotTable to in Design view.
If the Field List is not displayed, click the Field List button on the toolbar.
Make sure the Toolbox is open, click the Office PivotTable tool, and then click a blank section of the upper-left corner on the page.
Click in the PivotTable, and then double-click its frame to open the Properties dialog box.
Click the Other tab, click the DataMember property, select the table or query on which the PivotTable will be based from the list, and close the Properties dialog box.
In the Field List, select the same table or query.
Drag a field from the Field List to the horizontal box labeled Drop Filter Fields Here.
Drag a field to the vertical box labeled Drop Row Fields Here.
Drag a field to the horizontal box labeled Drop Column Fields Here.
Drag a field to the box labeled Drop Totals or Detail Fields Here.
Click the View button to switch to Page view, and experiment with the PivotTable to make sure it works.
Save the page.