Data Access Pages: What they are and how to create one - Creating objects to be converted to DAP

(Page 2 of 6 )

Open a new MDB file, DAP.mdb and bring in some data by importing from the Northwind database as shown. The Customers, Order details, Orders and Products tables were imported into this test setup as shown. The left side of the main page shows all the objects that are available. Presently you have only the tables you imported.

 

We first created a query, qryBostonCrabMeat, and then generated from it a form frmBostonCrabMeat, and a report rptBostonCrabMeat as shown in the next three pictures. It is assumed that the reader has reviewed previous MS Access articles on this site so that how to create these objects is completely understood.

qryBostonCrabMeat

 

frmBostonCrabMeat

 

rptBostonCrabMeat

 

 

Next: Creating a Data Access Page >>
 

More Microsoft Access Articles
More By Jayaram Krishnaswamy

Comments On: Data Access Pages: What they are and how to create one

· If you want to display data quick and easy to the intranet with Microsoft products...    · I read much about the DAP pages, I can create them, design them, but I cannot find a...    · Is this from your site on a service provider? Do they have support for MS Access...    · Sorry Brett:I think you already gave me the information I needed. Try this,...    · Brett,I'm trying to find out how to include the following capability on a...    · Bob, I'm needing to do the exact same thing with a free form search field to return...    · I have not tried this, but when I have some spare time I will. Try to implement a...    · I think parametric queries are the ones you are looking for. If this is not the...   >>> Post your comment now!