gift
Garden Mastery Academy - Module 1: Dare to Dream
will be released to subscribers in: soon!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
permaculture forums growies critters building homesteading energy monies kitchen purity ungarbage community wilderness fiber arts art permaculture artisans regional education skip experiences global resources cider press projects digital market permies.com pie forums private forums all forums
this forum made possible by our volunteer staff, including ...
master stewards:
  • Nancy Reading
  • Carla Burke
  • John F Dean
  • Timothy Norton
  • r ransom
  • Jay Angler
  • Pearl Sutton
stewards:
  • Devaka Cooray
  • Leigh Tate
  • paul wheaton
master gardeners:
  • Christopher Weeks
gardeners:
  • M Ljin
  • thomas rubino
  • Megan Palmer

does MS Access do inventory and customer management?

 
steward & author
Posts: 45121
Location: Left Coast Canada
17727
10
art trees books chicken cooking fiber arts
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm looking for an alternative to QB that I can use in my home business.  I have up to 10 different inventory items at a time plus materials to make more.

I need to track inventory, customers (I sell mostly wholesale), material purchases, sales, and whatever else I need to track.

Any ideas if Access can do all this?

If so, is there some easy way to learn all this?
 
pollinator
Posts: 3830
Location: Massachusetts, Zone:6/7 AHS:4 GDD:3000 Rainfall:48in even Soil:SandyLoam pH6 Flat
559
2
forest garden solar
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
MS sure does that.
Use form to enter the data or just directly into the table or to a linked excel spreadsheet
You can use reports/query to view things or a linked excel spreadsheet.

You will have to setup the tables and the relationships with the tables.

There is a template called Northwind, when you open access it has everything that you described already setup.
https://support.office.com/en-us/article/featured-access-templates-e14f25e4-78b6-41de-8278-1afcfc91a9cb?ui=en-US&rs=en-US&ad=US
https://omextemplates.content.office.net/support/templates/en-us/tf01228997.accdt


 
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
MS Access is a great "programmable" database.  It can do what you need but it must be set up for your particular purpose.
 
Proudly marching to the beat of a different kettle of fish... while reading this tiny ad
permaculture bootcamp - gardening gardeners; grow the food you eat and build your own home
https://permies.com/wiki/bootcamp
reply
    Bookmark Topic Watch Topic
  • New Topic