Open a database object

1. In the Database window, click Tables under Objects.
2. Click the table you want to open.
3. Do one of the following:

   To open the table in Design view, click Design on the Database window toolbar.

   To open the table in Datasheet view, click Open on the Database window toolbar.

1. In the Database window, click Forms under Objects.
2. Click the form or subform you want to open.
3. Do one of the following:

   To open the form in Design view, click Design on the Database window toolbar.

   To open the form in Form view, click Open on the Database window toolbar.

Note  If the main form is open in Design view, and you want to open a subform in a separate window, select the subform, and click Subform in New Window on the View menu. The subform control in the main form will turn white and display the name of the subform. You must save changes to the main form and subform individually.

1. In the Database window, click Reports under Objects.
2. Click the report or subreport you want to open.
3. Do one of the following:

   To open the report in Design view, click Design on the Database window toolbar.

   To open the report in Print Preview, click Preview on the Database window toolbar.

1. In the Database window, click Queries under Objects.
2. Click the query you want to open.
3. Do one of the following:

   To open the query in Design view, click Design on the Database window toolbar.

   To open the query in Datasheet view, click Open on the Database window toolbar.

Notes

• When you open a select or crosstab query in Datasheet view, you are actually executing the query.
• If you previously saved a query while it was open in SQL view, Microsoft Access opens the query in SQL view the next time you click Design on the Database window toolbar for that query.

To open a data access page, you must have Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later on your computer.

1. In the Database window, click Pages under Objects.
2. Click the data access page you want to open.
3. Do one of the following:

   To open the page in Design view, click Design on the Database window toolbar.

   To open the page in Page view, click Open on the Database window toolbar.

   To open the page in Internet Explorer, do one of the following:

   • Open the page in Design view or Page view, and then click Web Page Preview on the File menu.
   • If Internet Explorer is your default Web browser, in Windows Explorer, double-click the HTML file to open the page in Internet Explorer.

Note  You can also open a page in Page view by clicking Open on the File menu in Microsoft Access. Access opens the page without opening the database that the page is connected to, so wizards, builders, and add-ins are not available.

1. In the Database window, click Macros under Objects.
2. Click the name of the macro you want to open.
3. Click Design on the Database window toolbar.

1. In the Database window, click Modules under Objects.
2. Do one of the following:

   To open a new standard module, and then click the New button on the Database window toolbar.

   To open an existing standard or class module, select the module you want to open, and then click Design on the Database window toolbar.

   To open a form module or report module, open the form or report in Design view, and then click Code on the toolbar.

   To open a new class module that isn't associated with a form or report, click Class Module on the Insert menu.