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)

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.

RVer wrote:
Why don't you use Symantec Act! Contact Database or Quickbooks?

Jim Rojas

RVer wrote:
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/downloa...e-10142144.htm

One other. I went to www.tucows.com. Here's a link.
http://www.tucows.com/preview/373899...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.