Access Database Consultant Developer Programmer

Improve

Improve

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.

Our Clients Include:

  • The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
    The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
  • The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
    The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
  • Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
    Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
  • Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database
    Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database