Is Access a good tool for my project?...

Blum Blum Shub

New member
Local time
Today, 10:07
Joined
Sep 11, 2003
Messages
6
Hi guys. This is a great board, I'll be reading and posting here a lot, I think.

Here's my problem:
I need a solution that will combine features of CRM software, customer support software, fault logging/reporting and also invoice customers on a monthly basis, automatically. Some of the output will need to go straight to email, some will be mail merged, probably to Word.
It might also have to link into an accounting package such as Sage.

I've looked at Act, Goldmine, Maximize and a few other off the shelf packages, and a couple of semi-bespoke things. Frankly I'm quickly facing the fact that I'm going to have to write this software myself.

I'm not a newbie with Access, but I'm sure as hell no pro either.

After all that longwinded crap, there's a simple question...

Is Access cabable of this kind of stuff?

Thanks guys,
Blum
 
Blum,

It is capable of all of the above. If you take it from the start
defining your tables, forms, reports and security, I think you'll
find plenty of knowledgable people here to help.

Wayne
 
Cool bananas :D

I've got a feeling I'll be tugging someone's leg for help on this one. Hopefully I can contribute something in return.

Take care,
Blum
 
Wayne - Glad to see you put design tables as the first thing. I strongly recommend it. I see lots of people jump into the gui design and then pull their hair out because the tables are wrong.
 
even before table sructure, clearly define the inputs, outputs required. The business rules and data types. System performance. Licencing. and then think about learning some VBA.

Basically you need some good User Req Spec.
 
Pen and paper first. THen tables. Thats how i do it anyways
 
Yes, I think today is going to be designated Pen and Paper day!

I have some ideas of what I want to achieve but I know I'm going to run into several problems along the way. If I can identify some of them before tapping a key, it would be a bonus!

Ahhh the life of a programmer. I've missed this!
Blum
 

Users who are viewing this thread

Back
Top Bottom