On Tue, 1 Dec 2009 07:48:01 -0800, freddy
wrote:

I am a desktop support person and I have a vbscript to inventory all the
computers on the network. I use the script to gather information like
username, memory, hard drive space, and I am thinking about getting installed
software. I have the script writing to an excel file, which is ok for now. I
would like to use Access 2003 but my problem is the design. Do I create one
table and have a field for username, computer name, memory, and so on or do I
create more than one table like for username and one for computername. Plus
how do I handle the installed software?
My idea was to have three tables: one for username which will have full
name, one for computername which will have all the computer stuff like
memory, hd, etc and one for software which will have software name, version,
installed date, etc. Please someone help me out.

Thanks
Freddt

You'll need more tables than that - in particular, you'll want one table for
Software (with one record each for Microsoft Word 2007, Zork-1, etc.), and
another table for SoftwareInstalled, with links to the table of computers and
the table of software, and fields for date installed, etc.

Here are some resources to get started. The tutorials at the end of the list
may be particularly helpful:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--

John W. Vinson [MVP]