Access Database Templates:
Inventory Software Access Templates
Inventory Systems. Review our custom Inventory Software. Barcode Asset Tracking & Control Microsoft Access database.
Interior Design Project Access Software Template
Management Access Templates
Construction Project Management Access Template
Lease Contract Management Software
Livestock Feed Inventory Database
Relationship Management Access Templates
Order Management Database Software for Customer Orders
Processing Pre-built Software Template
PM/Preventive Maintenance Access Template
Estate Marketing Template Database
Reservations Management Access Template Database
Asbestos Survey Project Management Access Templates
Process Management Access Templates
Student Loan/Grant Management Access Templates
Personnel Agency Access Template Database
Rx/Prescription Assistance Plan Management Database Template
Subscription Order Management Database Template
Document Management Access Templates
Work Order Template Database
Work Order Template: Is the management of work orders critical to your business? If your business involves the installation and service of equipment then this database may be perfect for you. Do you have billable and non-billable service calls, warranty vs. non-warranty equipment? If you have spring and fall maintenance or shutdown/startup contracts then this database fits your business exactly.
We were recently contracted to develop a comprehensive work order software template database. The overall goal of the work order template database was to provide an easy to use, complete solution to the management of work orders related to the installation, service and maintenance of customer equipment.
Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. Generally, we recommend a limit of 10 to 15 users.
We create databases large and small. Some of our databases help run entire small businesses. We also handle unique businesses such as flyrod manufacturing, cheese making, marina management, and cable tv inventory.
Following the work order software screen shots below, we discuss the key features of the work order software system.
To see a full-sized view of any work order form click the image. A new screen will open showing the image in full size with further discussion.
Our standard interface for databases of this size is the tabbed interface. This provides one click movement to most all of the database functions and is the easiest layout for user training.
Below is the opening introduction screen of the work order database entry screen:
When a customer calls with a service issue the user goes to the New Work Order form and enters the details about the service call. During this process the user may jump to the Schedule to review the work load schedule (see below for details about this function).
The Clients tab of our work order software provides a simple interface to review and enter all aspects of a customer's account. Note on the lower right of the screen the Annual Service work order option. In this database customers may sign up for contract annual service on their equipment. This service occurs in the spring and fall of each year. Note also that start of billing may be different than actual contract start season and year. This provides the user with flexibility for custom situations such as price negotiation on new systems.
Nearly all businesses have prospective clients. The screen below allows the user to manage prospects including notes and the ability to move a prospect to the Client table with a click of a button.
Review and management of individual maintenance work orders is handled on the Manage WOs tab. When a work order comes back from the field the user enters the results of the work order as well as any equipment or materials used.
One of the most powerful features of our work order database is the ability to view a calendar of scheduled work orders. The initial high-level view is shown below. There are a total of 4 levels to the schedule view: Calendar Level, Level One, Level Two, and Level Three. Each level shows more detailed information that the level above it. When you click on the image below to see the full size screen you'll see that the calendar has days going across the top and service time slots going down the left side. Each cell will be blank, contain a single name, or contain a single name with a number in parenthesis following the name. When there is a number in parenthesis this indicates that there is more than one work order scheduled for this day and time slot. In the next screen image (below) you'll see how the user can simple view the details of that time slot.
Clicking on any date/time slot cell will pop up a detailed listing showing each customer scheduled at that time and on that date, and the work order number for each. See example below...
Clicking on any date/time slot cell will popup a detailed listing showing each customer scheduled at that time and on that date, and the work order number for each.
The Level One radio button changes the display to show a summary of work orders by zip code, city, date and count of work orders. This display is sortable on any column by right clicking and selecting either ascending or descending sort option. Further below are finer levels of detail with level two and three radio buttons.
Level two view:
Level two show further detail by listing the schedule time of work orders. This display is often used to identify schedule opening and schedule conflicts for a particular maintenance team.
Level three view:
Level three provides the most detail view of the word order information - showing each individual work order including the customer's name: Dynamic flexible screen aid in management of tasks in our work order template.
Contact us today to get a quote on your Work Order Software or Work Order template database.
Get a free quote for your custom work order template software today! Contact us