Re: Please suggest relationships model

And where do you think a business owner would be if he spent five years
trying to create databases for his company rather than hiring some one to
create databases for him and he managing his business? For that matter,
where do you think a company would be if key employees spent five years
trying to create databases for their company rather than asking their
manager to hire someone to create databases for him?

I got to be a consultant in the same way you did. And here is where I am
now -- I work from home and have not had a 9-5 job in almost fifteen years.
I have three full time developers working for me. I have done thousands of
small jobs for customers just like the people who post in the newsgroups and
a few larger jobs. My mission has always been to provide customers a
resource for help with Access, Excel and Word applications. My fees have
always been very reasonable. I strive to work together with customers and I
strive to make the customer feel well-satisfied working with me. It has been
very successful for me. After all these years, I still am learning and I
recognize that the learning will never stop. After all these years, I am the
first to admit I make mistakes. However, I always make my best effort to
correct my mistakes.

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx





"Gina Whipp" <NotInterested@xxxxxxxxxxxxx> wrote in message
news:uDCvfNU0HHA.5380@xxxxxxxxxxxxxxxxxxxxxxx
To answer your question...

If he wants to do it himself which I am gathering because here he is in a
FREE newsgroup then I, along with folks much more qualified, assist him.
I will NOT 'push' my services on him.

However, if is asking for paid help, I will direct him to the MANY sites
where he could look for a professional in his area, as well as, check
their references, perhaps even have them come in and show samples of their
work. I WILL NOT EVER suggest myself. If he happens to find my name on
one of those MANY sites where you post your services, then I would mention
I saw him in a newsgroup. But I am NOT here to 'fish' for business and I
am certainly NOT gong to suggest hiring a professional prior to him/her
even asking for one.

I was a beginner once and this is where I came to learn and I still come
for tips. I would have been insulted if someone suggested I was incapable
of doing this myself. Look at me now, I contract for several companies.
Where would I be if I had not dared to try? If these groups weren't here?
If I hired a prefessional? Now I work from home, I have not had a 9-5 job
in 5 years and NEVER ONCE did I go trolling!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
"Steve" <Sorry@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:KvIqi.12817$zA4.7352@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
O.K., let's put it in other words ---

If you saw a post by a business owner where it is obvious he has only
dabbled in Access and he says he desparately needs a way to track his
inventory, would you advise him to spend time trying to create
an inventory database and go to the newsgroups, books and other resources
when he needs help or would you advise him to hire someone to create an
inventory database for him and spend his time managing his business?

Steve




"Gina Whipp" <NotInterested@xxxxxxxxxxxxx> wrote in message
news:urYhVjL0HHA.1164@xxxxxxxxxxxxxxxxxxxxxxx
If he came to me (your words) then he got my name from someone and
contacted me directly, NOT via a newsgroup, therefore I can do business
with him. However, these people aren't 'coming to you'... you are going
to them.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

"Steve" <Sorry@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:3iwqi.12653$zA4.871@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
You miised the whole point!

If a business owner who has only dabbled in Access came to you wanting
a way to track his inventory, would you advise him to spend time trying
to create an inventory database and go to the newsgroups, books and
other resources when he needs help or would you advise him to hire
someone to create an inventory database for him and spend his time
managing his business?

Steve



"Gina Whipp" <NotInterested@xxxxxxxxxxxxx> wrote in message
news:eYEnhRJ0HHA.5152@xxxxxxxxxxxxxxxxxxxxxxx
Steve,

If this is a reply to my eMail then please don't try to explain your
soliciting to me. It is wrong in a FREE peer-to-peer newsgroup. I
'write' databases and have been doing so for 10 years. Right now, I
am doing 6 contracts and am looking for help but it would never even
occur to me to advertise for help here! And NEVER, let me me repeat
that, NEVER have I ever tried to solicit work from this FREE newsgroup
or any other FREE newsgroup unless they supply a section to do just
that. I don't show my eMail address, no links to my site, NADA,
NOTHING, ZILCH... well, you get the idea, because that is not why
these groups are here!

I will also note, that I get my work by word-of-mouth and have to
provide my web page... AND even if I ran out of work tomorrow, I would
NEVER solicit here! I come to here to get help and give help when I
can. I come here to learn, share and sometimes get a good chuckle! I
don't come here to post my resume or sell my services.

So please, don't offer your lame reasoning for trying to drum up
business. If contracting is not working for you get another job until
something comes along.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

"Steve" <Sorry@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:G6tqi.11426$rR.1391@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Do-it-yourself is not always the best decision. In fact, it can be a
very poor decision. Yes, from only the database point of view, if you
create a database and it works for you, do it yourself is cheapest.
From a business perspective, it can be much more expensive than
hiring someone to build the database for you. The do-it-yourself
route requires dedicated time and effort which means taking the time
and effort away from something else. If you could have spent that
time in a more profitable way such as increasing sales, the database
cost you the value of the lost sales and that could easily be many
times the fees you would have paid someone to create the database for
you.

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx





"Gina Whipp" <NotInterested@xxxxxxxxxxxxx> wrote in message
news:O2f793I0HHA.1164@xxxxxxxxxxxxxxxxxxxxxxx
Moe,

Below is a few links to help you get started... Please note, this
FREE newsgroup provided by Microsoft would NEVER dream of charging
you. Everyone (well almost everyone) VOLUNTEERS their time to
provide FREE support and assistance.

Ms Access Fundamentals: http://www.functionx.com/access/

Samples downloads:
http://www.rogersaccesslibrary.com/TableOfContents3.asp

Code, sample downloads, sample coding (I love this site):
http://www.mvps.org/access/

Data model samples: http://www.databasedev.co.uk/data_models.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

"Moe" <henriquezmoi@xxxxxxxxxxx> wrote in message
news:4741BC76-878E-49A2-9FAA-9AF95E42F1F8@xxxxxxxxxxxxxxxx
What I need to do:

I have some rather expensive inventory items that I need to keep
track of.
These are to be used in several projects (jobs).

I'm trying to design a simple database to help me keep track of
where
everything goes, so I can bill the right job for the right
products.

More Details:
Inventory items have an ID, and description. I need to know how
many of each
item I still have remaining.

Jobs have unique ID numbers (I dont want to use autonumber for
this).

I was thinking maybe I could design something that would sort of do
transactions.

Assign a transaction ID (Autonumber is ok), A date, a project #
(job#)
and how many of each of the inventory items were transfered on that
date, or
transaction.

I did a little designing, and came up with three tables.

Inventory
|_ ID
|_ Description
|_ Quatntity on hand (??)

Jobs
|_ ID
|_ Address

Transactions
|_ ID (autonumber ok)
|_ Date
|_ Quantity
|_ Description

Can someone suggest an efficient relationships model to make this
work?

Thanks in advance

--
Moe
















.

Loading