Copper Pole Barbers

The queue board, walk-ins and bookings, takings by barber, loyalty cards, chair rent and stock for a barber shop.

Download 545 KB14 tables, 18 queries, 12 reports, 4 print templates and 24,801 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.

Barbers.Chair points at Chairs
Loyalty Cards.Client points at Clients
Visits.Client points at Clients
Visits.Barber points at Barbers
Visits.Card points at Loyalty Cards
Visit Lines.Visit points at Visits
Visit Lines.Service points at Services
Visit Lines.Product points at Products
Stock Deliveries.Product points at Products
Chair Rentals.Barber points at Barbers
Chair Rentals.Chair points at Chairs
Rent Charges.Rental points at Chair Rentals
Rent Lines.Charge points at Rent Charges

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. (28 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.

Chairs

The chairs in the shop, one record each. (5 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 chair as the shop calls it: Chair 1 to Chair 5. Each name is used once.
Position	Short text	Where it is in the shop, as written in a rental agreement.
Kind	Short text	Shop (worked by the shop's own barbers) or Rented (let to a self-employed barber).
Notes	Short text	Anything about the chair, such as a new pump or a basin beside it.

Barbers

Everyone who cuts hair in the shop, past and present: the employed barbers and the chair renters. (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, such as Senior Barber or Barber (chair renter).
Basis	Short text	Employed, on the shop's payroll and taking the shop's money, or Chair renter, self-employed and taking their own.
Chair	Points at Chairs	The chair they work at.
Phone	Short text	Their mobile.
E-mail	Short text	Their e-mail address.
Works	Short text	The days they usually work.
Started	Date	The day they started in the shop.
Left	Date	The day they left; empty while they are here.
Active	Yes/No	Yes while they work here; No keeps their history.
Trading Name	Short text	A chair renter's business name, printed on their agreement and rent invoices.
Address	Short text	A chair renter's address, for the agreement and invoices.
City	Short text	The town or city of that address.
Postcode	Short text	Its postcode.
Insurance Policy	Short text	The number of a chair renter's public liability insurance policy. The sample has invented ones.
Insurance Expires	Date	When that insurance runs out, so the shop can ask for the new certificate.
Receipt Note	Short text	A line printed at the foot of each receipt for their visits: for a chair renter, that the takings and the receipt are theirs and carry no VAT.

Clients

Clients who have given their name, mostly regulars and anyone with a loyalty card. A walk-in who gives only a first name is on the queue board without a record here. (975 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, called out from the queue.
Last Name	Short text, required	Their family name.
Phone	Short text	Their mobile, for bookings and a text when a free cut is due.
E-mail	Short text	Their e-mail address.
Joined	Date	The day they first gave their details.
Usual Cut	Short text	What they usually have, so any barber can do it: grade on the sides, length on top.
Marketing Consent	Yes/No	Yes if they agreed to hear from the shop. Only these go on the list of regulars not seen lately.
Notes	Short text	Anything else worth knowing.

Services

The price list: every service the shop offers. (11 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 is on the board.
Minutes	Whole number	How long it takes, for booking and for working out the queue.
Price	Currency	The price, VAT included.
Tax Rate	Number	The VAT within the price, as a fraction: 0.2 is twenty per cent. A chair renter's visits carry 0.
Stamp	Yes/No	Yes if it earns a loyalty stamp (the haircuts); a beard trim or line-up alone does not.
Active	Yes/No	No takes it off the board without losing its history.

Products

The styling and beard products the shop sells at the desk. (12 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.
Size	Short text	The size of one.
Supplier	Short text	Who it is ordered from.
Cost Price	Currency	What one costs the shop, before VAT.
Sale Price	Currency	The price at the desk, VAT included.
Tax Rate	Number	The VAT within the sale price, as a fraction.
In Stock	Whole number	How many are on the shelf now.
Reorder Level	Whole number	At or below this many, it goes on Monday's order.
Reorder Quantity	Whole number	How many to order each time.
Active	Yes/No	No for a product the shop no longer stocks.

Loyalty Cards

Each loyalty card a client has had: a stamp for each paid cut, and once there are nine, the next cut is free and the card is done. (1,426 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 number on the card: LC-00042.
Client	Points at Clients, required	Whose card it is.
Started	Date	The day of its first stamp.
Stamps	Whole number	How many stamps it has, nought to nine.
Status	Short text	Open, Due a free cut (nine stamps) or Used (the free cut has been given).
Full On	Date	The day it reached nine stamps.
Free Cut On	Date	The day the free cut was given.

Visits

The queue board: every visit, booked or walked in, past, today and to come. A visit that was paid for is also its receipt. (10,489 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 No	Short text, unique	The receipt number, given when the visit is paid for, in the order of the till, a new run each year: RCP-2026-00042. Empty until then.
Client	Points at Clients	The client's record, when they have one. Empty for a walk-in who gave only a name.
Name	Short text	The name called from the queue.
Barber	Points at Barbers, required	Who did the cut, or who it is booked with.
Kind	Short text	Walk-in or Booked.
Booked On	Date	The day a booking was made.
Booked For	Date and time	The day and time booked; empty for a walk-in.
Arrived	Date and time	When the client came through the door, or the booked time for a booking not yet kept.
Started	Date and time	When they sat in the chair.
Finished	Date and time	When they paid and left.
Status	Short text	Booked, Waiting, In chair, Done, Walked out (left before their turn), No-show or Cancelled.
Free Cut	Yes/No	Yes for the tenth cut, given free on a full loyalty card.
Card	Points at Loyalty Cards	The loyalty card the visit stamped, or the full card it used.
Net	Currency	The total less the VAT within it.
VAT	Currency	The VAT within the total: each line's rounded to the penny, then added up.
Total	Currency	What the client paid, VAT included.
Paid By	Short text	Card, Cash, or Loyalty card for a free cut with nothing else.

Visit Lines

What was done and sold in each visit: a line for each service and each product. (11,485 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.
Visit	Points at Visits, required	The visit the line belongs to.
Service	Points at Services	The service, for a service line.
Product	Points at Products	The product, for a product sold at the desk.
Item	Short text	The service or product as printed on the receipt.
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: 0.2 on the shop's chairs, 0 on a renter's chair.

Stock Deliveries

What came in from the supplier, one record per product per delivery. (74 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.
Product	Points at Products, required	What came in.
Received	Date	The day it arrived.
Quantity	Whole number	How many.
Unit Cost	Currency	What each cost, before VAT.
Invoice Number	Short text	The supplier's invoice, to match against the bill.

Chair Rentals

Each chair rental agreement, current and ended: who rents which chair, for what rent and on what terms. The Chair rental agreement prints from it. (3 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 agreement's number: CRA-2025-0002.
Barber	Points at Barbers, required	The self-employed barber renting the chair.
Chair	Points at Chairs, required	The chair rented.
Signed On	Date	The day both sides signed.
Start Date	Date	The first day of the rental.
End Date	Date	The last day, once notice has been given; empty while it runs.
Weekly Rent	Currency	The rent for a week, before VAT.
Rent Day	Short text	The day of the week the rent is due, in advance.
Deposit	Currency	The deposit paid when signing.
Notice Weeks	Whole number	How many weeks of notice either side gives to end it.
Hours	Short text	The hours the chair may be used, printed in the agreement.
Included	Long text	What the rent covers, printed in the agreement.
Insurance Cover	Currency	The least public liability cover the renter must hold.
Status	Short text	Active or Ended.

Rent Charges

The weekly chair rent invoices, one per rental per week, sent on the Friday before the week. (106 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 invoice number, a new run each year: RENT-2026-0042.
Rental	Points at Chair Rentals, required	The agreement it is charged under.
Invoice Date	Date	The day it was sent: the Friday before the week.
Week Starting	Date	The Monday of the week the rent is for.
Due On	Date	When it is due: the rent day.
Net	Currency	The rent less any loyalty credit, before VAT.
VAT	Currency	The VAT on it: each line's rounded to the penny, then added up.
Total	Currency	What is due: net and VAT together.
Paid On	Date	The day it was paid; empty while it is owed.
Paid By	Short text	Bank transfer or Cash.

Rent Lines

The lines of each rent invoice: the week's rent, and a credit for any free loyalty cuts the renter gave the week before (up to five a week; any more are credited the week after). (179 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.
Charge	Points at Rent Charges, required	The invoice the line is on.
Line	Whole number	Its place on the invoice.
Description	Short text	What it is for, as printed.
Quantity	Whole number	How many: one week, or the number of free cuts.
Unit Price	Currency	The price of one before VAT; below nought for a credit.
Tax Rate	Number	The VAT rate as a fraction: 0.2.

Next: Queries, forms, reports and print templates