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:
- Open
the Employees database. - Click
the Pages object in the database window. - Click
New and then select Page Wizard. - Select
the Employees table on which to base the object data and click OK. - Select
the fields that you want displayed online and click Next. - Click Next twice.
- Enter
a title for the page, select Open The Page, and
click Finish. The new data page is displayed. - Close
and Save the Data Access page to a folder that you (and your managers) can
access online.
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.