MarkusPalsson
New member
- Local time
- Yesterday, 23:55
- Joined
- Nov 6, 2018
- Messages
- 8
Hi all!
I have a new project in mind, but as I'm completely new to MS Access, I have a difficult time telling what can be done and what can't be done in access. So I'll describe my ideas and hopefully you can give me some pointers .
Me and my wife has a couple of pet shops and we are growing tired of using manual registers to keep track of bonus cards, mostly related to dog food brands and cat food brands. Each brand has their own bonus system, i.e. "buy 5 products, get 1 for free", or "buy 4 products, get 50% discount on the fifth" etc. So it's a lot of registers, and some of them contains hundreds of customers. It takes up time browsing through them, and it's a bothersome task to collect completed cards and report them. So now we want to design a digital system, and I thought MS access might do the trick. It has to be easy to use as all the store personel, young and old, must be able to use it with ease.
These are the requirements of the system:
- Customer mangement (add, edit, delete customers)
- Register purchases to customers
- Calculate when it's time to give a bonus
- Generate a specific type of report for each brand
I've attached some pictures showing an idea of a user interface and which tables I think I need. I would be very happy to get some input on this. Which parts of this design is simple/difficult to realize in access? What will i need to learn, and where can i find good information on those topics?
I've tried to google some information, but it's difficult to know how to build it from the ground when you get a glimpse here and there, without a solid basic understanding.
Grateful for all the help I can get!
Best Regards,
Markus
I have a new project in mind, but as I'm completely new to MS Access, I have a difficult time telling what can be done and what can't be done in access. So I'll describe my ideas and hopefully you can give me some pointers .
Me and my wife has a couple of pet shops and we are growing tired of using manual registers to keep track of bonus cards, mostly related to dog food brands and cat food brands. Each brand has their own bonus system, i.e. "buy 5 products, get 1 for free", or "buy 4 products, get 50% discount on the fifth" etc. So it's a lot of registers, and some of them contains hundreds of customers. It takes up time browsing through them, and it's a bothersome task to collect completed cards and report them. So now we want to design a digital system, and I thought MS access might do the trick. It has to be easy to use as all the store personel, young and old, must be able to use it with ease.
These are the requirements of the system:
- Customer mangement (add, edit, delete customers)
- Register purchases to customers
- Calculate when it's time to give a bonus
- Generate a specific type of report for each brand
I've attached some pictures showing an idea of a user interface and which tables I think I need. I would be very happy to get some input on this. Which parts of this design is simple/difficult to realize in access? What will i need to learn, and where can i find good information on those topics?
I've tried to google some information, but it's difficult to know how to build it from the ground when you get a glimpse here and there, without a solid basic understanding.
Grateful for all the help I can get!
Best Regards,
Markus