i need a template to organize songs by artist then song

[Guest]

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

 

[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.

 

[Rick B]

A template is on the Microsoft website...

http://office.microsoft.com/en-us/templates/TC010186291033.aspx