i need a template to organize songs by artist then song

T

timmer

i need to organize a bout 2000 vynle 45 records and i need to alphabetize
them by artist then with 2nd heading under artist for songs by said artist
 
R

Rick B

This newsgroup is to answer specific questions, not design the database from
scratch. Get rolling and then post your specific questions.

You will most likely want a table containing the Album information...
RefNumber
Artist
Album Name
Label
Year

The Artist could be a lookup that pulls from another table where the artists
live.

Another table for songs...
Title
Duration
AlbumRefNumber

You might need to consider that a song title could be on several of your
albums.

That should get you started.
 
Top