"How-to" question from an Access novice

[El Marko]

I am just acquainting myself with Microsoft Access. I am trying to create a
way to keep track of the ink and toner used by the printers at my company. I
was using an Excel spreadsheet, but we have too many different printers and
associated inks or toners.

The duplications are killing me. Different locations use the same print
device model. Different models of printers use the same inkjet or toner
cartridge. I thought this would be simple. Ha!

Twice a month, I need to get a report to the purchasing department informing
them of how many of each cartridge we have. They also need to know how many
print devices are affected by each supply so they can order an appropriate
quantity. For me, it's also handy to know the physical location of each
print device.

Anybody here done this?

 

[El Marko]

Thanks for the quick reply!

Normalize is tough. Bobby, Betty, and Billy use the same model 880cse
printer, just not the same particular device.

The 3 inkjet models xx12 in Accounting use the same black ink as the 2
inkjet models xx13 in Purchasing. But the xx13 uses the same color ink as
the xx22 in Manufacturing.

And so on......