Data access pages: What they are and how they work

A data access page is a special type of Web page that enables you to view and work with data from a database. There are several types of data access pages:

Interactive reporting   This type of data access page is often used to consolidate and group information stored in the database and to publish summaries of the data. 

Data entry   This type of data access page is used to view, add, and edit records, or just add records. 

Data analysis   This type of data access page may include a PivotTable list, similar to a Microsoft Access PivotTable form or Microsoft Excel PivotTable report, that lets you reorganize the data to analyze it in different ways. The page may contain a chart for analyzing trends, patterns, and making comparisons on the data in your database, or a spreadsheet where you can enter and edit data.

A data access page is connected directly to the underlying database. When you display the page in Microsoft Internet Explorer, you're viewing your own copy of the page. So any filtering, sorting, and other changes that you make to how the data is displayed — including changes that you make within a PivotTable list or spreadsheet — affect only your copy of the page. However, changes that you make to the data itself — modifying values, or adding or deleting data — are stored in the underlying database and therefore are available to everyone viewing the page.

Note   Data access pages are supported in Microsoft Internet Explorer 5 or later.

Working with data access pages

The record navigation toolbar let's you quickly move between records or add, delete, save, undo changes to, sort, or filter records. In a grouped data access page, each group might have its own record navigation toolbar located at the bottom of the expanded group. If the toolbar on your page doesn't include some of the buttons displayed in the following art or includes buttons that aren't listed here, it's been customized by the person who designed the page.

Record navigation toolbar

 

Note   For more help on data access pages click the help button on the record navigation toolbar.

How do I turn off Internet Explorer security prompts when I browse data access pages?

Add this site to your trusted sites zone in Internet Explorer. This zone contains sites you trust - sites that you believe you can download or run files from without worrying about damage to your computer or data. 

To assign this site to the trusted zone

1. On the Tools menu in Internet Explorer 5, click Internet Options.
2. Click the Security tab.
3. Click a security zone: Local intranet zone, Trusted sites zone.
4. Click Sites, and then type enter http://pleasureislandrestaurants.net for the Internet address that you want to add to this zone. You may need to clear the checkbox that reads "Requires server verification (https:) for all sites in this zone."