Data Files samples / Takeaway

Saffron Lane Pizza and Curry

Phone, walk-in and online orders, delivery zones and drivers, the menu with sizes, extras and meal deals, and the night's takings for a takeaway.

Download 481 KB14 tables, 15 queries, 11 reports, 4 print templates and 24,720 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.

Customers.Zone points at Delivery Zones
Menu Items.Category points at Menu Categories
Recipe Lines.Menu Item points at Menu Items
Recipe Lines.Ingredient points at Ingredients
Driver Pay.Driver points at Staff
Orders.Customer points at Customers
Orders.Zone points at Delivery Zones
Orders.Driver points at Staff
Orders.Driver Pay points at Driver Pay
Order Lines.Order points at Orders
Order Lines.Menu Item points at Menu Items
Order Lines.Size points at Sizes

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

Delivery Zones

The areas the takeaway delivers to, each with its charges and the driver's fee for a drop there. Enter these first. (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, unique	The zone's name, as the order screen and the driver's sheet show it.
Areas	Short text	The postcode districts in the zone, so whoever takes an order can tell which zone an address is in.
Miles	Number	About how far the edge of the zone is from the shop.
Charge	Currency	What the customer pays for delivery to the zone.
Free Over	Currency	Orders of food and drink at or over this amount are delivered free; empty when delivery there is never free.
Minimum Order	Currency	The least food and drink delivered to the zone. Smaller orders are for collection.
Target Minutes	Whole number	The time quoted for delivery to the zone, from the order going in to the door. Delivery times by zone measures against it.
Drop Fee	Currency	What a driver is paid for each delivery to the zone, fuel included.

Customers

