New customer management system

[MarkusPalsson]

All right Doc Man, thanks. I just wanted to know I was headed in the right direction before I dug deeper. As I said, I'm new to this.

My first objective was to investigate wether it was possible or not to realize this project within MS access. The second was to have a solid set of tables and a solid plan before going into details, to avoid spending valuable time running in the wrong direction.
I guess the first two parts are done, so details are the next stop. I'll probably return soon with some VBA related questions, but first I'll try to do a bit of research and trial and error.



Best Regards,
Markus

 

[The_Doc_Man]

I'll address the implied questions:

1. This IS possible within Access. No question. No doubt. But (there's ALWAYS a "but") you have to imagine it. We aren't in the business of writing it for you because only you know the ins and outs of your business model. But is it possible? Resoundingly yes.

2. By building tables and understanding how they relate to your business, you are building a solid plan to go with what you are trying to accomplish. By normalizing as many of us suggested, you curtailed that issue of "running in the wrong direction." You aren't done yet, and we all understand that "trial and error" bit. But when you have a specific question to ask, even just a "which of these X ways is better?" type of question, we are here.

I'll add a note here: You are building a model of your business in the microcosm that is MS Access. You are abstracting properties, values, and methodology into your computer corresponding to the real world business model that you would have used if all you had was ledger books and accountant's analysis pads. Just remember that if you ever come into a conflict between your business and your Access model - the business is always right. You NEVER let the model run your business. You only want the model to TRACK your business. Never let the tail wag the dog.