Improving Access databases is mostly what we do. Sure we get lots of requests to build new access databases. But we far more often get requests to improve an Access database. The original developer may have changed companies, changed jobs within a company, or is no longer in touch with the client.
It takes a lot of experience to follow behind another developer and improve an Access database. So when you are considering Access database consultants, make sure you ask them if they have experience improving Access databases created by other developers.
Why is improving an Access database (that someone else has built) more difficult than building one from scratch? Well, because of a few reasons: What did the original developer have in mind? Did they use object naming conventions to organize their tables, queries, forms and reports? Were they an advanced macro developer, or a beginner? Were they a VBA developer (that’s what we specialize in) and was their code clean, indented, well written, well commented? Did they accomplish everything with advanced queries? Did they build their data entry forms on multiple tables or single tables (the preferred methodolgy)? Were their tables in normal form? Did they use relationships between tables? Did they at least use key fields? :)
And what if by 'improving' your access database you are talking about bringing in Word, Excel or Outlook automation? You need someone advanced in these techniques. There is no good documentation (that I've ever found) describing automation. Just a hodge podge of articles scattered thoughout the internet. So you need to be able to ingest all of these articles, follow the author's techniques, and be able to apply to your situation.
How about improving your Access database into SQL Server or MySQL? A whole 'nother bag of tricks is necessary to do this? And then there's the granddaddy improvement:
Improve your Access database into a web application or mobile application (or both). Well, we have done this as well becausae we also develop in PHP, Angular, .ASP, java and java script.
Here are some clients we have helped:
Client
Location
Project Description
MatlenSilver Group ltd.
Richmond, VA
MatlenSilver Group, Inc subcontracted us to their Fortune 500 Tobacco /Food Manufacturing Philip Morris (now Altria) for Manufacturing Training Tracking in Richond, VA.
The Matlen Silver Group, Inc. provides information technology (IT) staffing services.
Altria desired to track which employees had what training in their plants and what certifications were going to expire. This Access database tracked that information and provided reports to help schedule future training of employees
Virginia Community Policing Institute
Richmond, VA
Virginia Community Policing Institute provides training material to police organization across the United States. We worked with them to build and Access database that would track which individuals received what training. This database also reminds VCPI that training is about to expire for certain individuals.
McCammon Group
Richmond, VA
build Web Application managing scheduling of attorneys, coordinating meetings
Pepsi Bottling - Tulsa
Tulsa, OK
Build Access database - Manufacturing Process Efficiency Tracker
Ball Corporation
Staunton, VA
Fix Access database for Aluminum products manufacturer. Database tracks orders and shipments. Second database request to fix quality management database.
Daily: 09:00AM to 06:00PM EST
Saturday - Sunday : Closed
email: jjaeger@datacontrolllc.com
Copyright 2020 DataControl, LLC. All Rights Reserved