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.

The everyday tasks of Hazel Row Flowers, a step at a time. Each step names the table, form, query, report or print template to open. Inside the database, the Start Here report holds the same steps. Every table has a form of the same name under Forms.

1. Take an order for delivery

Find the customer in the Customers form, or press New and type their name, address, phone and e-mail.
Open the Orders form and press New. Type the next Number, choose the customer in Customer and yourself in Taken By, and type when it was taken in Taken.
Choose Delivery in Kind and the Occasion, type the Due Date and Slot, the Recipient, their phone and the address, and choose the Area. Type its charge in Delivery Charge.
Type what to make in Description, and the card's words in Card Message and Card From; tick Card Included.
In the order lines below, choose each product and type the quantity and price. Type the Total, the Tax within it and the Net, how it was paid and Paid On.
Open the print template Order confirmation, choose the order, and press Save as PDF to e-mail it.

2. Get the day's deliveries out

First thing, open the Delivery Runs form and add the morning run (and the afternoon one on a busy day) with its driver. On each order going out, choose the run in Run.
Print the report Delivery sheet: the deliveries for today and tomorrow, by area.
Open the print template Gift card message and print the cards for today's orders; open Delivery note and print a note for each.
As each order is made set its Status to Made, then Out for delivery, then Delivered when the driver is back.

3. Buy at the market

The evening before, run the query Stems to buy for the next 3 days, or print the report Market list, and add what the till usually sells.
After buying, open the Purchases form and press New: type the next Number, choose the supplier and type Bought On.
In the lines below, add each item with the Units, the Unit Cost, the Stems and the Use By day (the day bought and the item's Life Days).
Add the stems to In Stock in the Items form, and type the new Cost per Stem when the price has changed.

4. Log the morning waste check

Go through the buckets. For each item past its best, open the Waste form and press New: choose the Item and the batch, type the day, the Stems and what they cost, and choose the Reason.
Take the stems off In Stock in the Items form.
On Mondays print the report Weekly waste, and run Waste by item to see what to buy less of.

5. Sell at the till

Open the Till Sales form and press New. Type the next Number, the time in Sold At, and choose yourself in Served By.
In the lines below, choose each product and type the quantity and its price. Type the Total, the Tax within it and Net, and choose Card or Cash in Payment.
Open the print template Till receipt, choose the sale, and press Print.
At closing, print the report Till takings to cash up.

6. Quote for a wedding and book it

Add the couple in the Customers form. Open the Weddings form and press New: type the next Quote No, choose the customer, and type the Couple, the Wedding Date, the venues and the Colours.
Type Quoted On and Valid Until (a month on). In the lines below, add each piece: the product, the description with the colours, the quantity and the price. Type the Total, Tax and Net.
Open the print template Wedding quote, choose the wedding and press Save as PDF to send it.
When they book, set Status to Booked, type the Deposit and Deposit Paid On, the next Invoice No, the Invoice Date and Balance Due On (four weeks before). Print the print template Wedding invoice.
Each week run the query Weddings in the next 60 days, or print Wedding balances, to see which balances are due. Type Balance Paid On when one comes in.

7. Look back over the month

Print the report Monthly orders for the orders delivered, and Till takings for the counter.
Print the report Occasion takings to see what people buy flowers for, and Product margins to see which products earn most.
Run the query Market spend by month to set what was bought against what was sold, and Deliveries by area to check the delivery charges.

Next: Tables, fields and relationships