Everyone who has ordered by phone or online, and the regulars who come in, with where to deliver to. (1,127 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	The number they order from, which is how a phone order finds them.
E-mail	Short text	Their e-mail address, for online orders.
Address	Short text	The house or flat and street to deliver to.
Postcode	Short text	Their postcode.
Zone	Points at Delivery Zones	The delivery zone their address is in.
Delivery Notes	Short text	What the driver needs to know: which bell, round the back, no knocking, the baby is asleep.
First Order	Date	The day of their first order.
Offers	Yes/No	Yes when they have agreed to be sent offers by text or e-mail. The come-back list only shows these.

Staff

Everyone who works in the shop: the kitchen, the counter and the drivers. (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.
First Name	Short text	Their first name.
Last Name	Short text, required	Their family name.
Role	Short text	Their job: Head Chef, Curry Chef, Cook, Counter, Kitchen Porter or Driver.
Phone	Short text	A number to reach them on.
Hourly Rate	Currency	What they are paid an hour before tax; empty for drivers, who are paid per drop.
Works	Short text	The nights and lunches they usually work, as the rota on the wall has it.
Started	Date	The day they started.
Active	Yes/No	No for someone who has left. They stay for the orders and pay sheets that name them.

Sizes

The sizes a pizza comes in, with what each adds to the price and how much more of each ingredient it takes. (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, unique	The size as the menu names it.
Add to Price	Currency	Added to a pizza's menu price, which is for the smallest size.
Portion	Number	How much of the recipe the size takes: the recipe is written for the smallest, 1, and a 14 inch takes nearly twice as much.
Sort Order	Whole number	The order sizes are listed in.

Menu Categories

The sections of the menu. (9 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 section as the menu heads it.
Sort Order	Whole number	Its place on the printed menu: 1 comes first.

Menu Items

Everything that can go on an order: dishes, sides, drinks, the extras added to a dish, and the meal deals. (51 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 as the menu and the tickets name it. No two share a name.
Category	Points at Menu Categories, required	The menu section it is in.
Price	Currency	What one costs, VAT included. For a pizza, the price of the smallest size.
Sized	Yes/No	Yes for what comes in sizes: the pizzas.
VAT Rate	Number	The VAT within the price, as a fraction: 0.2 for hot food and drinks, 0 for cold food that carries none.
Diet	Short text	Marks for the menu: V for vegetarian, VG for vegan.
Spice	Whole number	How hot, from 0 (mild) to 3, shown as chillies on the menu.
Description	Short text	A line for the menu; for a meal deal, what is in it.
Available	Short text	When a deal can be had, such as Sunday to Thursday; empty for always.
Active	Yes/No	No for an item taken off the menu.

Ingredients

What the kitchen buys, with what one unit costs, so each dish has a food cost and the week's use can be costed. (49 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 ingredient as the kitchen knows it.
Unit	Short text	What its cost and the recipes count in: kg, litre or each.
Cost per Unit	Currency	What one unit costs now. Changing it changes every dish's food cost.
Supplier	Short text	Who it is bought from.
Bought As	Short text	How it comes, such as a 10 kg sack or a case of 24.

Recipe Lines

What goes into one of each item: one line per ingredient, for the smallest size of a pizza. (140 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.
Menu Item	Points at Menu Items, required	The item this line is for.
Line	Whole number	The line's place in the recipe, from 1. Every recipe needs a line 1: the costing counts the price once, on that line.
Ingredient	Points at Ingredients, required	The ingredient used.
Quantity	Number	How much one takes, in the ingredient's unit.

Driver Pay

A pay sheet for each driver for each week, Monday to Sunday. Its lines are the orders the driver delivered. (55 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 sheet's number, given in date order with a new run each year: DRV-2026-0042.
Driver	Points at Staff, required	Who it pays.
Week Beginning	Date	The Monday the week starts.
Week Ending	Date	The Sunday it ends.
Pay Date	Date	The day the money goes out: the Friday after the week ends.
Drops	Whole number	How many deliveries the driver made that week.
Drop Pay	Currency	The drop fees for those deliveries added up: what the driver is paid before any deduction.

Orders

One record per order, from the moment it is taken to the moment it is handed over. Each prints as a customer receipt, a kitchen ticket and a delivery slip. (3,752 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 as orders come in with a new run each year: ORD-2026-00042. It is on the receipt, the ticket and the slip.
Placed	Date and time	The day and time the order was taken.
Channel	Short text	How it came in: Phone, Walk-in or Online.
Method	Short text	Collection or Delivery.
Customer	Points at Customers	Who ordered; empty for someone who walked in and gave no name.
Zone	Points at Delivery Zones	The delivery zone; empty for a collection.
Driver	Points at Staff	Who took it out; empty for a collection.
Driver Pay	Points at Driver Pay	The driver's pay sheet the drop is paid on; empty until the week is over.
Due	Date and time	The time promised to the customer: the door for a delivery, the counter for a collection.
Ready	Date and time	When it came off the pass, boxed and bagged.
Out	Date and time	When the driver left with it.
Handed Over	Date and time	When the customer had it: at the door, or at the counter.
Address	Short text	Where it goes, from the customer's record unless they asked for somewhere else.
Postcode	Short text	The postcode it goes to.
Delivery Notes	Short text	What the driver needs to know for this one.
Goods	Currency	The food and drink, VAT included: the lines added up.
Delivery Charge	Currency	The zone's charge, nought for a collection or an order over the zone's free delivery amount.
Net	Currency	The total less the VAT within it.
Tax	Currency	The VAT within the total: each line's VAT and the delivery's, rounded to the penny, added up.
Total	Currency	What the customer pays: the goods and the delivery charge.
Payment	Short text	Online (paid on the website), Card (paid over the phone or at the counter) or Cash (paid at the door or the counter).
Paid	Yes/No	Yes once the money is in. A cash delivery is paid when the driver hands it over.
Status	Short text	Booked (ordered ahead, not started), Cooking, Ready, Out, Done or Cancelled.
Drop Fee	Currency	What the driver is paid for this delivery, from the zone; empty for a collection.

Order Lines

What is on each order, one line per item. A meal deal is a line at the deal's price followed by what the customer chose, at nought; an extra is a line of its own under the dish it goes on. (19,057 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 the line is on.
Line	Whole number	Its place on the order, which the ticket and the receipt keep.
Menu Item	Points at Menu Items, required	What it is.
Size	Points at Sizes	The size of a pizza; empty for anything else.
Portion	Number	How much of the recipe it takes, from its size: 1 for anything not sized.
Quantity	Whole number	How many.
Unit Price	Currency	The price of one, size included and VAT included, as it was charged. Nought for what is part of a deal.
Tax Rate	Number	The VAT rate within the price, from the item when it was sold.
Notes	Short text	What the kitchen needs to know: extra hot, no onions, well done, or which deal it is part of.

Nights

The sheet filled in at close each night: the takings by channel and by how they were paid, the VAT, and the night's wages and drivers' pay. (425 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, required, unique	The night. One sheet per night.
Weather	Short text	Dry, Rain or Cold: wet and cold nights are busier.
Orders	Whole number	How many orders went out, cancelled ones left out.
Deliveries	Whole number	How many of them were delivered.
Collections	Whole number	How many were collected.
Phone Takings	Currency	Taken on phone orders, delivery charges included.
Walk-in Takings	Currency	Taken at the counter from people who walked in.
Online Takings	Currency	Taken on the website.
Delivery Charges	Currency	The delivery charges within those takings.
VAT	Currency	The VAT within the night's takings, for the VAT return.
Card	Currency	Paid by card, at the counter or over the phone.
Cash	Currency	Paid in cash, at the counter or to the drivers.
Online Payments	Currency	Paid on the website.
Kitchen Wages	Currency	What the night's kitchen and counter shifts cost, from the rota.
Driver Pay	Currency	The drop fees earned that night.
Notes	Long text	Anything worth remembering: a driver short, the oven down, a big party order.

Next: Queries, forms, reports and print templates