Database Templates

Whether you need an Inventory Control, Contact Manager, or Customer Relationships Management database - we can provide you with a custom Access database design or you may be able to use our Access template databases with only slight customization.  Fully custom-designed databases can be available in a week or two at a reasonable cost. Call today if you want to see a live demo of our Access templates.

Question of the day:  What is the difference between a template database and regular a database?  The answer is there is no difference.  A template is just a database that doesn't have your data in it yet. If you don't see a database similar to your requirements then give us a call.  We have created over 400 custom database templates over the last 15 years. The majority of the template databases take between 15-50 programming hours to complete.

As time permits we'll pick a database to highlight as a case study.  This will help you understand what can be done with MS Access to automate a business's data processing requirements. Each pre-built database supports many functions in a small business or a department setting - these tend to show varied functionality and highlight our unique capabilities for improving business productivity. 

We have fully functional software template & demo versions for some of the more generic database software.  Send us an email with all your contact information and we can send you a demo copy.  We'll also need to know the version of Access you are running.

Additional templates will be added over time so bookmark this page and come back often.

Template Index:

Inventory Database for Cable & Satellite TV Installers:  $800.  We have two database templates designed for barcode equipment inventory management. The first database, highlighted in the template, manages barcoded equipment only.  The second database has capability added to manage bulk items that are not individually identified.   This application includes monitoring of material moved into and out of warehouse and stockroom locations and inventory count reconciliation. Reports are produced to identify the status and location of each piece of equipment. The software is suitable for all barcode-based tracking of items as parts, equipment assets, and supplies.

Interior Design Project Software:  Newly release Interior Design software template for $3,500.  Manage interior design projects including furniture database, furniture photographs, floors, rooms.  Analyze costs with different furniture configurations.  Quickly change furniture combinations to meet cost targets.

Contact Management Database Template:  $800.  Contact management custom software - organize contacts & communications.  Our contact template provides multiple views of contacts based on multiple classifications.  Key to the database functionality is the databases ability to provide cross classification queries with email, fax, and address label output. Call us for a preview.

Construction Project Management Template:  $900.  In our competitive world the only way to control costs on a construction job is to accurately and quickly measure the costs as they occur and compare those costs to budget estimates.  Our template database provides job and task level tracking of time expended vs. time budgeted.  Additional features allow comparison of performance by worker/supervisor within and across jobs.

Lease Contract Management:  $2500.  Do you originate leases for equipment?  If so, then this Access template may be the solution to all those spreadsheets you have been juggling and updating over the years.  Our Lease Origination & Contract Inventory software provides point and click access to all your master lease agreements, individual schedules, line items as well as all contracts and supporting documents.  Signed contracts will pop up with a click of a button.  Future cash flow for any future date appears at the click of a button.  Customized contract text can be created easily with a few clicks of the mouse.

Livestock Feed Inventory Database: $800.  Measuring and controlling costs on the farm becomes more critical year after year.  The largest cost for domesticated livestock is feed costs.  Our Feed Inventory System provides point and click analysis of feed usage and feed costs for any time period.

Custom PM Scheduling Database:  Available for a low cost of $800.
Our preventive maintenance template software makes the task of monitoring and calculating preventive maintenance schedules easier through the automatic monitoring of absolute meter readings and trend analysis.  A click of a button shows historical and planned maintenance tasks.

Subscription Manager Templates:  Access template for subscription order management was designed to manage orders where customers may subscribe for multiple flower arrangements and deliveries which typically occur each Monday.  However, our system was designed to manage most any periodicity of delivery for the order fulfillment requirements.

Airline Reservation Software System :  $5000. The Airline Reservations database template demonstrates Access's and our capabilities to handle complex database designs.

This database template handles charter reservations and has recently been expanded to include regularly scheduled flight reservations.  There is also a flight dispatch system and an automated assignment of passengers to charter flights based on departure time proximity.

Order Management Software:  Our software manages orders for a worldwide gift delivery service that specializes in a wide variety of products as well as custom orders. The specific challenge for this project was the variation of delivery addresses as well as delivery methods.  It was important for the company to find the best balance between customer orders, order transmissions and vendor delivery. An off the shelf solution did not fit their needs; they needed a completely customized order management system that is easy to use.

Asbestos Survey Software Template:  Asbestos survey software and remediation management system. Hazardous material and asbestos abatement projects have been one of the most common hazardous material cleanup projects throughout over the last two decades.  Many law suits have been filed due to damaged caused to worker and consumer exposure to asbestos material.

Work Order Database:  Service request software for installation, repair, and maintenance work orders.  Our work order case study demonstrates a complete application for handling equipment installation, service calls and billing.  The final system resulted in a user friendly, comprehensive solution to the tracking of work orders; tasking the installation, service and maintenance of equipment.


CRM MS Access Template:  Customer relationship management is a key function in most businesses.  Knowing who you customers are and being able to communicate with them on a personal timely fashion can go a long way to improving your businesses return on investment.  This case study shows how one of our clients chooses to implement CRM in their business.

Rx Assistance Plan Generation Templates:  Prescription assistance application management software. Designed for the generation & tracking of applications for assistance plans.  Prescription assistance programs vary widely across drug manufacturers.  This database templates show how we automated the management of application submission for dozens of drug manufacturers.

Custom Order Fulfillment Template:  Order Processing System Order Management Program.  We have created order fulfillment & delivery management software to route orders for custom designs on a variety of clothing including hats, tee shirts, and sweat shirts.  This database concept, with slight modification, can be extended to handle many different types of customer orders.

Document Revision & Management Template:  Custom Document Management Tools:  The US Government mandates that companies manufacturing or testing medical equipment and pharmaceuticals adhere to the strict standards of Good Laboratory Practices (GLP) and Good Manufacturing Practices.  This case study shows how we implemented document revision control and document distribution control of GLP standard operating procedures documents and associated employee training records.

HOA Software:  HOA management - community association management, home owner's association Access template example. If you are trying to management multiple condos, rental, housing, or homeowners associations - all properties can be managed with this single Office Access template software system.

Custom Personnel Agency Template:  Placement agency software, custom personnel agency management for contractors and consultants. We developed an employment agency management program to automate the analysis of revenue from consulting and agency direct placement revenues.  Control of weekly time data and associated revenues for placement agencies can be a daunting task for medium to large placement agencies.  System tracking contracts, recruiter performance & commissions. An Access 2000 template tested on Access 2007

Loan Processing Template:  Mortgage Management, Loan Processing Software & Mortgage Process Tracking MS Access Template.  Our loan processing template was design to streamline the control of original mortgage, loan consolidation processing from acquisition of the initial mortgage lead through calculation & payment of brokers' commissions after closing of the first or second mortgage note.

Pell Grant Manager Access Templates:  Management of Pell Grant Awards by educational institutions involves a great deal of man-power.  This case study demonstrates a database which aids in the management of the overall student grant function. An Access 2003 template tested on Access 2007 

Custom Document Search & Retrieval Database Templates:  Document Management Custom Document Search & Retrieval database example.  Consider the chore of tracking documents for a large international company with hundreds of corporate entities - each of which may change parent companies or names several times over the past 25 years.  This software facilitates document and file search and retrieval from online and archive storage.

Real Estate Marketing Template:  Real Estate Marketing - select property listings easily. See a software template designed to provide a sophisticated query and analysis database system with tools to select real estate property for marketing promotions.  The concept basically to be able to retrieve a select group of properties from the database and then to send letters to the property owners inquiring if they are interested in selling their property.

All of our template databases have been tested in Access 2000, 2003, 2007 & Microsoft Access 2010.