Any one use Access Database?

redeldo wrote:
Hopefully there are some that use Access as I am trying to set up a database and have a question.

The database is CASSETTE TAPE COLLECTION. I have 20 columns starting with ID, TITLE OF CASSETTE, SONG 1, ARTIST, SONG 2, ARTIST, etc.

Going alphabetically I incorrectly entered tapes out of order. When I sort Ascending, the TITLE OF CASSETTE is in order but the ID column is out of order. Instead of being 1 through 14, it is: 1 2 5 6 8 7 9 10 11 12 13 3 4 14. If I sort the ID Ascending, the ID is in order but the Title is out of order

Any way to get both columns in order or do I have to start over? Also I am using Access 2000 as I don't have a newer version which I would like to use.

Thanks

Wayne
01 Monaco Dynasty

Self taught Access user here. From your description, it looks like you are trying to use Access similarly to a spreadsheet. You have put all the data fields into one table, which is not the proper way to build a database.

If I were to make a database to record info about cassette tapes, CD's or other music, I would make three tables to hold the data. One table would hold the just cassette names and a primary key field. The second table would hold just the song names and a primary key field, and the third the artist names and a primary key field. The idea with a database is that each record in a table holds unique data. Each cassette name is entered once, each song name is entered once, even if it is on more than one cassette - each artist name is entered once, even if that artist sings many songs on many cassettes. The various song and artists names are related to a specific cassette by relating the tables themselves. The primary key field in each table is used to link one table to another and must be unique for each record in a specific table.

There's more to doing it than this, but I'm sure I've lost you already.

Since you have already entered the data for the cassettes, the easiest way to get the data sorted into a cassette ID number sequence would be to add an additional field to hold the Cassette ID and then enter the cassette number. You can then sort on this Cassette ID field.