How do I Receive In and Issue Out using ACCESS?

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

Guest

I am new to this program and am not sure how our company will use this as our
primary inventory program. Also as you can see from my question there was not
much training with this.
 
Acess is an application that allows you to build custom databases, just like
Excel allows you to build spreadsheets, and Word allows you to build a
document. If you want to use this tool to manage your inventory, you would
need to build a database. Microsoft Access is not an out-of-the-box
inventory program.

This is not a trivial task. You must invest a great deal of time into
planning the structure of the tables, how each table will relate to the
other tables. What reports you will need. How users will enter data. Etc.

This newsgroup is here to provide you specific answers to specific
questions. We can't build a database for you.

If you click the NEW button and then select the "DATABASES" tab, you will
find several smaple database templates that come with Access. One of them
is an Inventory Control databse. That might get you started, but you will
most likely need to heavily customize it to meet your needs.


Rick B
 
Navigate to C:\Program FilesMicrosoft OfficeXXX\OfficeXX\Samples\

You will find a sample database there named Northwind Traders. It has
inventory functionality built in. Explore how it is done there.

If your company needs an Access database set up to track inventory or any
other use, I can help you. Contact me at my email address below.
 
Hi,

Access is a great tool for helping to solve your inventory problem but given
your question, you have a long way to go.

Access has a steep learning curve. Once well begun, you will find that
Access can be used to solve lots of problems that occur in business
environments and even home and medical environments. There are ample tools
for learning from online tutorials to books to high pressure seminars. To
find references in the Access newsgroups you can do google searches
on"tutorial", "books", etc. You'll get a few hits to get you started.

Learning how to use Access to solve problems is only one part of a
developer's required skill set. The other major component is the ability to
elicit and compose a complete analysis of the problem and solution for the
current endeavor. You are most fortunate if you are expert in both sides of
the issue. In the case of an Inventory Control Program, you may be in luck.

If you need a robust inventory control program in a hurry you'd be well
advised to hire it done by a well qualified Access developer. If you have a
well documented process you'll have to make that, along with examples and
other supporting documentation, available to the developer. If your process
isn't well documented, that's where you should start.

HTH
 
Back
Top