Integrating Access with the Web and with Other Programs

1
Integrating Access with the Web and with Other
Programs
2
Exporting an Access Object to an HTML Document

• In the Database window, right-click the object
  you want to export, and then click Export on the
  shortcut menu.
• Enter the filename in the File name text box, and
  then select the location where you want to save
  the file.
• Click the Save as type list arrow, and then click
  HTML Documents.
• Click the Save formatted check box (if using a
  template), and then click the Export button.
• Select the template (if necessary), and then
  click the OK button.

3
Export Query Dialog Box
4
Viewing an HTML Document in a Web Browser

• If necessary, click View on the menu bar, point
  to Toolbars, and then click Web to display the
  Web toolbar.
• Click the Go button on the Web toolbar, and then
  click Open Hyperlink.
• Use the Browse button to select the file to open,
  and then click the Open button.
• Click the OK button.

5
Access Query in HTML Format
6
Creating a Data Access Page for an Access Table

• A data access page is a dynamic HTML document
  that you can open with a Web browser to view or
  update current data in an Access database.
• Data access pages are stored outside the database
  as separate HTML documents.
• You can create a data access page either in
  Design view or by using a wizard.
• To invoke the Page Wizard, click Pages in the
  Objects bar of the database window, click New,
  click Page Wizard, and finally click the OK
  button.

7
Page Wizard Dialog Box
8
Data Access Page created by the Page Wizard
9
Updating Data in a Data Access Page using
Internet Explorer
You can view a data access page and update its
data using Internet Explorer 5.0 or higher and
Windows 2000 SP3 or higher.
10
Sorting and Filtering Records
11
Creating a Custom Data Access Page

• Click Pages in the Objects bar of the Database
  window.
• Click the New button, click Design View, and then
  click the OK button.
• Place the necessary controls in the Page window
  in Design view.
• Click the Save button on the Page Design toolbar
  and enter an appropriate name.

12
Data Access Page with Fields Added
13
DataPageSize Property
14
The Completed Data Access Page
15
Creating and Using a PivotTable in a Data Access
Page

• When used in a Data Access Page, a PivotTable
  (also called a PivotTable list) is an interactive
  table that lets you analyze data dynamically
  using a Web browser.
• Create a PivotTable by clicking the Office
  PivotTable tool on the toolbox, followed by the
  location on the page where you want to position
  the upper-left corner of the PivotTable.
• Use the fields from the field list to drag and
  drop the filter, row, column, and detail fields.
  Add calculated fields as needed.
• Modify the size of the PivotTable and save the
  page.

16
Completed PivotTable in Page view
17
PivotCharts

• The Office PivotChart Component assists you in
  adding a chart to a data access page, form, or
  datasheet.
• PivotChart components
• PivotChart toolbar
• Plot area
• Data marker
• Data field
• Value axis label
• Gridline
• Category field
• Category access label
• Series field
• Legend
• Filter field

18
Adding a PivotChart to a Data Access Page

• Create a new data access page and click the
  Office Chart tool on the toolbox.
• Click the location on the data access page where
  you want the upper-left corner of the chart to
  appear
• Click the PivotChart control and select the data
  source, data link connection, table or query, and
  char type.
• Close the Commands and Options dialog box and add
  the appropriate fields from the field list.
• Save the data access page.

19
Specifying the Data Source
20
Specifying the Database Connection and Chart Type
21
Completed PivotChart in Internet Explorer
22
Using XML

• XML (Extensible Markup Language) is a programming
  language that is similar in format to HTML, but
  is more customizable and suited to the exchange
  of data between different programs.
• Access can import data from an XML file directly
  into a database table.
• To import an XML file, click File on the menu
  bar, point to Get External Data, then click
  Import.
• Select XML after clicking the Files of type list
  arrow
• Use the Look in list box to select the XML
  documents to import, and click the Import button.

23
Import XML Dialog Box
24
Imported table in Datasheet View
25
Exporting an Access Table as an XML File

• In the Database window, right-click the object
  you want to export, and then click Export on the
  shortcut menu.
• Enter the filename in the File name text box, and
  then select the location where you want to save
  the file.
• Click the Save as type list arrow, click XML, and
  then click the Export button.
• Click the Advanced button on the Export XML
  dialog box set the data, schema, and
  presentation options and then click the OK
  button.

26
Data tab of the XML Dialog Box
27
Schema tab of the Export XML dialog box
28
Exporting an Access Query as an Excel Worksheet

• In the Database window, click the object you want
  to export and select it.
• Click the OfficeLinks list arrow, and then click
  Analyze It with Microsoft Excel.

29
Query Results in the Excel Worksheet