Hazel Row Flowers

Stems and their waste, bouquets and recipes, orders and deliveries, weddings and the till for a florist.

Download 341 KB19 tables, 12 queries, 9 reports, 6 print templates and 14,006 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.

Items.Supplier points at Suppliers
Recipe Lines.Product points at Products
Recipe Lines.Item points at Items
Purchases.Supplier points at Suppliers
Purchase Lines.Purchase points at Purchases
Purchase Lines.Item points at Items
Waste.Item points at Items
Waste.Batch points at Purchase Lines
Delivery Runs.Driver points at Staff
Orders.Customer points at Customers
Orders.Taken By points at Staff
Orders.Area points at Delivery Areas
Orders.Run points at Delivery Runs
Order Lines.Order points at Orders
Order Lines.Product points at Products
Till Sales.Served By points at Staff
Till Lines.Till Sale points at Till Sales
Till Lines.Product points at Products
Weddings.Customer points at Customers
Wedding Lines.Wedding points at Weddings
Wedding Lines.Product points at Products

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

Staff

The people who work in the shop and drive the van. (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.
First Name	Short text	Their first name.
Last Name	Short text, required	Their family name.
Role	Short text	Their job: Owner and head florist, Florist, Junior florist or Delivery driver.
Phone	Short text	Their work phone.
E-mail	Short text	Their work e-mail address.
Started	Date	The day they joined.

Suppliers

Where stems and sundries are bought: the wholesale market, a grower and a sundries wholesaler. The sample's are invented. (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.
Name	Short text, required	The supplier's name.
Kind	Short text	Market, Grower or Sundries.
Address	Short text	The street address.
City	Short text	The town or city.
Postcode	Short text	The postcode.
Phone	Short text	Their phone number.
E-mail	Short text	Where orders go.
Account No	Short text	Your account or buyer number with them.
Buying Days	Short text	The days you usually buy from them.

Items

What is bought to make the flowers: each kind of stem, foliage, plant and sundry, with how long it lasts and how many are in the workroom now. (36 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 item, such as Rose, red, 50 cm. Each name is used once.
Kind	Short text	Flower, Foliage, Plant or Sundry.
Supplier	Points at Suppliers	Who you usually buy it from.
Unit	Short text	How it is bought, such as Bunch of 20.
Stems per Unit	Whole number	How many stems (or pieces) come in one unit.
Cost per Stem	Currency	What one stem cost at the last buy. The margin query uses it, so it moves with the market.
Life Days	Whole number	How many days after buying it is at its best; after that it is thrown away. Sundries last a long time.
Season	Short text	When it can be bought: All year, or the months it is in season.
In Stock	Whole number	How many stems are in the workroom now, after what has been used and thrown away.

Products

What the shop sells: bouquets, arrangements, plants, funeral tributes, wedding flowers and gifts, each with its price. (30 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 product as it is shown to customers. Each name is used once.
Code	Short text, unique	A short code for the till. Each is used once.
Kind	Short text	Bouquet, Arrangement, Plant, Gift, Funeral, Wedding, Christmas or Service.
Price	Currency	The price, VAT included, as it is shown in the shop.
Tax Rate	Number	The VAT within the price, as a fraction: 0.2 is twenty percent.
Season	Short text	When it is sold: All year, or its months.
Description	Short text	A line describing it, for the website and the order pad.
On Sale	Yes/No	Ticked while it is sold; untick it to keep it off the till without losing old sales.

Recipe Lines

What goes into each product: the stems, foliage and sundries, and how many of each. The stems to buy and the margins are worked out from these. (160 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	The product.
Line	Whole number	The order the recipe lists them in, the main flower first. The margin query counts the price once, on line 1.
Item	Points at Items, required	The stem or sundry.
Stems	Whole number	How many go in one of the product.

Purchases

Each buy at the market, from the grower or from the sundries wholesaler. (332 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 buy's number, in date order: PUR-2026-0042.
Supplier	Points at Suppliers, required	Who it was bought from.
Bought On	Date	The day.
Total	Currency	What it cost in all.

Purchase Lines

What was bought on each buy. Each line is a batch of stems with its own use-by day. (2,487 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.
Purchase	Points at Purchases, required	The buy it was part of.
Item	Points at Items, required	What was bought.
Units	Whole number	How many bunches, boxes or packs.
Unit Cost	Currency	What one unit cost that day.
Stems	Whole number	How many stems that comes to.
Use By	Date	The last day the batch is at its best: the day bought and the item's life.

Waste

Stems thrown away, past their best or damaged, logged at the morning check. (377 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.
Item	Points at Items, required	What was thrown away.
Batch	Points at Purchase Lines	The batch it came from.
When	Date	The day it was thrown away.
Stems	Whole number	How many stems.
Cost	Currency	What they had cost.
Reason	Short text	Past its best, or Damaged.

Delivery Areas

The areas the van delivers to and what each costs. (8 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 area's name. Each is used once.
Postcodes	Short text	The postcode districts it covers.
Charge	Currency	The delivery charge, VAT included.

Delivery Runs

Each morning or afternoon run of the van, with its driver. (582 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.
Run Date	Date	The day.
Slot	Short text	Morning or Afternoon.
Driver	Points at Staff	Who drives it.
Notes	Short text	Anything for the run, such as which van.

Customers

Everyone who orders: people sending flowers, the couples and families who book weddings, and businesses with a standing order. (972 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.
Company	Short text	The business, for a business customer.
Kind	Short text	Private or Business.
Address	Short text	Their own address, where the confirmation goes.
City	Short text	The town.
Postcode	Short text	The postcode.
Phone	Short text	The number to call them on.
E-mail	Short text	Their e-mail address.
Added	Date	The day they first ordered.

Orders

Every order taken by phone, online or in the shop, for delivery, collection or a funeral, and the weekly standing orders for businesses. (1,706 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 order's number, given in the order they are taken: ORD-2026-0042.
Customer	Points at Customers, required	Who ordered and paid.
Taken By	Points at Staff	Who took it.
Taken	Date and time	The day and time it was taken.
Kind	Short text	Delivery, Collection, Funeral or Contract.
Occasion	Short text	What it is for: Birthday, Sympathy, Valentine's and so on.
Due Date	Date	The day it is delivered or collected.
Slot	Short text	Morning or Afternoon.
Recipient	Short text	Who the flowers are for.
Recipient Phone	Short text	A number for the driver if no one answers.
Address	Short text	Where it goes; for a collection, the shop.
City	Short text	The town.
Postcode	Short text	The postcode.
Area	Points at Delivery Areas	The delivery area, which sets the charge.
Run	Points at Delivery Runs	The van run it goes on.
Description	Short text	What the florist is to make, in words.
Card Included	Yes/No	Ticked when a card goes with the flowers.
Card Message	Long text	The words for the card, as the customer gave them.
Card From	Short text	Who the card says it is from.
Delivery Charge	Currency	The charge for the area, VAT included; nought for a collection.
Net	Currency	The total without its VAT.
Tax	Currency	The VAT within the total: each line's worked out to the penny, and the delivery's, added up.
Total	Currency	What the customer pays: the flowers and the delivery.
Payment	Short text	How it was paid.
Paid On	Date	The day it was paid; empty for a cancelled order or a standing order not yet delivered.
Status	Short text	Booked, Made, Out for delivery, Delivered, Collected or Cancelled.

Order Lines

What is on each order. (1,853 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	Points at Orders, required	The order.
Product	Points at Products, required	What is to be made.
Quantity	Whole number	How many.
Unit Price	Currency	The price of one, VAT included, kept as it was on the day.
Tax Rate	Number	The VAT within the price, taken from the product.

Till Sales

Every sale over the counter, one record per receipt. (2,446 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's number, in time order: RCP-2026-00042.
Sold At	Date and time	The day and time.
Served By	Points at Staff	Who served.
Payment	Short text	Card or Cash.
Net	Currency	The total without its VAT.
Tax	Currency	The VAT within the total, each line's added up.
Total	Currency	What was paid.

Till Lines

What was sold on each receipt. (2,723 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.
Till Sale	Points at Till Sales, required	The receipt.
Product	Points at Products, required	What was sold.
Quantity	Whole number	How many.
Unit Price	Currency	The price of one, VAT included.
Tax Rate	Number	The VAT within the price.

Weddings

Every wedding quoted, with its booking, deposit, invoice and balance. (30 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.
Quote No	Short text, unique	The quote's number, in date order: QUO-2026-0042.
Customer	Points at Customers, required	Who the quote and invoice go to.
Couple	Short text	The couple's names.
Wedding Date	Date	The day.
Ceremony Venue	Short text	Where the ceremony is.
Reception Venue	Short text	Where the reception is.
Colours	Short text	The colours chosen.
Quoted On	Date	The day the quote was sent.
Valid Until	Date	The last day its prices hold.
Status	Short text	Quoted, Booked, Declined or Done.
Net	Currency	The total without its VAT.
Tax	Currency	The VAT within the total.
Total	Currency	The whole price of the flowers.
Deposit	Currency	The quarter paid to book.
Deposit Paid On	Date	The day it was paid.
Invoice No	Short text, unique	The invoice's number, given when the wedding is booked: INV-2026-0012.
Invoice Date	Date	The day the invoice was sent.
Balance Due On	Date	Four weeks before the wedding.
Balance Paid On	Date	The day the balance came in; empty while it is owed.
Notes	Short text	Anything to remember: allergies, a flower the couple does not want, access at the venue.

Wedding Lines

What is quoted and made for each wedding. (222 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.
Wedding	Points at Weddings, required	The wedding.
Line	Whole number	The order the lines print in.
Product	Points at Products, required	The product it is.
Description	Short text	The words on the quote, with the colours.
Quantity	Whole number	How many.
Unit Price	Currency	The price of one, VAT included.
Tax Rate	Number	The VAT within the price.

Next: Queries, forms, reports and print templates