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