Data Access Pages (DAP) are probably some of the hottest new features in Access 2000. To really appreciate them, you have to understand what
they are, and where and how you can use them. Generally, Access reports are used to present data and Access forms are used to input data. DAPs
allow you to combine both the input and presentation of data. The versatility of DAPs allows them to be used in an Access database, an
intranet Web site, or both simultaneously.
The figure below shows you an example of a Data Access Page called Review Products. Its found in the Northwind.mdb sample
database, which is included in Microsoft Access:
You can find this Data Access Page by opening Northwind.mdb, and clicking the Pages tab in the Database window.
Check this link if you want to know about the requirements of using Data Access Pages.
Here is a list of what can be accomplished with DAPs, as well as how you would use either forms or reports to perform the same task.
DAPs are actually HTML files, which are linked into the Access database. This is how they can be used both in Access and out of Access,
such as using them with a Web site. The data is bound to the Web page, so the HTML contains the data connection information right in the
DAPs are great for integrating a database into an Intranet Web site. Notice that I said Intranet
, and not Internet
To use Data Access Pages, the following is required:
Internet Explorer 8.0
All clients must have a licensed copy of Microsoft Office
In the next lesson, you will learn how Data Access Pages can be used.