Microsoft Office Tutorials and References
In Depth Information
a table, or to save datasheet format changes. Access does not have a button or option you
can use to save the active database. Similarly, you cannot use the Save As option on the
File menu to save the active database file with a new name, as you can with other Office
Access saves changes to the active database to your disk automatically, when a record
is changed or added and when you close the database. If your database is stored on a
removable disk, such as a floppy disk, you should never remove the disk while the data-
base file is open. If you remove the disk, Access will encounter problems when it tries to
save the database, which might damage the database.
You’re done working with the Employer table for now, so you can close it.
To close the Employer table:
1. Click the Close button
on the Employer Table window to close the table. You return to
the Database window.
Now that you’ve become familiar with database concepts and Access, opened the
Seasonal database that Elsa created, and navigated an Access table, Elsa wants you to
work with the data stored in the Seasonal database and to create database objects includ-
ing a query, form, and report. You will complete these tasks in Session 1.2.
Session 1.1 Quick Check
1. A(n) is a single characteristic of a person, place, object, event, or idea.
2. You connect the records in two separate tables through a(n)
appears in both tables.
, whose values uniquely identify each record in a table, is
when it is placed in a second table to form a relation-
ship between the two tables.
4. In a table, the rows are also called
, and the columns are also called
To reinforce the tasks you
learned in this session, go
to the SAM 2003 Training
Companion CD included
with this text.
5. The identifies the selected record in an Access table.
6. Describe two methods for navigating a table.
7. Explain how the saving process in Access is different from saving in other Office
Working with Queries
A query is a question you ask about the data stored in a database. In response to a query,
Access displays the specific records and fields that answer your question. When you cre-
ate a query, you tell Access which fields you need and what criteria Access should use to
select the records. Then Access displays only the information you want, so you don’t
have to navigate through the entire database for the information. In the Seasonal data-
base, for example, Elsa might create a query to display only those records for employers
located in Boston.
Before creating a new query, you will open a query that Elsa created recently so that
she could view information in the Employer table in a different way.
For hands-on practice of
key tasks in this session,
go to the SAM 2003
Training Companion CD
included with this text.