Data Files samples / Repair shop

Ironbridge Repairs

Jobs, devices, quotes, parts, invoices, warranties and payments for a shop that mends phones, tablets, laptops and small appliances.

Download 455 KB16 tables, 20 queries, 9 reports, 6 print templates and 20,564 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.Account points at Accounts
Parts.Supplier points at Suppliers
Devices.Customer points at Customers
Jobs.Device points at Devices
Jobs.Technician points at Staff
Jobs.Warranty Of points at Jobs
Part Orders.Supplier points at Suppliers
Part Orders.Part points at Parts
Part Orders.Job points at Jobs
Job Lines.Job points at Jobs
Job Lines.Invoice points at Invoices
Job Lines.Part points at Parts
Quotes.Job points at Jobs
Quote Lines.Quote points at Quotes
Invoices.Job points at Jobs
Invoices.Account points at Accounts
Warranties.Job points at Jobs
Payments.Job points at Jobs

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

Accounts

The businesses that have an account with the shop: their staff bring work in, the shop invoices the business, and the business pays by bank transfer within its payment days. (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 business's name, printed on its invoices and statement. Each name is used once.
Contact	Short text	The person who looks after the account there, printed on the statement.
Phone	Short text	The business's main number.
E-mail	Short text	Where invoices and statements are sent.
Address	Short text	The street address, printed on the statement.
City	Short text	The town or city.
Postcode	Short text	The postcode.
Payment Days	Whole number	How many days after the invoice date payment is due: 30 means thirty days.
Credit Limit	Currency	The most the business may owe at once before the counter asks for payment first.
Opened	Date	The day the account was opened.

Customers

One record for each person who brings work in. Someone who brings work for a business on account is linked to that account; everyone else pays at the counter. (1,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.
First Name	Short text	The customer's first name.
Last Name	Short text, required	The family name. Needed for every customer.
Account	Points at Accounts	The business account the person brings work in for. Empty for members of the public.
Phone	Short text	The number the shop rings or texts when the device is ready.
E-mail	Short text	Where receipts and reminders go, when the customer gave one.
Address	Short text	The street address, used for invoices and for home visits.
City	Short text	The town or city.
Postcode	Short text	The postcode.
Contact By	Short text	How the customer wants to hear that the job is ready: Text message, Phone call or E-mail.
Joined	Date	The day the customer first brought something in.

Staff

The people at the shop: the technicians who take jobs and the counter assistant. (4 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	First name.
Last Name	Short text, required	Family name.
Role	Short text	Senior Technician, Technician or Counter Assistant.
Skills	Short text	What each person is best at, so the counter books jobs to the right bench.
Phone	Short text	Work mobile.
E-mail	Short text	Work e-mail address.
Started	Date	The day they joined the shop.
Active	Yes/No	No once someone has left, so they stop appearing in lists of who can take a job.

Suppliers

The firms parts are bought from. (4 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.
Contact	Short text	The person the shop deals with there.
Phone	Short text	Their trade counter number.
E-mail	Short text	Where orders are sent.
Supplies	Short text	What the shop buys from them.
Lead Days	Whole number	How many working days an order usually takes to arrive, used to set the expected date.
Our Account	Short text	The shop's account reference with the supplier (an invented reference here).

Parts

Every part the shop fits, whether kept on the shelf or ordered in for each job. (34 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	The shop's own code for the part, printed on the bin label.
Name	Short text, required	What the part is, in plain words. It is copied onto the job line, quote and invoice.
Fits	Short text	The kind of device it is for: Phone, Tablet, Laptop or an appliance.
Supplier	Points at Suppliers	Who it is bought from.
Cost	Currency	What one costs the shop, without VAT.
Price	Currency	What one is charged at on a job, VAT included.
In Stock	Whole number	How many are on the shelf now, including any already set aside for a job.
Reorder Level	Whole number	When stock falls to this number the part is ordered again.
Reorder Quantity	Whole number	How many to order at a time.
Stocked	Yes/No	Yes for parts kept on the shelf. No for parts ordered in for each job, such as main boards and model-specific keyboards.
Bin	Short text	Where it is kept on the parts wall.

Devices

Each device a customer has brought in. One customer can have several, and a device that comes back keeps its record, so its history is in one place. (2,030 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 owns it, or who brought it in for their business.
Kind	Short text	Phone, Tablet, Laptop, Coffee machine, Vacuum cleaner, Food mixer or Sewing machine.
Make	Short text	The maker's name (invented makes in this sample).
Model	Short text	The model name or number.
Serial	Short text	The serial number, checked when the device is handed back.
Colour	Short text	Its colour, which helps find it on the shelf.

Jobs

One record for each repair, from booking in to collection. The Booking-in receipt and the Collection receipt print from it. (2,424 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 job number on the ticket, given in the order jobs are booked in, a new run each year: JOB-2026-0042.
Device	Points at Devices, required	The device being repaired, and through it the customer.
Technician	Points at Staff	Who the job is booked to.
Booked In	Date	The day the device was handed in.
Fault	Short text	The fault as the customer described it at the counter. A warranty return names the first job.
Left With It	Short text	Anything left with the device, such as a charger, case or water tank.
Promised	Date	The day the customer was told it would be ready.
Status	Short text	Booked in, Diagnosing, Awaiting approval, Awaiting parts, Repairing, Ready, Collected or Unrepairable.
Quote	Currency	The price given for the repair, VAT included. Fixed-price jobs such as screens are quoted at the counter; others after diagnosis, with a written quote in Quotes.
Quoted On	Date	The day the quote was given.
Quote Approved	Yes/No	Yes once the customer has agreed to the quote.
Deposit	Currency	Money taken up front when a part has to be ordered in.
Outcome	Short text	How the job ended: Repaired, Quote declined or Beyond economic repair.
Charge	Currency	What the job finally costs the customer, VAT included: the total of its lines. Nothing for a device that cannot be repaired ("no fix, no fee") or a warranty return.
Finished	Date	The day the work was done and the customer could be told. The invoice is dated that day.
Collected	Date	The day the customer took the device away.
Paid	Yes/No	Yes once everything charged has been paid.
Warranty Until	Date	The last day of the 90-day warranty on the repair, printed on its certificate.
Warranty Of	Points at Jobs	For a warranty return, the first job it came back from.
Notes	Long text	Anything else the counter or the bench needs to know, such as reminders sent.

Part Orders

Parts ordered from suppliers: stock to refill the shelf, or one part for one job. (747 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.
Supplier	Points at Suppliers, required	Who the order went to.
Part	Points at Parts, required	The part ordered.
Job	Points at Jobs	The job the part is for, when it was ordered for one (its record number). Empty for shelf stock.
Quantity	Whole number	How many were ordered.
Unit Cost	Currency	The price paid for each, without VAT.
Ordered On	Date	The day the order was placed.
Expected	Date	The day the supplier said it would arrive.
Received On	Date	The day it actually arrived. Empty while it is still on its way.
Status	Short text	On order or Received.

Job Lines

The parts and labour on each job, one line each, at the price charged with VAT included. They are the lines of the job's invoice and its collection receipt. (4,894 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.
Job	Points at Jobs, required	The job the line belongs to.
Invoice	Points at Invoices	The invoice the line is on, once the job is invoiced. Empty before then, and on jobs that cost nothing.
Kind	Short text	Part or Labour.
Part	Points at Parts	The part fitted or waiting to be fitted. Empty on a labour line.
Description	Short text	What the line is: the part's name, or the work done, as the invoice prints it.
Quantity	Number	How many parts, or for labour the hours: 0.75 is three quarters of an hour.
Unit Price	Currency	The price of one part or one hour, VAT included (nothing on a warranty return or a check that found no fix).
Tax Rate	Number	The VAT rate inside the price, as a fraction: 0.2 is twenty percent. Taken from the Business record when the line is made.
Done On	Date	The day the part was fitted or the work done. Empty while the job is waiting for it.

Quotes

The written quotes given after a device has been diagnosed, with the price, VAT included, and whether the customer said yes. The Quote print template prints from it. (606 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, a new run each year: QUO-2026-0042.
Job	Points at Jobs, required	The job it is for.
Quoted On	Date	The day it was given.
Valid Until	Date	The last day the price holds: thirty days from the quote.
Net	Currency	The total without VAT.
Tax	Currency	The VAT inside the total, worked out line by line.
Total	Currency	The price the customer is asked to pay, VAT included.
Answer	Short text	Accepted or Declined; empty while the customer has not answered.
Answered On	Date	The day the customer answered.

Quote Lines

The parts and labour on each quote. (1,169 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.
Kind	Short text	Part or Labour.
Description	Short text	The part, or the work to be done.
Quantity	Number	How many parts, or for labour the hours.
Unit Price	Currency	The price of one part or one hour, VAT included.
Tax Rate	Number	The VAT rate inside the price, as a fraction.

Invoices

An invoice for every job that costs something, raised the day the work is finished. It lists the job's lines, the VAT inside them, any deposit already paid and the balance. Members of the public pay it on collection; businesses on account pay it within their payment days. (2,272 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's number, given in date order and once only, a new run each year: INV-2026-0042.
Job	Points at Jobs, required	The job invoiced.
Account	Points at Accounts	The business account billed, for work brought in on account. Empty for members of the public.
Invoice Date	Date	The day it was raised, the day the work was finished. It is the tax point for VAT.
Due Date	Date	When payment is due: the invoice date for the public (pay on collection), or that date and the account's payment days.
Net	Currency	The total without VAT.
Tax	Currency	The VAT inside the total: each line's VAT rounded to the penny, then added up, as the invoice prints it.
Total	Currency	What the invoice comes to, VAT included. The same as the job's Charge.
Deposit	Currency	The deposit already paid against the job, taken off the total.
Balance	Currency	What was left to pay when the invoice was raised: the total less the deposit.
Paid On	Date	The day the balance was paid; empty while it is owed.

Warranties

A 90-day warranty certificate for every job repaired (not for a warranty return, which is covered by the first one). The Warranty certificate print template prints from it. (2,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.
Number	Short text, unique	The certificate's number, in date order, a new run each year: WTY-2026-0042.
Job	Points at Jobs, required	The job whose repair it covers. The last day of cover is the job's Warranty Until.
Issued	Date	The day the repair was finished and the certificate given.
Covers	Short text	What it covers, in words: the part fitted and the work done.

Payments

Every payment taken, each against its job, each with its own receipt number. (2,511 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 number, in date order, a new run each year: RCP-2026-0042.
Job	Points at Jobs, required	The job paid for.
Paid On	Date	The day the money came in.
Amount	Currency	How much.
Method	Short text	Card, Cash or Bank transfer.
Kind	Short text	Deposit, On collection, or On account for a business paying its invoice.

Next: Queries, forms, reports and print templates