Microsoft Office Tutorials and References
In Depth Information
Chapter 17: Adding, Finding, and Querying Data
Adding, Finding, and Querying Data
Access adds the new record.
Access moves your cursor to the
first cell in the next row.
7 Repeat Steps to to add more 6
records to the table.
Access adds your records.
You can resize a column by
dragging the column border left
You can use the scroll bars to
view different portions of the
How do I edit a
record in a
To edit a record in
a table, open the
table in Datasheet
view, click in the
cell whose data
you want to
change, double-click the data to select
it, and type over the data to replace it.
What is a primary key?
A primary key uniquely identifies each
record in a table. For many tables, the
primary key is the ID field, which stores
a unique number for each record as it
is entered into the database. You can
also designate another field (or even
multiple fields) as a primary key. To do
so, switch the table to Design view,
select the field that you want to set as the primary key, and
click the Primary key button on the Design tab.