Thank you experts, in advance!

I am attempting to make an asset managing database for my personal use
within my company. The trillion Excel pages I have to update atm is
becoming ridiculous.

What I have:
A table with all employees' first and last name, division, department,
etc.
A table with all devices' serial number, type, version, etc.

Each device is linked to an employee... each employee can have
multiple devices.


What I need:
I would like to know the best way to assign software to these
devices. I would like to have a table of all of the software we own
(i.e. Microsoft Office Pro 2007 Open License) and the number of
licenses of that software we have purchased (i.e. 100 licenses), then
somehow assign those licenses one at a time to the devices they are
installed on... when the 100 licenses have been assigned, no more will
be available to assign to another device. I'd like to include the CD
key as well, but that's the simple part. We'd have to be able to
assign multiple types of software to each device, as well (i.e. a
computer could have MS Office as well as Lotus Notes...)

Does anybody know how I can accomplish this? I don't expect it to be
done for me (although that would be nice... any takers?), but maybe an
idea on what step to take next would be helpful!

Please note - I AM AN EXTREME NEWBIE TO ACCESS - this is my (count
'em) SECOND ever made database, so please don't go way too far over my
head.

Thanks again, experts!!!!