Creating Data Access Pages from Scratch - Choosing the data
(Page 3 of 5 )
From here it is possible to drag and drop the table from the field list to the design pane of the page as shown for the Authors table. If you wish to bring only some of the fields you may highlight the fields you want and drag them in a bunch to the design page. This action brings up the window to craft a layout of the table. For this tutorial, a tabular one is chosen as shown (columnar is the default).
Clicking OK will bring the table columns, with the column headings to the page as shown in a tabular format. To visualize it better, some of the fields have been left out of the picture. If the table occupies a region wider than the default Page1's width, the page width automatically widens to accommodate all the fields. Here you can click on individual items (for example, field captions) and change them to something meaningful, say au_id to Author ID. You may remove items to retain only those you want, and so on. There is a great deal of flexibility in rearranging data in the design view.
At this point you can save the page and take a look at how it would look in a preview, but you will have to save the page. When you use the menu item File -->Save As you will be required to give a name to the page or, take the default - Page1. Assuming that you choose to save as PageDapTest1, it gets saved to the default directory, My Documents. This page1 also gets added to the Pages tab in the Microsoft Access UI as shown.
If you double click the item Page2, we can see how it may appear on a web page as shown here. This display is still within the Access application.
Next: Modifying Page Properties >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 21 
