Point of Sale database - does it exist?
in [Tables]
|
Prev: Help with database
Next: Printout Problem, error 2501
From: brainmush on 15 Mar 2010 23:27 I need to (very quickly) create a program that is user friendly that would be used by a small corner store to track sales/inventory/expenses/employees/etc. the main issue is it need to track every sale by the employee entering (by combo boxes) categories then choosing the product and then that would bring up the price and a quanity box. The employee would enter all the products for each sale and would get a running total for each client. Once the sale is complete it would update the inventory to subtract the quantities sold. Other ideas is to be able to have promotion prices for regular clients, pop-ups to show when inventory needs to be restocked and so on. I know there are inventory databases out there but I can't find one to for a point of sales program. Does anyone know if it exists? Is there a template out there somewhere. I started trying to create it myself but as it turns out, spending the last 3 years with a baby did nothing good for my brain and programming skills. I have very little time and fear I may need to accept defeat! PLEASE HELP!!!!!
From: Gina Whipp on 16 Mar 2010 00:07 brainmush, This is not for the faint of heart... nor is it a quickie database. I Googled it and came up with... http://www.google.com/#hl=en&source=hp&q=point+of+sale+ms+access&rlz=1W1ADRA_en&aq=f&aqi=g1&aql=&oq=&fp=a73b11f867dbecea ....none of which look free but I didn't look thru every page. (Probably with good reason, as I said not a *beginner* database.) Good Luck... Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "brainmush" <brainmush(a)discussions.microsoft.com> wrote in message news:2C3FCA5B-1D47-401D-B0CC-C3FCC12AAED2(a)microsoft.com... I need to (very quickly) create a program that is user friendly that would be used by a small corner store to track sales/inventory/expenses/employees/etc. the main issue is it need to track every sale by the employee entering (by combo boxes) categories then choosing the product and then that would bring up the price and a quanity box. The employee would enter all the products for each sale and would get a running total for each client. Once the sale is complete it would update the inventory to subtract the quantities sold. Other ideas is to be able to have promotion prices for regular clients, pop-ups to show when inventory needs to be restocked and so on. I know there are inventory databases out there but I can't find one to for a point of sales program. Does anyone know if it exists? Is there a template out there somewhere. I started trying to create it myself but as it turns out, spending the last 3 years with a baby did nothing good for my brain and programming skills. I have very little time and fear I may need to accept defeat! PLEASE HELP!!!!!
From: Al Campagna on 16 Mar 2010 19:48 brainmush, I couldn't agree with Gina more... Given your level of expertise, and time available, you should definitely look into "canned" POS software. There are tons of POS packages out on the web, from bare bones to sophisticated, and often reviewed by real users. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "brainmush" <brainmush(a)discussions.microsoft.com> wrote in message news:2C3FCA5B-1D47-401D-B0CC-C3FCC12AAED2(a)microsoft.com... >I need to (very quickly) create a program that is user friendly that would >be > used by a small corner store to track > sales/inventory/expenses/employees/etc. > the main issue is it need to track every sale by the employee entering (by > combo boxes) categories then choosing the product and then that would > bring > up the price and a quanity box. The employee would enter all the products > for each sale and would get a running total for each client. Once the > sale > is complete it would update the inventory to subtract the quantities sold. > Other ideas is to be able to have promotion prices for regular clients, > pop-ups to show when inventory needs to be restocked and so on. I know > there are inventory databases out there but I can't find one to for a > point > of sales program. Does anyone know if it exists? Is there a template out > there somewhere. I started trying to create it myself but as it turns > out, > spending the last 3 years with a baby did nothing good for my brain and > programming skills. I have very little time and fear I may need to accept > defeat! PLEASE HELP!!!!!
From: J.Bennett on 21 Mar 2010 00:38 Brainmush, My family owns a feed, farm & pet store. My parents are NOT computer literate. However, I computerized our entire operations with a point-of-sale program named "Advanced Point of Sale Made Easy". It tracks all sales for customers, has a customer database, tracks sales by employee, etc. I currenlty have it set up on 9 computers on my network. I simply have a mapped drive to the first computer with all the data. The program only cost $149.95 per copy (note that it is half priced now). (I have to buy one more copy, I guess now is the time. You can download a fully functional copy that will run for up to 30 days. I am very happy with it and currenlty operate our business, with gross sales of just under $2,000,000 per year. I track my regular customers sales, do invoicing for certain customers that we allow to charge, I run reports for customers at the end of the year, etc. I am very pleased with the program. I een provided the developer with a testimonial and it is on his front page. It's real. Visit www.APOSME.com for information on the program. James Bennett Bennett's Feed, Farm & Pet Center, Inc. www.BennettsFeed.com "Al Campagna" wrote: > brainmush, > I couldn't agree with Gina more... > Given your level of expertise, and time available, you should definitely > look into "canned" POS software. There are tons of POS packages out > on the web, from bare bones to sophisticated, and often reviewed by real > users. > -- > hth > Al Campagna > Microsoft Access MVP 2007-2009 > http://home.comcast.net/~cccsolutions/index.html > > "Find a job that you love... and you'll never work a day in your life." > > > "brainmush" <brainmush(a)discussions.microsoft.com> wrote in message > news:2C3FCA5B-1D47-401D-B0CC-C3FCC12AAED2(a)microsoft.com... > >I need to (very quickly) create a program that is user friendly that would > >be > > used by a small corner store to track > > sales/inventory/expenses/employees/etc. > > the main issue is it need to track every sale by the employee entering (by > > combo boxes) categories then choosing the product and then that would > > bring > > up the price and a quanity box. The employee would enter all the products > > for each sale and would get a running total for each client. Once the > > sale > > is complete it would update the inventory to subtract the quantities sold. > > Other ideas is to be able to have promotion prices for regular clients, > > pop-ups to show when inventory needs to be restocked and so on. I know > > there are inventory databases out there but I can't find one to for a > > point > > of sales program. Does anyone know if it exists? Is there a template out > > there somewhere. I started trying to create it myself but as it turns > > out, > > spending the last 3 years with a baby did nothing good for my brain and > > programming skills. I have very little time and fear I may need to accept > > defeat! PLEASE HELP!!!!! > > > . >
From: J.Bennett on 21 Mar 2010 00:59
Also, I run XCharge as my credit card processing. It fully integrates into APOSME. You can manually enter or use a credit card swipe (which is what I use). "J.Bennett" wrote: > Brainmush, > My family owns a feed, farm & pet store. My parents are NOT computer > literate. However, I computerized our entire operations with a point-of-sale > program named "Advanced Point of Sale Made Easy". It tracks all sales for > customers, has a customer database, tracks sales by employee, etc. I > currenlty have it set up on 9 computers on my network. I simply have a > mapped drive to the first computer with all the data. > > The program only cost $149.95 per copy (note that it is half priced now). (I > have to buy one more copy, I guess now is the time. You can download a fully > functional copy that will run for up to 30 days. I am very happy with it and > currenlty operate our business, with gross sales of just under $2,000,000 per > year. > > I track my regular customers sales, do invoicing for certain customers that > we allow to charge, I run reports for customers at the end of the year, etc. > > I am very pleased with the program. I een provided the developer with a > testimonial and it is on his front page. It's real. > > Visit www.APOSME.com for information on the program. > > James Bennett > Bennett's Feed, Farm & Pet Center, Inc. > www.BennettsFeed.com > > > "Al Campagna" wrote: > > > brainmush, > > I couldn't agree with Gina more... > > Given your level of expertise, and time available, you should definitely > > look into "canned" POS software. There are tons of POS packages out > > on the web, from bare bones to sophisticated, and often reviewed by real > > users. > > -- > > hth > > Al Campagna > > Microsoft Access MVP 2007-2009 > > http://home.comcast.net/~cccsolutions/index.html > > > > "Find a job that you love... and you'll never work a day in your life." > > > > > > "brainmush" <brainmush(a)discussions.microsoft.com> wrote in message > > news:2C3FCA5B-1D47-401D-B0CC-C3FCC12AAED2(a)microsoft.com... > > >I need to (very quickly) create a program that is user friendly that would > > >be > > > used by a small corner store to track > > > sales/inventory/expenses/employees/etc. > > > the main issue is it need to track every sale by the employee entering (by > > > combo boxes) categories then choosing the product and then that would > > > bring > > > up the price and a quanity box. The employee would enter all the products > > > for each sale and would get a running total for each client. Once the > > > sale > > > is complete it would update the inventory to subtract the quantities sold. > > > Other ideas is to be able to have promotion prices for regular clients, > > > pop-ups to show when inventory needs to be restocked and so on. I know > > > there are inventory databases out there but I can't find one to for a > > > point > > > of sales program. Does anyone know if it exists? Is there a template out > > > there somewhere. I started trying to create it myself but as it turns > > > out, > > > spending the last 3 years with a baby did nothing good for my brain and > > > programming skills. I have very little time and fear I may need to accept > > > defeat! PLEASE HELP!!!!! > > > > > > . > > |