Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
Data Access pages provide an online viewer that lets you
display and edit Access databases over the Internet. It’s possible to create a
form-type data access page for a single table or query using the Page Wizard.
For example, say your managers need to be able to access
their employees’ addresses, phone numbers, and e-mail addresses online. They
can do just that if you create a form-type Data Access page. Here’s how:
the Employees database.
the Pages object in the database window.
New and then select Page Wizard.
the Employees table on which to base the object data and click OK.
the fields that you want displayed online and click Next.
- Click Next twice.
a title for the page, select Open The Page, and
click Finish. The new data page is displayed.
and Save the Data Access page to a folder that you (and your managers) can
After the Data Page is saved, Access places a shortcut to it
in the database window. The actual Data Page exists as an HTML file separate
from the Access database to which it is connected.