Integrating Access with the Web and with Other Programs - PowerPoint PPT Presentation

1 / 29
About This Presentation
Title:

Integrating Access with the Web and with Other Programs

Description:

Integrating Access with the Web and with Other Programs Exporting an Access Object to an HTML Document In the Database window, right-click the object you want to ... – PowerPoint PPT presentation

Number of Views:290
Avg rating:3.0/5.0
Slides: 30
Provided by: meya9
Learn more at: https://www5.csudh.edu
Category:

less

Transcript and Presenter's Notes

Title: 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
Write a Comment
User Comments (0)
About PowerShow.com