How do I insert (not add) a record in Access 2003 a single line en

[Guest]

I have a basic database I need to insert information in the database when I
hit insert it takes to the bottom of the data base . I thought I could hit
insert like in excel and insert a blank line to input the information can
anyone help me. Thanks

 

[John Vinson]

I have a basic database I need to insert information in the database when I
hit insert it takes to the bottom of the data base . I thought I could hit
insert like in excel and insert a blank line to input the information can
anyone help me. Thanks

A database IS NOT A SPREADSHEET. They are *different*.

One way in which they are different is that a Table has no row
numbers; it *has no order* in any controllable way. It's a big heap of
data.

If you want to see records in a particular order, you can (must!) use
a Query sorting the records by one or more fields within the record.
This Query will be updateable and can be used anywhere that you would
use a Table.

John W. Vinson[MVP]

 

[Joseph Meehan]

I have a basic database I need to insert information in the database
when I hit insert it takes to the bottom of the data base . I thought
I could hit insert like in excel and insert a blank line to input the
information can anyone help me. Thanks

Databases like Access store data in a bucket. It has no order so
inserting has no meaning. If you want data to remain in any kind of order,
you need to provide that order. It may mean a Item Number field. (warning:
autonumber is not a consecutive number source. It is a unique number
source)