Ink Cartridge Database

[Fuzion]

Hi,

I have currently got a huge spreadsheet of Printers with there cartridges in. I was thinking about moving over to Access, but to be honest, totally new to this.

Has anyone got any pointers, or even better, something similar to this that I could work from?

Thanks in advance,

J

 

[Oldsoftboss]

Hi Fuzion, and welcome.
There are many threads on importing excel sheets into access. The easiest way I found was to do the following:

Make sure your spreadsheet column headers describe the info in the column (access will ask)

Open a blank Db

In excel highlight the area you want to transfer to access.

grab the edge of this area and simply drag it into access and the onto the db window. Access will ask "Does the first row contain something" (cant remember) Select yes, and a table will automatically be created.

If you are unsure, you can post the xl sheet here.

Dave

 

[Fuzion]

Hi Dave,

Thanks for that. I am thinking about starting it off again as I need to have alot more info than I have in the Excel sheet. I have got a book out the library today, so I will have a look through that. If you have any spare time and you dont mind me asking you questions, please let me know, would be very grateful.

Many thanks

J

 

[neileg]

I presume you want to track the cartridges that fit the printers. So you'll need a table for printers and a table for cartridges. Since printers can have more than one cartridge, black and colour or even three colours, you have a many-to-many relationship. You will need a third table that is a junction table between the two. Do a search in these forums for many to many and junction table. There's lots of help.

 

[Ron_dK]

Apart from Neil's relationships thing, you might do a search for Normaliz(s)ation.
This will give you an insight of what relational databases is all about.

Hth