Access Update - Portfolio - Custom Database Development and Support

Home

Portfolio

Here are a few examples that represent the type and size of databases developed by Denise Dreher at Access Update. Click on the picture to see full size screen shots of sample data entry forms. Please note that the forms were designed for each client's specific monitor and may appear undersized or oversized on your computer. If you're interested in a demonstration of any of these databases contact Denise to arrange an onsite presentation.

Insurance Brokerage Firm
Medium Project: Custom design new single user database

The client needed a new database that would allow employees to quickly enter, verify, and export insurance enrollment information. Access Update designed and built a custom stand-alone database that allows for fast data entry and does not require the use of a mouse. The program checks to see if required information has been entered and logs any missing data. It then generates letters for each employee either requesting the missing information or confirming enrollment. A text file of all batch data is created for importing into a larger database.

Commercial Roofing Company
Large Project: Custom design new multi-user database

The client needed a way for Sales Staff and Customer Service to quickly locate all of the work history for each jobsite. They were currently managing data for bids, jobs, drawings, photos, customers and warranty information in a variety of formats including a proprietary accounting system, Microsoft Word, Access, and Excel. Access Update designed and built a custom database that archives all of the data into one secure multi-user Access database that is shared across the network. It imports the accounting data and assigns a project number to track related information.

Mail-Order Plant Nursery
Small Project: Troubleshoot and enhance existing database

The client was having problems with incorrect data in their database. Access Update analyzed the problem and determined the source was poorly designed tables, relationships, and data entry forms. We redesigned the database, cleaned the data, and incorporated data validation into the data entry forms. We also modified the customer form to search for and display possible alternate names and addresses to help locate duplicate records.

Plumbing & Irrigation Company
Small Project: Enhance existing database

The client wanted to create and print service tickets and invoices from within an existing customer database. Access Update added the new functions along with tables and forms to maintain data for parts, equipment, and labor. An additional section was added so the user could automatically transfer a record from contact from the Estimate table to the Contacts table when an estimate was accepted by the customer and became a job.

“I am enjoying the program. It's amazing how simple things can become with one new program.”

“I just love it - very cool. I think it will work great. Just wanted you to know I'm impressed.”

“Wow! This program is awesome! We should market it to other companies!”

“The extras you added are wonderful. Some of them we did not expect or think of ourselves. They give the database a very nice professional look.”

“I really love what you have done with the database... it is a pleasure to see something take shape the way you hoped it would. Thanks.”