Request for Quote and Manufacturing Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a new user so I am not familiar with setting up a database. I am
looking to set up a database so I can track new request for quotes, have a
way to see if I have quoted the same thing before or something similar. Keep
track quotes that have been awarded and assigned purchase orders, track
shipping requirements, packaging, part specs. PPAP and quality information
and be able to print out work instructions.
 
Shelly said:
I am a new user so I am not familiar with setting up a database. I am
looking to set up a database so I can track new request for quotes, have a
way to see if I have quoted the same thing before or something similar. Keep
track quotes that have been awarded and assigned purchase orders, track
shipping requirements, packaging, part specs. PPAP and quality information
and be able to print out work instructions.
Click to expand...

When you say new user do you mean you've never used Access? If so, I would
say that if you need this project to be completed in a timely manner you
need to outsource it. Access has a pretty steep learning curve and the
specs you've covered here are most likely well beyond a beginner.

gls858
 
I am a new user so I am not familiar with setting up a database. I am
looking to set up a database so I can track new request for quotes, have a
way to see if I have quoted the same thing before or something similar. Keep
track quotes that have been awarded and assigned purchase orders, track
shipping requirements, packaging, part specs. PPAP and quality information
and be able to print out work instructions.
Click to expand...

You're talking about a pretty substantial database here. Do you want
someone to spend the twenty or so hours to build it for you? What's
your budget? Do you want a premade template with your specific
features? There probably isn't one. Do you want advice in how to start
building it yourself?

We're all volunteers here; we'll be happy to help, but it would be
useful to have a clear understanding of what you expect - and for you
to have a clear understanding of what we can provide.

John W. Vinson[MVP]
 
You have not really asked a question on what your looking to get from this
group.
But I am interested in the requirements you have set forward and would like
to discuss this with you.

Please email me at (mail at chornish dot com)

--
Craig Hornish

Visit weekly Access conferences
Tuesday, 11:00am-12:30pm (Eastern US)
Thursday, 3:30pm- 5:00pm (Eastern US)

http://community.compuserve.com/n/pfx/forum.aspx?webtag=ws-msdevapps

"Think outside the box, because anything is possible."
"How long it will take or whether it requires divine intervention is another
issue"
 
If the funds were available I would love for someone to just build it for me,
however, I would like to learn Access and probably need to figure out how to
build it myself.
 
Shelly said:
If the funds were available I would love for someone to just build it for me,
however, I would like to learn Access and probably need to figure out how to
build it myself.
snip<
Click to expand...
In that case I would suggest first of all becoming familiar with the
concept of normalizing data. The link below has a pretty good explanation.

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=88

A search on normalization will get you many more. Also Microsoft
has an online training for Access. Try this link for some additional
info.

http://office.microsoft.com/training/training.aspx?AssetID=RC061181381033

Also a search on Access 2003 tutorial will get you lots of help.

Of course you can always come back here with specific questions.

Good Luck!

gls858
 
If the funds were available I would love for someone to just build it for me,
however, I would like to learn Access and probably need to figure out how to
build it myself.
Click to expand...

Just to add to the links gls58 posted, check out

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

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

Especially note the "Database Design 101" links on Jeff's page.

John W. Vinson[MVP]
 
Back
Top