Data Access Pages: What they are and how to create one - Creating a Data Access Page
(Page 3 of 6 )
There are three options, as there are for the other objects in MS Access. You can create a new one; open an existing one; or open the designer to create one. You also have the fourth option to edit an existing one. Let's create a new one. Click on New at the top of the main window.
This wakes up a wizard to create a new Data Access Page as shown. There are again four methods for creating a Data Access Page. The easiest is the AutoPage option. The Page wizard allows you to select, order and group the data. The Design View goes into more details of the page design using field selection and placement on the DAP surface.
Clicking OK after choosing the Page Wizard and selecting the query created earlier opens up the next wizard, the Page Wizard as shown. In this interface you can choose the fields you want to appear in the DAP. Here three out of four available fields from the Query: qryBostonCrabMeat have been chosen.
Clicking Next to the above brings up this window where you can order the columns either in ascending or descending order. Here some choices have been made as shown.
Clicking Next brings up the window wherein you need to choose a unique table from among the several tables related to each other in the query. Here the Orders table was chosen.
Clicking next brings up the final page of the wizard as shown, where you give a name to the Page. You may add certain other features like choosing to modify or not, adding a theme or not, and so forth. Here defaults are used.
.
Clicking Next to the above brings up this DAP GUI designer where you could make changes to the formatting of the page. A title may also be added at this point as shown.
In addition to the above and along side you would also get a list of database objects, also known as Field List as shown. It shows all the database related objects, tables and queries on the database. You could expand a table and look at the columns and their properties, You could drag and drop fields onto the design pane of the GUI. These details are not considered in the present tutorial.
Now click on the top right of the DAP designer and close the window. The next message asking to save the page shows up.
If you click yes to this you will open up the directory where it is going to be saved, C:/ My Documents by default. This is an absolute path reference. Therefore the following message shows up asking you if this is OK.
If you close the above window, the DAP gets created as shown.
Next: Displayed Data Access Page >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 25 
