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.