MS Access Work Order Database for Service and Maintenance Teams

A service call starts simple: a customer reports a problem, someone needs to go, and someone later needs to know what was done and what it cost. Spreadsheets, whiteboards, and email threads lose that trail. The MS Access work order database in this download is a desktop application for that stretch of the job: from the request, through labor and parts, to a printed work order sheet the customer can sign.

The file is industry-neutral. Repair shops, HVAC and plumbing contractors, IT support teams, facilities desks, and internal maintenance groups can all run it. A left-hand navigation bar stays in view. Every screen reads from the same customers, assets, and technicians, so a change in Settings shows up on the dashboard, the job form, and the reports. The download is a Microsoft Access .accdb with fictional demo data you remove before going live.

Preview the Access screens from the download. Click or swipe through the dashboard, list, job form, labor and parts, customers, assets, reports, and Settings.

It is a Microsoft Access application that records a request for work (repair, maintenance visit, inspection, or installation) and follows that job until it is finished. It keeps these jobs in one place:

Use this file if you receive requests, assign people, record what was done, and need searchable history afterwards. You need Microsoft Access 2016 or later, or Microsoft 365 Access on Windows. Typical users:

If you later outgrow a single .accdb, the usual next step is the same Access forms with tables moved to SQL Server, or a front-end / back-end split on a small office network. That is a separate project, not a rebuild of the screens.

Open the application and you land on the dashboard. Five cards show live counts: New (not yet approved), In Progress, On Hold, Overdue (due date before today and not Completed or Cancelled), and Completed this month. The counts are global. They ignore list filters, so the number on a card matches the whole file.

Click a card to jump to that filtered list. Below the cards are buttons for every area of the app, a short start guide, and Contact support. Contact support opens a small popup with the website, phone, and email. Those links open only when you click them.

The list is the daily queue. Search covers work order number, title, customer name, asset code, serial number, and reported problem text. Filters cover status (including Open, meaning anything not finished), priority, customer, assigned technician including Unassigned, and opened-date range. Tick Overdue only or Show archived. Reset filters clears the screen in one click. A count line states how many records the current filters show, for example Showing 7 of 31 (filtered).

OVERDUE is written in words, in red, with the number of days, so it does not rely on color alone. Duplicate as new copies customer, site, equipment, and problem into a new job for a repeat visit. Print this list prints exactly the filtered view, with the active filters stated on the report. Blue underlined fields are links. The selected row is highlighted in light yellow.

Each job gets an automatic number such as WO-2026-00024 when you first save, so a cancelled new form never wastes a number. Numbering restarts each calendar year. You can change the WO prefix in Settings.

The Overview tab holds title, customer, optional service location, optional asset, requested by, assigned technician, opened / requested / scheduled / due dates, priority (Low, Normal, High, Urgent), quote or external reference, reported problem, diagnosis, work performed, customer-visible notes (print on the sheet), and internal notes (never print on customer output). Required fields are marked with an asterisk.

Location and asset must belong to the selected customer. The due date cannot be before the opened date. Archived customers or technicians cannot be chosen for new work. If you change the customer on a job that already has labor or parts, the app asks you to confirm and records the correction as a note.

Statuses change through Change status, which only offers steps allowed from the current status:

Cancelling requires a reason. Completing requires a completion date that is not in the future and not before the job was opened, plus either completion notes or an explicit No additional notes tick. Completed and Cancelled jobs are read-only. Reopen copies the previous completion details into history first, so nothing is lost.

The Labor tab records date, technician, description, hours, cost rate, billable rate, and whether the line is billable. Hours must be more than zero and no more than a configurable maximum (24 by default).

The Materials tab records date, description, optional part number, quantity, unit cost, and unit price. The app does not track stock levels. Negative amounts are allowed only on lines marked as a credit adjustment.

Cost is hours times cost rate, or quantity times unit cost. Potential charge is hours times billable rate (zero if not billable), or quantity times unit price. Each line rounds to cents. A blank rate is not entered, never zero. If any line is missing a rate, the job total is left blank and flagged incomplete, while a priced-lines-only subtotal is still shown and labelled. Enter 0 when a rate really is zero, for example warranty work.

Notes have a type (Internal, Customer-facing, or Status update), an author, and a timestamp. Once saved they cannot be edited. Only Customer-facing notes appear on the printed work order sheet.

Status history is written automatically for every creation, change, and reopen: old status, new status, date and time, reason, and the Windows user name. Attachments store links to files or web pages (photos, quotes, manuals, signed forms) without storing the file in the database. If a file has moved, you get a file-not-found message. Nothing opens automatically.

Customers get an automatic code such as CUS-0001. Only the name is required. If a new name, email, or phone looks like an existing record, you are asked before saving. Service locations can hold access instructions and a site contact. Archive, do not delete: archived customers disappear from new work orders, but every past job stays intact. Print history produces a full service history report for that customer.

An asset record holds code, type, manufacturer, model, serial number, install date, and warranty expiry. Warranty dates are flagged, not decided: the screen tells you whether the date has passed or falls within the next 30 days. The asset screen shows complete work order history, newest first, and can start a new job with customer and site filled in.

The report menu opens print preview. Use the Access ribbon to print or save a PDF. Every report prints its title, generated date and time, the filters used, and page numbers.

Settings holds organization name (dashboard and every report), money format (display only, no currency conversion), report footer, maximum labor hours, work order prefix, default attachment folder, and priority labels. Demo data can be loaded into an empty database. Remove demo data deletes only records created by the demo loader. If you have added your own records that depend on demo records, it stops, explains why, and deletes nothing.

The free file is a working starter for a service desk on one PC. If you need extra fields, manager sign-off before work starts, quotes and invoices, preventive maintenance schedules, a multi-user split, or SQL Server behind the same forms, that is custom Access work. We scope it as a fixed project after a short review of your current lists and pain points.