Microsoft Office Tutorials and References
In Depth Information
The Database window provides a variety of options for viewing and manipulating data-
base objects. Each item in the Objects bar controls one of the major object groups—such
as tables, queries, forms, and reports—in an Access database. The Groups bar allows you
to organize different types of database objects into groups, with shortcuts to those objects,
so that you can work with them more easily. The Database window also provides buttons
for quickly creating, opening, and managing objects, as well as shortcut options for some
of these tasks.
Recall that Elsa has already created the Employer and NAICS tables in the Seasonal
database. She asks you to open the Employer table and view its contents.
Opening an Access Table
As noted earlier, tables contain all the data in a database. Tables are the fundamental objects
for your work in Access. To view, add, change, or delete data in a table, you first open the
table. You can open any Access object by using the Open button in the Database window.
Opening an Access Object
In the Objects bar of the Database window, click the type of object you want to open.
If necessary, scroll the object list box until the object name appears, and then click the
Click the Open button in the Database window.
You need to open the Employer table, which is one of two tables in the Seasonal database.
To open the Employer table:
1. In the Database window, click Employer to select it (if necessary).
2. Click the Open button in the Database window. The Employer table opens in Datasheet
view on top of the Database and Access windows. See Figure 1-6.