Create a data access page

Microsoft Office Access 2003

previous page next page

ShowCreate a data access page that contains all fields from a single record source (AutoPage)

Use the AutoPage command to create a data access page that contains all records and fields (except fields that store pictures) in the underlying table, query, or view.

  1. Under Objects in the Database window, click Pages Button image.

  2. On the Database window toolbar, click New.

  3. In the New Data Access Page dialog box, click AutoPage: Columnar.

  4. Click the table, query, or view that contains the data on which you want to base your page.

  5. Click OK.

    In the finished data access page, each field will appear on a separate line with a label to its left. If the resulting page doesn't look the way you want, you can modify the page in Design view.

Note  If you have set a default theme, Microsoft Access applies it to the page.

ShowCreate a data access page that contains fields from multiple tables and queries (Page Wizard)

The wizard asks you detailed questions about the record sources, fields, layout, and format you want, and then creates a page based on your answers.

  1. Under Objects in the Database window, click Pages Button image.

  2. On the Database window toolbar, click New.

  3. In the New Data Access Page dialog box, click Page Wizard.

  4. Click the name of the table, query, or view that includes the data on which you want to base your data access page.

    Note  You don't need to do this step now— you can specify the record sources for the page in the wizard.

  5. Click OK.

  6. Follow the directions in the wizard dialog box.

    If the resulting page doesn't look the way you want, you can modify the page in Design view.

Notes

  • If you want to include fields from multiple tables and queries in your page, don't click Next or Finish after selecting the fields from the first table or query in the Page Wizard. Repeat the steps to select a table or query, and then choose fields that you want to include in the page, until you have selected all the required fields.

  • If you include fields from multiple tables or queries but don't create group levels, fields from one of the underlying tables can support updates in Page view or in Microsoft Internet Explorer. The wizard will list the record sources of the page and prompt you to specify the updatable record source.

ShowCreate a data access page in Design view

  1. Under Objects in the Database window, click Pages Button image.

  2. On the Database window toolbar, click New.

  3. In the New Data Access Page dialog box, click Design View.

  4. Click the name of the table, query, or view that includes the data on which you want to base your data access page.

    Note  If you want to create a blank page, don't select a record source in this dialog box.

  5. Click OK.

Microsoft Access displays the data access page in Design view, where you can modify the page. To add data to the page, drag fields from the field list to the page.

ShowMake an existing Web page into a data access page

  1. In the Database window, click Pages Button image under Objects.

  2. Click the New button on the Database window toolbar.

  3. In the New Data Access Page dialog box, click Existing Web page.

  4. Click OK.

  5. In the Locate Web Page dialog box, find the Web page or HTML file that you want to open.

    Note  You can find a Web page by clicking Search the Web Button image in the Locate Web Page dialog box. Save a copy of the page by using the Save As command on the File menu in Microsoft Internet Explorer, and then start this procedure again to open the page in Design view.

  6. Click Open.

Microsoft Access creates a shortcut to the HTML file in the Database window and displays the page in Design view, where you can modify the page.

Note  If you have specified a default connection file for the database in the Pages tab of the Options dialog box, Access will automatically set the ConnectionFile and ConnectionString properties for all new pages.

ShowCreate a stand-alone data access page

  1. If a database is open in Microsoft Access, close it.

  2. On the File menu, click New.

  3. In the New File dialog box, click Blank Data Access Page.

  4. In the Select Data Source dialog box, do one of the following:

    ShowConnect the page to a Microsoft Access database

    Use the following procedure if you want to create a page and bind it to an Access database, without creating a shortcut in the database.

    1. In the Files of Type list, select Access databases.

    2. Double-click the database file that you want to bind the page to. If you don't see the database that you want to use, navigate to the folder that has the file, and then double-click the file name.

    3. Click OK twice.

      Access will create a blank page and open it in Design view. The page's ConnectionString property will be set to connect the page to the database you selected. To add data to the page, drag fields from the field list to the page.

    ShowConnect the page to a SQL Server database or an OLE DB data source by creating a connection file

    1. Click New Source.

    2. In the Data Connection Wizard dialog box, select the data source that you want to connect to.

    3. Follow the directions in the wizard dialog box.
    4. In the Select Data Source dialog box, click the connection file that you created in the previous step.

    5. Do one of the following:

      • To use the connection information without creating a link between the page and the connection file, click Open.

        Access will create a blank page and open it in Design view. The page's ConnectionString property will be set based on the contents of the connection file you created. To add data to the page, drag fields from the field list to the page.

      • To create a link between the page and the connection file, click the arrow on the Open button, and then click Use Connection File.

        Access will create a blank page and open it in Design view. The page's ConnectionString property will be set based on the contents of the connection file, and the ConnectionFile property will be set to the connection file that you created. To add data to the page, drag fields from the field list to the page.

    ShowConnect the page to a data source using an existing connection file

    1. In the Files of Type list, select Office Database Connections.

    2. Click the connection file that has the connection information that you want to use for the page. If you don't see the connection file that you want to use, navigate to the folder that has the file, and then click the file name.

    3. Do one of the following:

      • To use the connection information without creating a link between the page and the connection file, click Open.

        Access will create a blank page and open it in Design view. The page's ConnectionString property will be set based on the contents of the connection file you selected. To add data to the page, drag fields from the field list to the page.

      • To create a link between the page and the connection file, click Use Connection File.

        Access will create a blank page and open it in Design view. The page's ConnectionString property will be set based on the contents of the connection file, and the ConnectionFile property will be set to the connection file that you selected. To add data to the page, drag fields from the field list to the page.

previous page start next page