heirloomoriginals Posted January 11, 2009 Share Posted January 11, 2009 I was looking around my computer the other day and found MS Access. It can control inventory, but I wasn't sure how to use it all. Are there tutorials or something available?Thanks,Steph Quote Link to comment Share on other sites More sharing options...
Suzanne Posted January 11, 2009 Share Posted January 11, 2009 Here's a link for microsoft training:http://office.microsoft.com/en-us/training/HA102744471033.aspxIf you aren't using an accounting program for your bookkeeping, I'd use that. Otherwise I'd recommend creating a spreadsheet for your inventory in Excel. It would be alot easier unless you already are familiar with Access. Access is a database and a little more complicated for new users. Quote Link to comment Share on other sites More sharing options...
coconut Posted January 11, 2009 Share Posted January 11, 2009 Access comes with a built in database called Northwinds. You can make a copy of that and play with it. You can also go to Microsoft's site and download a lot of templates. It takes a lot to learn Access and it is not for everyone. Quote Link to comment Share on other sites More sharing options...
heirloomoriginals Posted January 11, 2009 Author Share Posted January 11, 2009 Okay, then are there links for excel? I would like to get soap maker to keep track of my inventory, but I need to save a bit of money for it!Steph Quote Link to comment Share on other sites More sharing options...
Suzanne Posted January 12, 2009 Share Posted January 12, 2009 Yes, do a search at the microsoft website for Excel. If you are using Excel 2007 include the "2007" in your search. Quote Link to comment Share on other sites More sharing options...
LaVida Posted January 30, 2009 Share Posted January 30, 2009 Ok, I was so excited about MS Access until I read this thread thoroughly. I thought about buying Quicken or Quickbooks, but putting all that $ out... Ouch! I wanted to buy MS Publisher and Excel then I saw Access so I was just going to buy the entire MS PRo... but again the money and how much and I going to use everything else?I use Excel at the end of the year....I might create a new form on Excel to simplify it this year( and start at the beginning of the year and as I go along) Quote Link to comment Share on other sites More sharing options...
Blest2BAmerican Posted January 30, 2009 Share Posted January 30, 2009 I took a 10-hour class for Access and the instructor told us that if we didn't use it that we would forget how to use it within a week. Well, she was currect, I forgot how to use it. It's a good program but can be complicated. Quote Link to comment Share on other sites More sharing options...
Tess Posted January 31, 2009 Share Posted January 31, 2009 I took a 10-hour class for Access and the instructor told us that if we didn't use it that we would forget how to use it within a week. Well, she was currect, I forgot how to use it. It's a good program but can be complicated.I have access but never opened it lol. I did spend the extra $$ for quickbooks, and I have to say it is completely worth it. Heck get an older version. I use Pro 2007 and it makes day to day paper work soooo easy.Would access control inventory? QB can control my ready to sell inventory, but not my oils and wax ect.ect. Quote Link to comment Share on other sites More sharing options...
Crafty1 Posted February 1, 2009 Share Posted February 1, 2009 I have access but never opened it lol. I did spend the extra $$ for quickbooks, and I have to say it is completely worth it. Heck get an older version. I use Pro 2007 and it makes day to day paper work soooo easy.Would access control inventory? QB can control my ready to sell inventory, but not my oils and wax ect.ect.I use QB too, currently the 2008. I have not figured out a way for it to manage supplies, however, i recall someone posting how they managed to manipulate it to do what they wanted. not sure if it was this board or the old CT Quote Link to comment Share on other sites More sharing options...
LaVida Posted February 1, 2009 Share Posted February 1, 2009 My tax preparer suggested Quicken or just to use Excel. He said Access is very complicated and wouldn't be the program for my business (especially if I have to learn the entire program)... Quote Link to comment Share on other sites More sharing options...
Peachdream Posted February 1, 2009 Share Posted February 1, 2009 I use Access at work a lot but we got office 2007 at home and it looks like I need to relearn access again from scratch,it looks totally different....so I would go for excel, it really has a lot of features and a lot of my accountant friends use it alongside their various other programs. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.