The Database Window

When you open a database, the Database window appears (refer to Figure 1.3). The Database window, which appears within the Access desktop window, allows you to select any of the Objects tabs. In Figure 1.3, for example, the Tables tab is selected. In addition to what its parent window, the Access desktop window, contains, the Database window contains its own buttons and objects. Table 1.1 describes these buttons and objects and what they do. The objects are discussed in more detail in the sections that follow.

Table 1.1. The Buttons and Objects in the Database Window




Opens the object you have selected.


Allows you to modify the design of the selected object.


Opens a new object based on the type of object selected.


Lists the tables in the database. Each table contains data about a particular subject.


Lists the queries in the database. Each query is a stored question about data in the database.


Lists the forms in the database. Each form allows you to view, add, edit, and delete data.


Lists the reports for the database. Each report allows you to send table data to the printer or screen in a format that you define.


Lists the data access pages. This allows viewing of and working with data from the Internet or an intranet.


Lists the macros created to automate the way you work with data.


Lists the modules of programming code created for the database.


Allows you to create your own groups of favorite objects that you frequently work with (forms, reports, and so on). An example would be sales reports.

    Part III: Creating Your Own Database and Objects
    Part V: Advanced Topics