Inserting &
Amending Data
Data can be inserted and
amending in a variety of manners. In MS Access data can be inserted using a
basic datasheet view or by a specially designed form.
Datasheet View
In a datasheet each field is
displayed in cells within rows, with each row being a record. A blank record
is always present at the bottom of the datasheet, simply click into the
first cell in this row to start entering data. Type in data using the
keyboard and move to the next field or cell by pressing enter, tab or by
using the cursor keys.
Data can easily be amended by
clicking into an existing cell and using the backspace or delete keys to
delete data and then amend the data by typing in the new value. You can also
overtype existing data.
Deleting an entire record is
different. Merely deleting the data from all the cells in a record would not
delete the empty record from the table. This is done by clicking on a record
and then using the Edit menu, followed by clicking on delete row. This
deletes the data and the record from the table.
The disadvantage of using the
datasheet view, instead of a form, is that the datasheet view is quite
restrictive. On a form the designer can set up the fields to different
sizes, depending on the type and sizes of data expected. Special objects are
used for special data types like pictures and the like. |
