Microsoft template databases will be selected from our current development pool to highlight as a case study.  This will help you understand what can be done with Access to automate a business's database processing requirements.

Some of these case studies are generic enough to be a template database that may be suitable for your requirements.  The databases that are for sale have a price included with the case study description.

Most of what we do here at Blue Claw Database Design is create custom databases for small businesses.  Rarely can a database service your full compliment of requirements.  Therefore you should consider the cost and complexity of customizing a database versus having a database custom programmed (from scratch) for your precise requirements .  Give us a call and we will be happy to guide you through your decision (410 708 1417).

Microsoft Access Templates and Access Examples:

Inventory Database for Cable & Satellite TV Installers:  $800.  We have two database examples designed for barcode equipment inventory management. The first database, highlighted in the example, 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 example 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 Example:  $800.  Contact management custom software - organize contacts & communications.  Our contact example 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 Database:  $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 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 example 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 example 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 Examples:  Access database 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 example demonstrates Access's and our capabilities to handle complex database designs.

This database example 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 Example:  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 Database:  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 Examples:  Prescription assistance application management software. Designed for the generation & tracking of applications for assistance plans.  Prescription assistance programs vary widely across drug manufacturers.  This databases show how we automated the management of application submission for dozens of drug manufacturers.

Custom Order Fulfillment Database:  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 Example: 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 Template Software:  HOA management - community association management, home owner's association Access database example. If you are trying to management multiple condos, rental, housing, or homeowners associations - all properties can be managed with this single Office Access database software system.

Custom Personnel Agency Database:  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 example tested on Access 2007

Loan Processing Database:  Mortgage Management, Loan Processing Software & Mortgage Process Tracking MS Access example.  Our loan processing example 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 Databases:  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 Databases:  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 Database:  Real Estate Marketing - select property listings easily. See a software example gd 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 databases have been tested in Access 2000, 2003, 2007 & Access 2010.