A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

New to the whole DB world



 
 
Thread Tools Display Modes
  #21  
Old December 2nd, 2009, 08:12 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default New to the whole DB world

Oho! Willing to spend people's time/salary, but not willing to purchase
software or hire expertise...?

Best of luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"freddy" wrote in message
...
The problem is that the company does not want to spend money.

"jacksonmacd" wrote:

I know this is an Access newsgroup, and you are looking for an Access
answer, but have you considered that you might be reinventing the
wheel? Perhaps an off-the-shelf solution like Spiceworks
(spiceworks.com) might save you a lot of work.

But then again, you might be looking to improve your Access skills.

PS. I have no affiliation with Spiceworks or any other similar
software.


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


--

remove uppercase and number for true email
.



  #22  
Old December 2nd, 2009, 08:12 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default New to the whole DB world

Oho! Willing to spend people's time/salary, but not willing to purchase
software or hire expertise...?

Best of luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"freddy" wrote in message
...
The problem is that the company does not want to spend money.

"jacksonmacd" wrote:

I know this is an Access newsgroup, and you are looking for an Access
answer, but have you considered that you might be reinventing the
wheel? Perhaps an off-the-shelf solution like Spiceworks
(spiceworks.com) might save you a lot of work.

But then again, you might be looking to improve your Access skills.

PS. I have no affiliation with Spiceworks or any other similar
software.


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


--

remove uppercase and number for true email
.



  #23  
Old December 2nd, 2009, 08:14 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default New to the whole DB world

Why?

If you already have the data going into Excel, what is it that you expect
Access will do that Excel isn't doing?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"freddy" wrote in message
...
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



  #24  
Old December 2nd, 2009, 08:14 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default New to the whole DB world

Why?

If you already have the data going into Excel, what is it that you expect
Access will do that Excel isn't doing?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"freddy" wrote in message
...
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



  #25  
Old December 2nd, 2009, 08:14 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default New to the whole DB world

Why?

If you already have the data going into Excel, what is it that you expect
Access will do that Excel isn't doing?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"freddy" wrote in message
...
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



  #26  
Old December 3rd, 2009, 12:47 AM posted to microsoft.public.access.tablesdbdesign
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default New to the whole DB world

freddy wrote:
The problem is that the company does not want to spend money.

I know this is an Access newsgroup, and you are looking for an Access
answer, but have you considered that you might be reinventing the

[quoted text clipped - 26 lines]
remove uppercase and number for true email
.


In that case, you could do an estimate of how much time it will take you to
write something that does close to what they want and come up with a cost to
have you do it. If buying something is cheaper than having you do it, they
may go that route. if they don't bite, then you may be forced to DIY. The
upside is that you learn, the downside (obviously) is that it takes time to
learn and some trial an error...

--
Message posted via http://www.accessmonster.com

  #27  
Old December 4th, 2009, 03:36 AM posted to microsoft.public.access.tablesdbdesign
jacksonmacd
external usenet poster
 
Posts: 45
Default New to the whole DB world

Spiceworks is free.


On Wed, 2 Dec 2009 08:21:01 -0800, freddy
wrote:

The problem is that the company does not want to spend money.

"jacksonmacd" wrote:

I know this is an Access newsgroup, and you are looking for an Access
answer, but have you considered that you might be reinventing the
wheel? Perhaps an off-the-shelf solution like Spiceworks
(spiceworks.com) might save you a lot of work.

But then again, you might be looking to improve your Access skills.

PS. I have no affiliation with Spiceworks or any other similar
software.


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


--

remove uppercase and number for true email
.


--

remove uppercase and number for true email
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.