Transcript Access Tutorial 7

Access Tutorial 7
Web Integration
Overview
 Note: We’re 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
Web Integration Overview
1-way arrows!
Custom
Data Access
Page
Wizard
Data Access
Page
Report.htm
Access
Database
File->Save As…
Table.htm
Form
Data Access
Page
Table
Data Access
Page
2-way arrows!
Query.htm
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)
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.
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.
Sample HTML code for template
 Can also have tags for navigation between pages

Check Access Help
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 we’ve done before
Single table only (as far as I can tell)
 Design View
 More difficult
 More flexible
 Can use multiple related tables