Examine what Data Access Pages are and how they are used with Access reports and forms.
What are Data Access Pages?
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.” It’s found in the Northwind.mdb sample database, which is included in Microsoft Access:
Review Products Data Access Page
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.
Task
Mode
Inputting data
Form accepts parameters
-Reviewing data
-Analyzing information
-Making projections
Form accepts the parameters, then the report is based on those parameters
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
file itself.
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 11.0 or Microsoft Edge
All clients must have a licensed copy of Microsoft Office
In the next lesson, you will learn how Data Access Pages can be used.