 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / October 2007Macros in Access 2003
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 >Hello, >I really need help with Access 2003. My first question is, can Access 2003 [quoted text clipped - 8 lines] >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] There is an inventory control database template that comes free with Access. You can try that for samples. Mike > Hello, > I really need help with Access 2003. My first question is, can Access [quoted text clipped - 17 lines] > how to find the right how to manual or tutorial. Please help! Thanks > 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 > There is an inventory control database template that comes free with Access. > You can try that for samples. [quoted text clipped - 22 lines] > > how to find the right how to manual or tutorial. Please help! Thanks > > Kelly |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.