• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Designing Data Access Pages > Using AutoPage to Create Columnar DAP

Using AutoPage to Create Columnar DAP

Access 2000's AutoPage feature generates a simple DAP from tables or queries. If all you need is a simple page that displays one record at a time, AutoPage is the fastest approach. To test the AutoPage feature, do the following:

  1. Click the Database window's Pages shortcut, if necessary, and click the New button to open the New Data Access Page dialog.

  2. Select AutoPage: Columnar in the list and a table or query in the dropdown list. This example uses the Quarterly Orders by Product query (see Figure 18.26).

    Figure 18.26. Selecting the AutoPage option and the query on which to base the page.

  3. Click OK to generate the page. After a second or two, depending on the speed of your PC, the page opens in Page view (see Figure 18.27). If you specified a default theme when testing the Page Wizard, the default theme is applied automatically to your page.

    Figure 18.27. The Quarterly Orders by Product page in Page view.

    Note

    The Quarterly Orders by Product page is read-only because its underlying summary query is read-only. All Jet queries that return aggregate values, such as crosstabs, are read-only.


  4. Choose File, Save and save the page as QuarterlyOrdersByProduct.htm in your working folder.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint