Database for Tanning Business

CRM stand for Customer Relationship Management
A template is just a generic word I'm using for a sample Access database.
This one is designed
like a simple version of Microsoft CRM. The idea is Access developers buy
my little sample database
because it's close to what they need, they then customize it to make exactly
what they need.
It took me about a month to develop the database.

Based on what you listed not exactly what you need, just a small portion for
example it tracks contact information.
However if you decide to build something yourself it would help you out.
To do your system right sounds like some work.

Did you check out "off the shelf software":
http://www.google.com/search?sourcei...nning+software

Perhaps this software might work:
http://www.abs-usa.com/solutions/app...m/default.aspx

it might handle the tanning beds and customers and a little bit else such as
tracking sales made, not
sure about inventory and some other portions of your requirement.

I'm not affliated with this company (actually I was working on a competing
product but didn't get it finished yet).

Also, quickbooks or perhaps some product by a company called "Sage" need to
be in the mix.

Otherwise I think you need to hire an Access Consultant to build your custom
solution.

--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com









"mef1217" wrote in message
...
I'm sorry but i am a newbie to all of this What is a CRM template?

"Mark Andrews" wrote:

You could start by using one of my CRM templates. I have two versions,
one
geared for Access 2003 and earlier and one geared for Access2007.
One is an "account" based CRM and one is a "contact" based CRM. I would
assume with tanning you would use more of a contact based approach (the
2007
version is setup like this, it's also the one I like better). I also
have
an Access product for donation management which has the fundamentals of a
contact based CRM but adds on donation, pledge, campaign and event
management. This product might give you some ideas. It does some nice
things like email templates, word document merging, advanced
filtering/queries, etc....

These templates are "open" source code that can then be added/changed to
work with what you want to track and functionality you need.
Some questions might be:
- Are you just trying to use it for existing customers and tracking
services
performed and billing?
- Are you trying to use it for lead management (trying to get new
customers)?
- Do you have employees and you are using the database to track their
schedules?
Lots of other possible things you could do.

Note: I am an experienced Access developer and even these
templates/products
did take some time to develop.
You might want to consider hiring someone to create at least your basic
system and then use your Access skills to tweak it a bit.
Access is not like Excel you should understand the access product, have
relational design skills and have VBA skills if you want to make a
database
that is critical in your business.

Buying a system "off the shelf" is also an option. Pros and cons each
way.

Feel free to give me a call if you need any advise. I'm wrapping up two
CRM
related client projects this weekend so my schedule might be free next
week?

My two cents,
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

"mef1217" wrote in message
...
I need to set up a database for my busiiness any Ideas? please
help!!!1

.

"mef1217" wrote in message
...
I need to set up a database for my busiiness any Ideas? please help!!!1

mùmkù*

"mef1217" a écrit dans le message de
groupe de discussion : ...
I need to set up a database for my busiiness any Ideas? please help!!!1