Data Files samples / Workshop or maker

Granite and Grain Woodworks

Materials, bills of materials, work orders, makers' hours, quotes, orders, deliveries and VAT invoices for a small furniture workshop.

Download 230 KB19 tables, 19 queries, 11 reports, 6 print templates and 13,876 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.

Material Purchases.Supplier points at Suppliers
Materials.Supplier points at Suppliers
Purchase Lines.Purchase points at Material Purchases
Purchase Lines.Material points at Materials
Material Movements.Material points at Materials
Bill of Materials.Product points at Products
Bill of Materials.Material points at Materials
Sales Orders.Customer points at Customers
Sales Lines.Order points at Sales Orders
Sales Lines.Product points at Products
Quotes.Customer points at Customers
Quotes.Sales Order points at Sales Orders
Quote Lines.Quote points at Quotes
Quote Lines.Product points at Products
Time Sheets.Maker points at Makers
Time Sheets.Work Order points at Work Orders
Work Orders.Product points at Products
Work Orders.Maker points at Makers
Work Orders.Sales Order points at Sales Orders
Work Order Materials.Work Order points at Work Orders
Work Order Materials.Material points at Materials
Stock Movements.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. (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.
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 merchants the workshop buys its materials from. (6 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.
Supplies	Short text	What you buy from them, such as Timber or Fittings and fixings.
Contact	Short text	The person you order from, printed on the purchase order.
Phone	Short text	Their phone number.
E-mail	Short text	Where orders go.
Address	Short text	Their street address, printed on the purchase order.
City	Short text	Where they are.
Postcode	Short text	Their postcode.
Lead Days	Whole number	How many days an order usually takes to arrive, used to judge when to order.
Minimum Order	Currency	The smallest order they deliver without a charge. The buyer waits until enough is needed from them, unless work would be held up or the order has waited a fortnight.

Material Purchases

Each order placed with a supplier. The Purchase order print template prints one, with its lines. (263 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 purchase order's number, given in date order with a new run each year: PO-2026-0042. The supplier quotes it on the delivery note and invoice.
Supplier	Points at Suppliers, required	Who it was ordered from.
Ordered On	Date	The day it was placed.
Expected	Date	When the supplier said it would come.
Received On	Date	The day it arrived; empty until then.
Status	Short text	Ordered until it arrives, then Received.

Materials

Everything that goes into a product: timber, sheet materials, fittings, fixings, finishes and packing. One record per thing you buy and keep. (27 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, unique	A short code for the material, used on the bench and on purchase orders. Each code is used once.
Name	Short text, required	What it is, with its size.
Kind	Short text	Timber, Sheet, Fittings, Fixings, Finishes or Packing.
Unit	Short text	How it is counted: metre, sheet, each, pair, box, litre or roll.
Unit Cost	Currency	What one unit costs now. Change it when the supplier's price changes, then work out each product's Material Cost again.
Supplier	Points at Suppliers	Who you usually buy it from.
In Stock	Number	How much is in the workshop now.
On Order	Number	How much has been ordered and not yet arrived.
Allocated	Number	How much is set aside for work orders that are planned but not started. It goes up when a work order is planned and down when work starts and the material is taken.
Reorder Level	Number	When the free stock (in stock, plus on order, less allocated) falls to this or below, the material goes on the reorder list.
Reorder Quantity	Number	How much you usually order at a time.

Purchase Lines

What was ordered on each purchase. (428 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 Material Purchases, required	The purchase the line belongs to.
Material	Points at Materials, required	What was ordered.
Quantity	Number	How much, in the material's unit.
Unit Cost	Currency	The price of one unit on this order, kept so a later price change does not alter it.

Material Movements

Every change to a material's stock, so the In Stock figure can be traced. (3,673 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.
Material	Points at Materials, required	The material.
When	Date	The day it happened.
Kind	Short text	Received (a delivery came in), Used (taken for a work order) or Counted (the opening count, or a correction after a stock count).
Quantity	Number	How much came in (above nought) or went out (below nought).
Reference	Short text	The purchase or work order it belongs to, such as PO 12 or WO 340.

Products

What the workshop makes and sells, one record per product. (24 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, unique	A short product code. Each code is used once.
Name	Short text, required	The product as it shows on orders and invoices.
Category	Short text	Tables, Seating, Storage, Small goods or Kitchen.
Price	Currency	The price to the public before any trade discount.
Material Cost	Currency	The cost of one product's materials from its bill of materials, worked out at today's unit costs. The Costed bill of materials query shows how it is made up.
Labour Minutes	Whole number	How long one takes to make, in minutes, by a maker working at a normal pace.
Made to Order	Yes/No	Ticked for products made for each order (tables, bookcases, worktops, kitchen doors); left clear for products kept on the shelf.
In Stock	Whole number	Finished pieces on the shelf, including made-to-order pieces finished and waiting for delivery.
Stock Level	Whole number	How many to keep on the shelf beyond what is already ordered. A batch is planned when stock and work in hand fall short of it.
Batch Size	Whole number	How many are made at once.
Tax Rate	Number	The VAT rate it is sold at, as a fraction: 0.2 is twenty percent. Copied to each quote and order line when it is sold.
Active	Yes/No	Untick a product you no longer make; it stays in the old orders.

Bill of Materials

What one of each product is made from: one record per material in it. (150 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.
Material	Points at Materials, required	A material it takes.
Quantity	Number	How much of the material one product uses, in the material's unit, waste included.

Makers

The people in the workshop who make things and book their hours. (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	Workshop lead, cabinet maker, chair maker or apprentice.
Hourly Cost	Currency	What an hour of their time costs the workshop, with holiday pay and insurance.
Phone	Short text	A number to reach them.
E-mail	Short text	Their work address.
Started	Date	The day they joined.

Customers

The shops, designers and people who buy from the workshop. (246 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 business, or the person's name for a member of the public.
Kind	Short text	Shop, Designer or Public.
Contact	Short text	The person you deal with at a business.
Phone	Short text	Their phone number.
E-mail	Short text	Where invoices go.
Address	Short text	The street address for deliveries.
City	Short text	The town or city.
Postcode	Short text	The postcode.
Payment Days	Whole number	Days allowed to pay after delivery: 30 for shops, 14 or 30 for designers, nought for the public, who pay on delivery.
Trade Discount	Number	The discount on the public price, as a fraction: 0.3 is thirty percent off.

Sales Orders

Each order a customer places. (441 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.
Customer	Points at Customers, required	Who ordered.
Order Date	Date	The day the order was taken.
Delivery Due	Date	The day you promised to deliver.
Delivered On	Date	The day it was delivered; empty until then.
Status	Short text	Open, Delivered or Cancelled.
Delivery Fee	Currency	What was charged for delivery, before VAT; nought when collected.
Invoice No	Short text, unique	The VAT invoice's number, given on delivery in date order with a new run each year: INV-2026-0042. Empty until the order is delivered.
Invoice Date	Date	The day the invoice was raised, the delivery day. It is the tax point for VAT.
Net	Currency	The goods after discount and the delivery fee, before VAT.
VAT	Currency	The VAT on the invoice: each line's VAT rounded to the penny and added up, with the VAT on delivery.
Invoice Amount	Currency	What the invoice comes to: net and VAT together, set on delivery.
Invoice Due	Date	The day payment is due, the delivery day plus the customer's payment days.
Paid On	Date	The day it was paid; empty while it is owed.
Notes	Long text	Anything to remember about the order.

Sales Lines

The products on each order. (980 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 Sales Orders, required	The order the line belongs to.
Product	Points at Products, required	What was ordered.
Quantity	Whole number	How many.
Unit Price	Currency	The price of one at the time, kept so a later price change does not alter old orders.
Discount	Number	The discount given, as a fraction: 0.1 is ten percent off.
Tax Rate	Number	The VAT rate of the line, taken from the product when the order was taken.

Quotes

A price given before an order, for made-to-order work: kitchens, tables, bookcases and worktops. When the customer accepts, the order is taken and the quote points at it. The Quote print template prints one. (248 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 quote's number, in date order with a new run each year: QUO-2026-0042.
Customer	Points at Customers, required	Who it is for. A member of the public who asks for a quote is added to Customers there and then.
Quote Date	Date	The day it was sent.
Valid Until	Date	The last day its prices hold, thirty days on.
Status	Short text	Sent (waiting for an answer), Accepted, Declined, or Expired (no answer before Valid Until).
Delivery Fee	Currency	What delivery would cost, before VAT.
Net	Currency	The goods after discount and the delivery, before VAT.
VAT	Currency	The VAT on the quote, worked out as an invoice works it out.
Total	Currency	What the quote comes to with VAT.
Sales Order	Points at Sales Orders	The order it became, once accepted; empty otherwise.
Notes	Long text	What the customer asked for: the finish, the colour, anything measured on site.

Quote Lines

The products on each quote. (395 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	Points at Quotes, required	The quote the line belongs to.
Product	Points at Products, required	What is quoted for.
Quantity	Whole number	How many.
Unit Price	Currency	The price of one before VAT and discount.
Discount	Number	The trade discount, as a fraction: 0.1 is ten percent off.
Tax Rate	Number	The VAT rate of the line, from the product.

Time Sheets

The hours each maker booked to each work order, one record per maker, work order and day. (1,491 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.
Maker	Points at Makers, required	Who did the work.
Work Order	Points at Work Orders, required	What they worked on.
Worked On	Date	The day.
Hours	Number	Hours worked on it that day, in quarter hours.

Work Orders

A job to make a quantity of one product, either for a customer's order or to fill the shelf. The Works order print template prints its sheet for the bench. (574 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 works order's number, in the order work orders were raised, with a new run each year: WO-2026-0042. The makers book their hours to it.
Product	Points at Products, required	What is to be made.
Quantity	Whole number	How many.
Maker	Points at Makers	The maker the job is given to.
Sales Order	Points at Sales Orders	The order it is made for; empty for a batch made for stock.
Planned Start	Date	When work is planned to begin.
Due Date	Date	When it must be finished: two working days before the delivery for an order.
Started	Date	The day work began and the materials were taken.
Finished	Date	The day the last piece was finished.
Status	Short text	Planned, In progress, Done or Cancelled.
Standard Hours	Number	How long the job should take at a normal pace: the quantity times the product's labour minutes, in hours.
Instructions	Long text	What the maker needs to know: the customer's wishes and finish for order work, or that it is a batch for the shelf.

Work Order Materials

The materials a work order takes, copied from the product's bill of materials when the work order is planned, so a later change to the bill does not alter a job already planned. The works order sheet lists them. (3,384 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.
Work Order	Points at Work Orders, required	The work order.
Material	Points at Materials, required	A material the job takes.
Needed	Number	How much of it the whole job takes: the work order's quantity times the bill of materials.

Stock Movements

Every change to the stock of finished goods. (1,502 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.
When	Date	The day it happened.
Kind	Short text	Opening (the count the records start from), Made (a work order finished), Delivered (sent to a customer) or Adjusted (damaged or found at a count).
Quantity	Whole number	How many came in (above nought) or went out (below nought).
Reference	Short text	The work order or sales order it belongs to.

Next: Queries, forms, reports and print templates