i need a database for cd inventory, anyone with one?

H

helpmeplease

I am looking for a database that a dj could use to access his list quickly
and easly.
 
W

Wayne-I-M

Hi

Access is a relational database so it "could" if set up right allow your DJ
to find each record by XYZ it can also find how many artises have record the
song ABC

But

In this case access is not really what you are looking for. If your DJ is
using CD it is almost certain that they will have loaded the song on to a
hard drive (could be a server or local). In this case access will not be
able to scan file details and log them automatically.

There are "many" music databases that DJ's use - a bit like a much more
complex Windows Media Player - that allow DJ's to simply load a cd and then
catoglog the contents by Artiste, Song Title, Type, etc etc etc. I would
google search for one that suits what you're looking for and get a free
download to start with to make sure it really works.

Don't use access for this.
 
W

Wayne-I-M

There are so many really good music databases I can't see the point in trying
to make a new one from scratch.

If you have a CD with music on you can simply insert it into your machine
and load all the details into a database. You do not have to spend time on a
keyboard - it will be automatic.

If you "really" want to create a database it will not take long - it is the
data inserting that will.

Create a table call tblCD
Another called tblSong
Another called tblArtiste

I would use the SongID to link the tables - or better still use Windows
Media Player or ITunes - both of these will do the job very simply.

I really would not bother - I don't normally say that about access, but in
this case ??

I have just done a quick google and there are many ready made DB's for music
that are free - have a look.
 
H

helpmeplease

thanks again for your help


Wayne-I-M said:
There are so many really good music databases I can't see the point in trying
to make a new one from scratch.

If you have a CD with music on you can simply insert it into your machine
and load all the details into a database. You do not have to spend time on a
keyboard - it will be automatic.

If you "really" want to create a database it will not take long - it is the
data inserting that will.

Create a table call tblCD
Another called tblSong
Another called tblArtiste

I would use the SongID to link the tables - or better still use Windows
Media Player or ITunes - both of these will do the job very simply.

I really would not bother - I don't normally say that about access, but in
this case ??

I have just done a quick google and there are many ready made DB's for music
that are free - have a look.
 
Top