Hello, I am very new to access and having a pretty hard time using it. Basically I need to develop a database for a bunch of test items. For each test item, there are (or will be) 6 alternate versions. Right now I am using the datasheet function and essentially using the sheet just as i would in excel or SPSS. However, I would like to insert a record (or row) in between other records (as new alternate test items get developed I need to enter them into this sheet) but I am finding that when I try to insert a new record (row) it jumps down to the bottom. I will definitely need to move rows around a lot so I need to know if this is possible, and how.
Alternatively, if someone can recommend a more savvy approach to developing a database to track test items, please advise!! Thanks so much for any input!!