Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is it possible to move the "New Record Row" in an Access table to the beginning of the table?

For example, say you have 200 items entered into your table, you would have to scroll the whole way down to the bottom of the table to enter a new record.

Instead, your entry row would be in the first row of your table.

Can this be done?

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

Not in the table itself. Access adds new records to the bottom of the table by default as they are just containers to hold data. Forms are typically used to enter data.

To add records directly to the table, you can click the New Record button on the navigation bar at the bottom of the table window. This takes you directly to the new row to enter data.

enter image description here

Alternately, you could create a simple form to add new records.

share|improve this answer
    
Thanks! Agreed that a form should be used to enter the new data rather than the table itself. –  Muhnamana Feb 25 '13 at 15:08
    
I have someone who got into the habit of entering data via the table and hates using a form, I don't know why but I thought I'd ask if there was an option to accomodate this person. –  Muhnamana Feb 25 '13 at 15:09
1  
Understood. You may want to remind them they risk data integrity by being in the table editing records like that. It makes it very easy to make mistakes by editing existing data by accident. –  CharlieRB Feb 25 '13 at 16:51
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.