A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Point of Sale database - does it exist?



 
 
Thread Tools Display Modes
  #1  
Old March 16th, 2010, 04:27 AM posted to microsoft.public.access.tablesdbdesign
brainmush
external usenet poster
 
Posts: 1
Default Point of Sale database - does it exist?

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!!!!!
  #2  
Old March 16th, 2010, 05:07 AM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Point of Sale database - does it exist?

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=...3b11f867dbecea

....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" wrote in message
...
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!!!!!

  #3  
Old March 17th, 2010, 12:48 AM posted to microsoft.public.access.tablesdbdesign
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Point of Sale database - does it exist?

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" wrote in message
...
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!!!!!



  #4  
Old March 21st, 2010, 05:38 AM posted to microsoft.public.access.tablesdbdesign
J.Bennett
external usenet poster
 
Posts: 45
Default Point of Sale database - does it exist?

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" wrote in message
...
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!!!!!



.

  #5  
Old March 21st, 2010, 05:59 AM posted to microsoft.public.access.tablesdbdesign
J.Bennett
external usenet poster
 
Posts: 45
Default Point of Sale database - does it exist?

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" wrote in message
...
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!!!!!



.

  #6  
Old March 21st, 2010, 07:15 AM posted to microsoft.public.access.tablesdbdesign
Advanced Point of Sale(made easy)
external usenet poster
 
Posts: 1
Default Point of Sale database - does it exist?

Thanks James. Advanced Point of Sale (made easy) sounds like a good fit for
your needs. .

Advanced Point of Sale (made easy) is a complete Cash Register and Quoting /
Work Order System, It is also an Accounting, Inventory and Customer
Management system all kept up-to-date by simply using the cash register.

With the optional Credit Card Integration your credit card sales will be
more efficient and accurate, and it's free!

Advanced Point of Sale (made easy) is network ready allowing multiple
workstations to share data across a network. Multiple licenses, one per
station, are required in a network.

Please vistit our site at http://www.aposme.com and give it a try

LJ
James Enterprises of NY, Inc.


"brainmush" wrote:

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!!!!!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.