The difficult I do immediately, the impossible takes a little bit longer.
Data Model ~ Appointments (i.e. Salon)...

This data model was designed to handle appointments.  (Note, there only tables included in this database the balance is up to you!  Some tables contain sample data.)  To download the Data Model click here.
Data Models
Tips (Main)
Home
Templates
Restaurant Reservations
Property Management
DVD's
Jobs (or Work Orders)
Complaints
Training with Attendance
Products (Shoes of Clothing)
Tasks
Publications
Clubs (or Associations)
Purchase Order with Inventory
Hotel Bookings
Real Estate
Recipes
Grocery List Maker
Recipes with Grocery List Maker
Inspections
Parking Lot
Damage Investigations
Call Center
Access Basics
Data Modeling 101
Utter Access - Design Strategies
Naming Conventions
Modeling Human Relationships
Business Rules...
...need to be checked for conflicts
Clients...
...may be cancelled
...might want more than one Service
...will schedule appointments
Main Entities...
Clients
Appointments
...will be scheduled accross Clients and Associates
...will need to know Service (and time) availability
...might cancell an appointment
Appointments...
Services
Services...
...time for service will need to be confirmed against Clients available time
...have a cost associated with them
...have a time frame
Yep, this Form is included in this Data Model.  However, it is display purposes only, so, you will need to make it work if you want to use it.
This site uses cookies to collect data on usage. By continuing to browse this site you consent to this policy. Find out more here.