Macros in Access 2003

[Kelly]

Hello,
I really need help with Access 2003. My first question is, can Access 2003
do more then just contain the data base, I'm brand new to Access and I need
to track inventory for Nutritional Services at a School District. Currently
we are using Excel, which is horrible for what we need. We need a beginning
inventory, we need forms that can take items from inventory and add them in
(for orders and receivables). All I have to learn Access is a 2000 tutorial
CD (3 pack). I've set up several tables and forms, but the CD doesn't really
get into Macros. I was trying to download an "order form" template from
Office Online that would be perfect but I don't know how to make it work w/
my tables in my database. This could be very complicated and I don't know
how to find the right how to manual or tutorial. Please help! Thanks Kelly

 

[John W. Vinson]

Hello,
I really need help with Access 2003. My first question is, can Access 2003
do more then just contain the data base, I'm brand new to Access and I need
to track inventory for Nutritional Services at a School District. Currently
we are using Excel, which is horrible for what we need. We need a beginning
inventory, we need forms that can take items from inventory and add them in
(for orders and receivables). All I have to learn Access is a 2000 tutorial
CD (3 pack). I've set up several tables and forms, but the CD doesn't really
get into Macros. I was trying to download an "order form" template from
Office Online that would be perfect but I don't know how to make it work w/
my tables in my database. This could be very complicated and I don't know
how to find the right how to manual or tutorial. Please help! Thanks Kelly

Access Macros are very limited. What you might need is Access Modules - they
use VBA code, as do Excel macros, so they might be more familiar.

However, you may not need much in the way of either macros or modules, at
least to start with. Data is stored in Tables; manipulated using Queries;
edited and displayed using Forms; and printed using Reports. The template's
forms and reports will have been designed on the basis of the tables in that
template - it will be more than a bit difficult to restructure them to use
your own tables!

There are a lot of good tutorials and references available, including some
inventory applications. See

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

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

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]

 

[Mike Revis]

There is an inventory control database template that comes free with Access.
You can try that for samples.

Mike

 

[Kelly]

Thanks, I did try that however it doesn't show if you can actually take items
out of inventory using a form and replace inventory using a form and if so
how to set that up. Thanks