Help in microsoft access?

Question

At work, they have a small non-profit organization with about 40 workers. They wanted me to enter billings, payroll, clients, bimonthly hours, and staff. On two of the tables I made, I saved them but later on I opened them up and some of the top records shifted down to the bottom. They aren't in the order that they were originally in. I have tried copying and pasting them back to the top of the table but it doesn't let me. I also can't insert a record into anywhere but the very bottom of the table. I have done this in an on-line course but they gave me all of the steps and I am on my own with this one. I am using the 2003 edition. Thanks in advance.

Answer 1

Which of the fields in your table do you want the sort order?



Try appending those records to the table...instead of just "pasting" them over..

Answer 2

Access is a dynamic database. Like most dynamic databases, it fills in data where it sees space available. As you add rows, the database will grow but it will not get smaller as you delete rows; it just marks the row as empty. The next row which is added will get inserted into the empty space. This is why the data doesn't appear in order. In order to see the data in a specific order, you will need to sort the table or create a view, which is a query. Even then, after inserting a new row, you will need to refresh the query (F5) in order to see the data sorted correctly.

Answer 3

on line class for Go Office? we used 2007. seems like when we did it .. it was a memory problem. save your work and restart the machine to clear RAM. Open Office is suppose to be compatible w/ M$, you could try and export it to open office to see if that worked, then export it back.

BTW there are quite a few errors in the Go books.

Answer 4

Select the field you want to sort order, then click on Primary Key . Also, the column should be "Indexed".