Open a database object

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 Tables under Objects.
2. Click the table you want to open.
3. Do one of the following:

To open the table 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.), click Design on the Database window toolbar.

To open the table in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.), click Open on the Database window toolbar.

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 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 (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.), click Design on the Database window toolbar.

To open the form in Form view, (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this 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 (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 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 (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.), click Design on the Database window toolbar.

To open the report in Print Preview (print preview: A view of a document as it will appear when you print it.), click Preview on the Database window toolbar.

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 Queries under Objects.
2. Click the query you want to open.
3. Do one of the following:

To open the query 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.), click Design on the Database window toolbar.

To open the query in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.), 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 (SQL view: An object tab that displays the SQL statement for the current query or that is used to create an SQL-specific query (union, pass-through, or data definition). When you create a query in Design view, the SQL equivalent is constructed 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 (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.), you must have Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later on your computer.

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 data access page you want to open.
3. Do one of the following:

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.), click Design on the Database window toolbar.

To open the page in Page view (Page view: An Access window in which you can browse the contents of a data access page. Pages have the same functionality in Page view as in Microsoft Internet Explorer 5.0 or later.), 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 (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 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 (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 Modules under Objects.
2. Do one of the following:

To open a new standard module (standard module: A Visual Basic for Applications (VBA) module in which you can place Sub and Function procedures that you want to be available to other procedures throughout your database.), 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 (form module: A module that includes Visual Basic for Applications (VBA) code for all event procedures triggered by events occurring on a specific form or its controls.) or report module (report module: A module that includes Visual Basic for Applications (VBA) code for all event procedures triggered by events occurring on a specific report or its controls.), open the form or report 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.), and then click Code on the toolbar.

To open a new class module (class module: A module that can contain the definition for a new object. When you create a new instance of a class, you create the new object. Procedures defined in the module become the properties and methods of the object.) that isn't associated with a form or report, click Class Module on the Insert menu.