Create a data access page

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 .
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 (theme: A collection of formats that determines the appearance of the controls, sections, body, and text on a data access page.), Microsoft Access applies it to the page.

The wizard asks you detailed questions about the record sources (record source: The underlying source of data for a form, report, or data access page. In an Access database, it could be a table, query, or SQL statement. In an Access project, it could be a table, view, SQL statement, or stored procedure.), fields, layout, and format you want, and then creates a page based on your answers.

If the wizard doesn't start

1. Under Objects in the Database window, click Pages .
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 (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).

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 (group level: The depth at which a group in a report or data access page is nested inside other groups. Groups are nested when a set of records is grouped by more than one field, expression, or group record source.), 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.

1. Under Objects in the Database window, click Pages .
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.

1. In the Database window (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.), click Pages 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 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 (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).

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.

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.

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.

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.