Microsoft Office Tutorials and References
In Depth Information
Entering the Data in Datasheet View
Database tables open in Datasheet view when you double-click their names
in the Navigation pane. But if you happen to be gazing at a table in Design
view, click the View command on the Home tab or the Datasheet View
button on the status bar.
Entering data
In Datasheet view, the bottom of the window tells you how many records are
entered in the database table and which record the cursor is in. To enter a
new record, move to a new, empty row and start entering the data. To create
a new row, do one of the following:
On the Home tab, click the New button.
Click the New (Blank) Record button in the Datasheet navigation
buttons. These buttons are located at the bottom of the Datasheet view
window.
Scroll to the bottom of the Datasheet view window and begin typing in
the row with an asterisk (*) next to it.
Press Ctrl++ (the plus key).
A pencil icon appears on the row selector to let you know which record
you’re dealing with. To get from field to field, click in a field, press the Tab
key, or press Enter. Table 3-1 lists keyboard shortcuts for getting around in a
datasheet.
Book VII
Chapter 3
Table 3-1
Datasheet Shortcuts
Press. . .
To Move. . .
To the previous record. You can also press the Previous button
on the Navigation buttons.
To the next record. You can also press the Next button.
Tab or Enter
To the next field in the record.
Shift+Tab
To the previous field in the record.
Home
To the first field in the record.
End
To the last field in the record.
Ctrl+Home
To the first field in the first record. You can also press the First button.
Ctrl+End
To the last field in the last record. You can also press the Last button.
Page Up
Up one screen.
Page Down
Down one screen.
Search JabSto ::




Custom Search