Marigold Hair and Beauty

Clients, the appointment book, services, commission, retail stock and gift vouchers for a salon.

Download 514 KB16 tables, 17 queries, 10 reports, 4 print templates and 34,042 invented records, dated back from 2026-10-22.

How the tables are related

A line runs from a field that points at another table's record to that table. Data Files keeps a record from pointing at one that is not there, and a query with both tables joins them by it.

Bookings.Client points at Clients
Bookings.Staff points at Staff
Booking Services.Booking points at Bookings
Booking Services.Service points at Services
Products.Supplier points at Suppliers
Product Sales.Staff points at Staff
Product Sales.Client points at Clients
Product Sales.Product points at Products
Product Sales.Receipt points at Receipts
Stock Deliveries.Supplier points at Suppliers
Stock Deliveries.Product points at Products
Gift Vouchers.Booking points at Bookings
Receipts.Booking points at Bookings
Receipt Lines.Receipt points at Receipts
Commission Statements.Staff points at Staff
Commission Lines.Statement points at Commission Statements

Start Here

The guide to this database: the everyday tasks a step at a time, each step saying which table, form, query, report or print template to open. Open its report, Start Here, to read or print it. Delete the table when you no longer need it; nothing else uses it. (26 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Order	Whole number	The order the steps are read in.
Task	Short text, required	The everyday task the step belongs to.
Step	Whole number	The step's number within its task.
What To Do	Long text	What to open and what to do there.

Business

The business's own details, in one record. Every document it prints, an invoice, a receipt, a statement or a letter, takes its name, address and payment details from here, so they are changed in one place. (1 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Name	Short text, required	The name printed at the top of every document.
Address	Short text	The street address.
City	Short text	The town or city.
Postcode	Short text	The postcode or ZIP code.
Country	Short text	The country.
Phone	Short text	The phone number customers call.
E-mail	Short text	The address customers write to.
Website	Short text	The website, if there is one.
Tax Number	Short text	The VAT or sales tax registration number, printed on invoices. The sample has a placeholder.
Company Number	Short text	The registered company number, where the business is a company. The sample has a placeholder.
Bank Details	Short text	Where customers pay by transfer: the bank, account name and number. The sample has a placeholder.
Payment Terms	Short text	The words printed under an invoice's total, such as "Payment within 30 days".
Tax Rate	Number	The usual rate of VAT or sales tax as a fraction: 0.2 is twenty percent. Lines may carry a rate of their own.
Currency	Short text	The currency the business trades in, as its three-letter code.
Document Footer	Long text	A line or two at the foot of every document: thanks, opening hours, returns policy.

Suppliers

The wholesalers the salon buys its products from. (4 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Name	Short text, required	The supplier's trading name.
Contact	Short text	The person the salon deals with there.
Phone	Short text	Their order line.
E-mail	Short text	Where orders and queries go.
Account Number	Short text	The salon's account number with the supplier, quoted when ordering.
Lead Days	Whole number	How many days an order usually takes to arrive.

Staff

One record per member of the team, past and present, with the commission each earns. (7 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
First Name	Short text	The name clients know them by.
Last Name	Short text, required	Their family name.
Role	Short text	Their job in the salon, such as Senior Stylist or Beauty Therapist.
Level	Short text	Junior, Stylist, Senior or Therapist: which price column of the service menu their clients pay.
Phone	Short text	Their mobile, for rota changes.
E-mail	Short text	Their salon e-mail address.
Works	Short text	The days they normally work.
Started	Date	The day they joined.
Left	Date	The day they left, empty while they work here.
Service Commission	Number	The share of their service takings paid as commission, 0.12 for 12 per cent. The owner takes none.
Retail Commission	Number	The share of the retail they sell paid as commission.
Active	Yes/No	Yes while they work here; No keeps their history after they leave.

Services

The service menu: every treatment the salon offers, how long it takes and what it costs at each level. (26 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Name	Short text, required, unique	The service as it appears on the menu.
Category	Short text	The heading it sits under: Cut and Finish, Colour, Treatments, Nails, Brows and Lashes, Skin and Body.
Minutes	Whole number	The time to book for it, processing included.
Junior Price	Currency	The price with the junior. Empty where the junior does not do it.
Stylist Price	Currency	The price with a stylist, and the price for beauty services.
Senior Price	Currency	The price with a senior stylist or the owner.
Patch Test	Yes/No	Yes where a skin test is needed in the six months before, such as colour and lash lifts.
Tax Rate	Number	The VAT within the price, as a fraction: 0.2 is twenty per cent. Copied onto the receipt line when the visit is paid for.
Active	Yes/No	No takes a service off the menu without losing its history.

Clients

One record per client, with what the salon needs to know before they sit down. (1,309 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
First Name	Short text	Their first name.
Last Name	Short text, required	Their family name.
Phone	Short text	Their mobile, for reminders and running-late calls.
E-mail	Short text	Their e-mail address, for booking confirmations.
Heard Of Us	Short text	How they found the salon, to see which kind of advertising brings people in.
Client Since	Date	The day they first booked.
Patch Test Date	Date	The day of their last skin test for colour or tint.
Allergies	Short text	Anything to avoid, such as latex gloves or a fragrance.
Colour Notes	Short text	The colour they have and how it is mixed, so anyone can repeat it.
Marketing Consent	Yes/No	Yes if they agreed to hear about offers. Only these clients go on the win-back list.
Notes	Long text	Anything else worth knowing.

Bookings

The appointment book: one record per appointment, past and to come. (6,635 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Client	Points at Clients, required	Who the appointment is for.
Staff	Points at Staff, required	Who it is booked with.
Start	Date and time	The day and time it starts.
Minutes	Whole number	How long it is booked for, the services added together.
Status	Short text	Booked, Completed, Cancelled or No-show.
Booked On	Date	The day the booking was made.
Booked Via	Short text	Phone, Online or In salon (rebooked at the desk).
Deposit	Currency	Taken when booking new clients and long appointments.
Deposit Refunded	Yes/No	Yes when a cancellation came with two days' notice or more and the deposit went back.
Cancelled On	Date	The day it was cancelled, for a cancelled booking.
Paid By	Short text	Card, Cash or Gift voucher, once the appointment is done.
Notes	Long text	Anything to know for this visit.

Booking Services

The services in each booking, with the price charged for each. (9,173 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Booking	Points at Bookings, required	The appointment it belongs to.
Service	Points at Services, required	The service from the menu.
Price	Currency	What was charged: the price for the stylist's level, less the new-client offer on a first visit.

Products

Everything the salon stocks: retail products sold to clients and back-bar products used in services. (38 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Name	Short text, required	The product, described plainly.
Kind	Short text	Retail (sold) or Back bar (used at the basin and in treatments).
Category	Short text	Shampoo, Colour, Nails and so on.
Supplier	Points at Suppliers	Who it is ordered from.
Size	Short text	The size of one unit.
Cost Price	Currency	What one unit costs the salon.
Sale Price	Currency	The retail price, VAT included; empty for back-bar products.
Tax Rate	Number	The VAT within the sale price, as a fraction: 0.2 is twenty per cent.
In Stock	Whole number	Units on the shelf now.
Reorder Level	Whole number	At or below this many, it goes on the next order.
Reorder Quantity	Whole number	How many to order at a time.
Active	Yes/No	No for a product no longer stocked.

Product Sales

Retail sold at the desk, one record per product per sale. (1,047 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Date	Date	The day of the sale.
Staff	Points at Staff	Who sold it, for retail commission.
Client	Points at Clients	Who bought it.
Product	Points at Products, required	What was sold.
Quantity	Whole number	How many.
Unit Price	Currency	The price of one, as charged.
Receipt	Points at Receipts	The receipt it was rung up on, with the services of the same visit.

Stock Deliveries

What came in from suppliers, one record per product per delivery. (282 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Supplier	Points at Suppliers, required	Who delivered it.
Product	Points at Products, required	What came in.
Received	Date	The day it arrived.
Quantity	Whole number	How many units.
Unit Cost	Currency	What each cost on the invoice.
Invoice Number	Short text	The supplier's invoice, to match against the bill.

Gift Vouchers

Vouchers sold, and when and where each was used. (130 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Code	Short text, required, unique	The number printed on the voucher.
Sold On	Date	The day it was bought.
Bought By	Short text	Who paid for it.
For	Short text	Who it is for.
Value	Currency	What it is worth.
Expires	Date	A year after it was sold.
Redeemed On	Date	The day it was used, empty until then.
Booking	Points at Bookings	The appointment it paid for.

Receipts

The till's record of each visit paid for at the desk, one per completed appointment. It keeps what was charged as it was printed, so a receipt printed again later says what the client was given on the day. (5,895 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Number	Short text, unique	The receipt number, given in the order receipts are taken, a new run each year: RCP-2026-00042.
Booking	Points at Bookings	The appointment paid for. The client and stylist printed on the receipt come from it.
Taken	Date and time	The day and time the payment was taken.
Net	Currency	The total less the VAT within it.
VAT	Currency	The VAT within the total: each line's VAT rounded to the penny, then added up.
Total	Currency	Everything on the receipt, VAT included: the services and any products.
Deposit Paid	Currency	The deposit taken when the appointment was booked, which comes off the bill.
Voucher	Currency	The value of a gift voucher used to pay, nought when none was.
Voucher Code	Short text	The number of the gift voucher used.
Paid Today	Currency	What the client paid at the desk: the total less the deposit and any voucher.
Paid By	Short text	How it was paid: Card, Cash, Gift voucher, or a voucher and card or cash for the rest.

Receipt Lines

What is on each receipt: a line for each service done and each product bought at the visit. (9,193 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Receipt	Points at Receipts, required	The receipt the line is on.
Kind	Short text	Service or Retail.
Item	Short text	The service or product as printed, with the size of a product and a note of the first-visit offer.
Quantity	Whole number	How many: one for a service.
Unit Price	Currency	The price of one, VAT included, as charged.
Tax Rate	Number	The VAT within the price, as a fraction, from the service or product.

Commission Statements

A statement for each person on commission for each month, made on the first of the next month and paid with the wages on the 7th. (60 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Number	Short text, unique	The statement number, a new run each year: COM-2026-0042.
Staff	Points at Staff, required	Who it is for.
Month	Short text	The month it covers, as 2026-09.
Prepared On	Date	The day it was made.
Commission Due	Currency	The commission on all its lines added up.
Paid On	Date	The day it was paid with the wages; empty until then.

Commission Lines

The lines of each commission statement: the services done by kind, and the retail sold. (216 records in the sample.)

Field	Type	What it holds
ID	AutoNumber	The number Data Files gives each record. Other tables point at a record by it.
Statement	Points at Commission Statements, required	The statement the line is on.
Line	Whole number	Its place on the statement.
Work	Short text	Which kind of work: a heading of the service menu, such as Colour, or Retail products sold.
Done	Whole number	How many services were done, or products sold.
Takings	Currency	What clients paid for them, VAT included.
Rate	Number	The commission rate for that kind of work, as a fraction.
Commission	Currency	The commission earned: each service's or sale's rounded to the penny, then added up.

Next: Queries, forms, reports and print templates