Need Help w/ Dog Grooming Client/Appointment Database Design
RVer
familiarity with designing a database to do what i need ... so i'm looking
for some help putting it together.
here's what i think i need for tables:
1. Owner's Info - includes contact info, name address, phone, etc.
2. Pet's Info - includes name, breed, age, size, color, temperment, notes,
etc.
(an Owner might have 2 or 3 pets)
3. Grooming Info - includes appointment dates & grooming service details for
particular owners & pets for specific grooming appointments ... like type of
haircut, price, method of payment, tip, etc.
Maybe we should split #3 into two tables: Appointments (Dates of grooming
events, with details of price, etc.) and Services (Details of specific
haircut or service performed)?
Curently i have an Excel file containing the data, but a spreadsheet is a
spreadsheet ... and a database is a database.
I'd like to be able to track revenue, and appointments, and a trigger for a
reminder for the client's next recommended appointment in 6 weeks, etc.
I don't have much of a clue how to set up relationships of tables to make a
functional database for myself, so i'm looking for input from anyone who
might be willing to assist. And i'm not opposed to giving your dog free
baths & haircuts, if you live in southern Wisconsin.
thanx a zillion in advance for your time and expertise.
Jim Rojas
> Hello Group, ... i'm a Dog Groomer& an Access rookie with only a very basic
> familiarity with designing a database to do what i need ... so i'm looking
> for some help putting it together.
>
> here's what i think i need for tables:
>
> 1. Owner's Info - includes contact info, name address, phone, etc.
>
> 2. Pet's Info - includes name, breed, age, size, color, temperment, notes,
> etc.
> (an Owner might have 2 or 3 pets)
>
> particular owners& pets for specific grooming appointments ... like type of
> haircut, price, method of payment, tip, etc.
>
> Maybe we should split #3 into two tables: Appointments (Dates of grooming
> events, with details of price, etc.) and Services (Details of specific
> haircut or service performed)?
>
>
> Curently i have an Excel file containing the data, but a spreadsheet is a
> spreadsheet ... and a database is a database.
>
> I'd like to be able to track revenue, and appointments, and a trigger for a
> reminder for the client's next recommended appointment in 6 weeks, etc.
>
> I don't have much of a clue how to set up relationships of tables to make a
> functional database for myself, so i'm looking for input from anyone who
> might be willing to assist. And i'm not opposed to giving your dog free
>
> thanx a zillion in advance for your time and expertise.
>
>
Why don't you use Symantec Act! Contact Database or Quickbooks?
Jim Rojas
Salad
grooming, haircut, toenails. You might have individual prices for all 3
or you may have a package price.
You might want calendaring as well. Like, what are my appointments for
today? Would that be my first page/form to view and then see the detail
of a the appointment; customer, animal, services needed?
I went onto Google and entered
ms-access pet grooming database
and searched on the above phrase.
One link charges $300. Another is free. Here's the link to free. It
had 3/5 stars but 0 reviews so who knows who is rating it. It may be
old, it may be new, it may be in Access or not...who knows.
http://www.downv.com/Windows/download-Pet-Washing-and-Grooming-Database-10142144.htm
One other. I went to www.tucows.com. Here's a link.
http://www.tucows.com/preview/373899/123Pet?q=pet+grooming
Ita says "Our dog and cat grooming software is a complete software
package for your dog and cat grooming or pet supply business that is
powerful, yet simple-to-use." You can add 10 records as a demo. Cost
is $199.
Anyway, it may give you further ideas on your planned database.
Do you have the time to learn programming as well as doing your
business? That's a question you will have to ask yourself.
Salad
Reading further on the tucows site it said "123Pet dog and cat grooming
software tracks clients, pets, inventory, employees, appointments,
payroll, networking, and much more. 123Pet dog grooming and vet software
works with cash drawers, bar code scanners, receipt printers, and other
hardware, including touch screens."
If you are going to be in business for awhile you'll, overtime, get
locked into the software you use. Do you want the software you design
or perhaps someone that has done the hard work for you and may
understand the issues you face in the business as well. I'd definitely
recommend dl'ing the demo and punch in 10 records and see the
capabilities. It's free for the demo. For $200, the price seems good
for the capabilites.