Any one use Access Database?
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, S...
Forum Discussion
When using a database, there shouldn't be any need for you to enter things 'in order'. That what's the computer does when you ask it to. I assume ID is the unique identifier Access is assigning. Each column will sort on its own, so either ID or TITLE will be in order.
I also see you're entering all that song information in the same file. To be a better design you may want to consider the 'one to many' relationship. That is, your ID and Title can be in one file, then the song information is in a separate file, indexed on ID (the same ID as the Title).
Nowadays, text file searches have become so fast it's almost unecessary to put small databases in database programs.
I also see you're entering all that song information in the same file. To be a better design you may want to consider the 'one to many' relationship. That is, your ID and Title can be in one file, then the song information is in a separate file, indexed on ID (the same ID as the Title).
Nowadays, text file searches have become so fast it's almost unecessary to put small databases in database programs.
