Microsoft Office Tutorials and References
In Depth Information
Working with Records
Creating an Access Database
3. Make sure the cursor is blinking in the field
you want to enter and type the data for the
Viewing in the Datasheet
In Datasheet View, you'll see many records on a
single sheet, similar to an Excel spreadsheet. Use
your horizontal scroll bars to scroll right or left and
see additional fields, or use the vertical scroll bar to
view additional records. You won’t see a vertical
scroll bar if your database doesn’t have more
records than the screen can show and you won’t
see a horizontal scroll bar if your database doesn’t
have more fields than the screen can show. In
Figure 18-19, you see only a horizontal scroll bar.
Press the Tab key to move to the next field
and enter its data. See Figure 18-18. Just like
entering data in Datasheet View, you can press
Shift+Tab to move back to the previous field.
Entering records in Form View.
Viewing records in Datasheet View.
5. When you have entered all the field
information you want for that record, press the Tab
key. Access automatically takes you to a new
You can easily edit any field in Datasheet View. Just
drag across and highlight the existing information,
type the change, and press Enter.
Once you have your records entered, you'll want to
be able to look at them. Access gives you two
distinct views to use when viewing records: Form
View and Datasheet View.
To assist you in navigating through your records,
Access also provides view controls at the bottom of
the window. See Figure 18-20. Using these buttons
lets you quickly jump to the first record, next
record, previous record, and last record. You also
see a Filter indication and a Search box. You’ll take
a look at those shortly.