Access Tutorial 7

1
Access Tutorial 7

• Web Integration

2
Overview

• Note Were only doing Session 7.1 (page AC 7.1 -
  7.24) and Session 8.1 and 8.2
• Hand-in for lab 7
• Tutorial 7, step 1-5
• Tutorial 8, step 1-7
• No internet assignment
• Tables, queries and results can be exported to
  HTML (read-only)
• Data Access Pages
• Dynamic HTML documents linked to the database
• Allows for interacting (incl. updating) data over
  the web
• Caveats
• Only works with Internet Explorer
• Security may be an issue

3
Web Integration Overview
Report.htm
Custom Data Access Page
1-way arrows!
Access Database
Wizard Data Access Page
Table.htm
File-gtSave As
Form Data Access Page
Query.htm
Table Data Access Page
2-way arrows!
4
Static or Dynamic

• Static web page
• Displays the table or query data exactly as it
  was when the page was created
• Read-only
• Dynamic web page
• Live data that can be manipulated right in the
  Web page
• Can interact through browser (only IE)

5
The Export dialog box
This figure shows the Export Dialog box in which
the table, NSJI-tbl is being exported as an HTML
document.
Be sure to click the Save Formatted option. This
is necessary to include field names, such as
column headings.
Note that the Save As Type list box has been
changed to HTML document.
6
Set export options
If you have a pre-defined template to use for
your Web page, you can select it in the HTML
Output Options dialog box. Otherwise, you can
specify data encoding options.
7
Sample HTML code for template

• Can also have tags for navigation between pages
• Check Access Help

8
Wizard to create a data access page

• Access provides a Wizard that helps you create a
  data access page.
• A data access page is an HTML document that can
  be viewed in a Web browser and contains data from
  a table or query.
• Page Wizard
• Just like weve done before
• Single table only (as far as I can tell)
• Design View
• More difficult
• More flexible
• Can use multiple related tables