Access help!!!!

[Kodie]

Hi all…… I have never used Microsoft Access before and I am in need of
serious help. I have a project that I have to complete and have no idea how
to use Access to accomplish this. Any input would be greatly appreciated.
I don’t know all the jargon (aka- computer savvy) as all you fine people, but
I will do my best to explain my problem. I have to build a simple relational
database for a bicycle shop. The database will contain two tables: a supplier
table and a product table. The reorder level refers to the number of items in
inventory that triggers a decision to order more items to prevent a stockout.

The user should be able to perform several queries and produce several
managerial reports based on the data contained in the two tables. After I
have built the database, I must perform some activities. I hope this makes
sense to someone. I have no knowledge of Microsoft Access. I apologize if
this is posted in the wrong thread. I have asked everyone I know if they know
ANYTHING about Access, but unfortunately no one really even knows the program
exists. If anyone feels like they can help me out or explain how I would go
about doing this, I wouldn’t mind contacting you via the phone. Thank you in
advance.

 

[Kevin3NF]

So how far have you gotten? Are you getting errors?

Do you track sales as well? Are you manually adjusting the 'on hand' field?
I assume you have one if you want to make decisions based on that number.

You've told us what you want, but not how far along in the process you are.

Details please....

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[PC Datasheet]

Kodie,

You need to begin by creating tables. Have you done that yet?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you don't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Remember that a lone man built the Ark. A large group of professionals built
the Titanic.

 

[John Marshall, MVP]

Remember that a lone man built the Ark. A large group of professionals
built the Titanic.

What's this nonsense about? Are you trying to bring an off topic subject
like religion into this newsgroup?
Or are you trying to imply that a single individual is better than a group
of experts.

What is your proof that Noah built the Ark alone. During that age of
begatting, did he not have a lot of kids and relatives to help?

What is your proof that the designers and builders were solely responsible
for the crash. Didn't the captain have some responsibilities? The
accountants? The owners?

The only similarity between these two stories is that both vessels were only
used once and both crashed, one into an iceberg, the other a mountain.
Or since there is a religious connotation, are you trying to say god aided
the lone man and then created an iceberg to punish the professionals?
... but wait, if you are implying that you are the lone man and god is on
your side, why do you deny his existence? (You question if Arno is real, but
you have said he was god).

This is getting confusing.

John... Visio MVP

 

[Chris2]

Hi all…… I have never used Microsoft Access before and I am in need of
serious help. I have a project that I have to complete and have no idea how
to use Access to accomplish this. Any input would be greatly appreciated.
I don’t know all the jargon (aka- computer savvy) as all you fine people, but
I will do my best to explain my problem. I have to build a simple relational
database for a bicycle shop. The database will contain two tables: a supplier
table and a product table. The reorder level refers to the number of items in
inventory that triggers a decision to order more items to prevent a stockout.

The user should be able to perform several queries and produce several
managerial reports based on the data contained in the two tables. After I
have built the database, I must perform some activities. I hope this makes
sense to someone. I have no knowledge of Microsoft Access. I apologize if
this is posted in the wrong thread. I have asked everyone I know if they know
ANYTHING about Access, but unfortunately no one really even knows the program
exists. If anyone feels like they can help me out or explain how I would go
about doing this, I wouldn’t mind contacting you via the phone. Thank you in
advance.

Kodie,

If you intend to prevent "stockouts", you will need more than just a
supplier table and a product table.

You'll need various inventory tables, etc.


Also you mentioned: "After I have built the database, I must perform
some activities."

You did not mention what these activities were.


Please understand that you have asked a, "How do I completely build a
stock-handling decision-making MS-Access based software application
from scratch," type of question. There are thousands of details
associated with this, and at least as many questions.

The answer is, pick up some Access and DB-design books.

Database Design for Mere Mortals
SQL Queries for Mere Mortals

Plus some books based on the version of MS Access you have installed.

Read through them, study them, etc. It's a big job to learn all that,
but then so is building the bicycle inventory management software you
want.

Here is a website that discusses a bare bones example of inventory
control in relational databases:

http://allenbrowne.com/AppInventory.html


Sincerely,

Chris O.

 

[Jeff Boyce]

Kodie

How is it that you've decided that Access is the tool you need to do this?

As others have indicated, there's a fair-to-steep learning curve to building
a user-friendly (if not user-resistant) application.

Do you have the time it will take to learn enough about Access?

Feel free to post specific questions to the newsgroups, but since these
groups are voluntary, you may not find folks willing to walk you through all
of the intricacies of building a database application from scratch.

 

[Craig Hornish]

First off John the quote was in the signature section were a number of other
people put off topic comments so that answers your first two questions.

Now, both of you need to reread the tale of Noah. I've had only a limited
education with it
but I do remember some of it. Well 1 man of course was wrong but also the
comment about lots of
kids and relatives. I believe the story goes that Noah, his wife, and his 3
son's and their wives
were on the Ark. So really not allot of people to build the Ark.

And who said anything about a crash - yes you are confused the Ark landed on
the mountain.
It was not a crash. It didn't sink.

As with any discussion about God, there is no right answer, and if you try
to prove anything
all you will get is more argument. So taking what I say with a grain of
salt, I think what the quote
is saying is simply, "With God's help you can do anything". You really
should not read any more into
it or you will get lost.

Craig

"Think outside the box, because anything is possible."
"How long it will take or whether it requires divine intervention is another
issue"

PS John this is my signature, I have used is sometimes when responding to
some closed minded people
when talking about coding. It does not, in my opinion, invite people into a
discussion about religion.

 

[John Marshall, MVP]

Thanks Craig for you honest appraisal of the comments. As you gather, my
comments should be taken with a grain of salt (or more likely a bag of
salt).

Yes steve santos comments are in the sigline, but I believe he added them to
annoy some of the regulars.

Well 1 man of course was wrong but also the comment about lots of
kids and relatives. I believe the story goes that Noah, his wife, and his
3 son's and their wives were on the Ark.

Lots is a relative term. For some, eight would be a crowd. The point was
that Noah was probably not a solo act.
I was intentionally being vague so that there were no arguments about the
details.

And who said anything about a crash - yes you are confused the Ark landed
on the mountain.
It was not a crash. It didn't sink.

Crash has a wide variety of meanings. In terms of the Ark the word should be
grounded. Landed implies it was done with a bit of finese. The use of the
word was more to point out the similarities between the two stories. Both
captains ended their trips at a location and in a mannerthat was not
planned.


Judging by comments that steve has made elsewheres, what I think steve
santos is trying to say is that an individual can do better than a group of
professionals.
Though I would be interested in hearing steve's honest reason as to why he
added that to his sigline.

PS John this is my signature,

I have no problems with siglines unless they are designed to annoy.
The siglines give a little insight into who the poster is or what he does.
If a user likes the answer a poster makes, I see no problem with a user
using the contact information in the poster's sig line. Steve has gone
beyond that by insinuating that only he can provide help (at a cost) and
ending his messages by telling users to call him.

The problem with steve is that he has a hard time remembering that these
newsgroups were provided for users to freely help each other.

John... Visio MVP