Access Database Consultant Developer Programmer

Nashville, Tennessee

Access Database Programmers Nashville, Tennessee



In Nashville we build and support databases for CSI Medical, Manning Material and Williamson Medical Center. We often come on site to perform these database services. We can also work remotely when desired.

Thank you Wikipedia:
Since 1963, Nashville has had a consolidated city-county government, which includes six smaller municipalities in a two-tier system. The city is governed by a mayor, a vice-mayor, and a 40-member Metropolitan Council; 35 of the members are elected from single-member districts, while the other five are elected at-large. Reflecting the city's position in state government, Nashville is home to the Tennessee Supreme Court's courthouse for Middle Tennessee. According to 2016 estimates from the U.S. Census Bureau, the total consolidated city-county population stood at 684,410.

Our sister company: Data-Bolt.com PHP and MySQL developers and programmers for web applications: Data-blade.com

Specifc Access database expert solutions are here

We also build Access databases in Los Angeles California

>We also build Access databases in Houston Texas

Thank you Photographer for great picture!!!



Clients
  • Food and Drug Administration
    Dynamics Edge had a contract to Train the Food and Drug Administration. When they had an Advanced Access Class to train, they called us as Expert Access Consultants to perform the training in Silver Spring, MD
  • B to B Solutions
    Partner / Subcontract to build Access, SQL Server, .NET applications for their clients: Chemical Engineering client DuPont, their staffing client Apex Systems, Their health industry client Result Performance, and their insurance client Affinity Group Underwriters in Richmond, VA
  • WSI Web Strategies
    Subcontract build Access & Web applications to Pack & Ride and Vatex and a Soccer Association. We subcontracted to WSI Web Strategies to help their clients. Both are in Richmond, Virginia
  • Virginia Association for Home Care and Hospice
    Fixed and modifed an exiting Access database for an Association. This client manages their client invoicing and payments with an Access Database. They desired to share the database from home and work, so we migrated the data tables to a MySQL database in the cloud (Data Control Servers)
  • Dominion Partners
    Dominion Partners desired an Access Guru to build an access database to manage their investment banking back office operations. They contracted us for this Access Database project.
  • Holiday Signs
    Holiday Signs need an expert Access Database consultant to revise their Customer Relationship Manager application. This is an Access database that provides at-your-fingertip pipeline data to help both the salesmen and sales managers keep track of ongoing sales leads. Metrics come out of this database to help evaluate and improve sales performance.

    We are also the PHP Developer and MySQL Consultant for Holiday signs. You may find more information about these services here: Data Bolt provides PHP and MySQL consulting
  • Greystone
    Manufacturing Firm in Toano, Virginia.

    We built a Quality tracking database that imports 1000s text files output from manufacturing machinery.

    This microsoft access database reports defects during the manufacturing process for this automotive parts manufacturer

    From Greystone website: Greystone is a global leader in the production of high volume precision machined and plated components for the automotive, aerospace, defense and industrial markets. Specializing in safety critical machining, hard chrome plating, and anodizing, we take pride in developing innovative engineering solutions to difficult problems.
  • HORWITZ, RICHARDSON & BAKER, LLC
    Chicago Law Firm that used an Access database to manage their cases. We migrated their Access tables to MySQL tables in the cloud: Our Server.
  • Routt County Alcohol Council
    The Council contacted us to upgrade their Access 97 database to the current version of Access. We have to first move the database into Access 2003, and then into Access 2019 (365). The was further complicated due to a workgroup information file protecting the Access 97 database and then advanced vba code that needed modification.

    We are frustrated that Microsoft does not provide a transparent upgrade path from Access 97 directly to Access 365 (or whatever current version of Access is out today). We are further frustrated that Access discontinues support of features such as workgroup information files, pivot tables/report, Access Data Projects. So clients are forced to contact consultants like Data Control. We realize the importance of your database and the dilemma you are in. So we try to fairly price the upgrade to the new version of Access hoping that we can get future development work from you.

    To get around the Workgroup Information File issue (the client had no documentation of this which is understandable considering the database is 20 years old and the original developer long gone), we opened a new Access 2003 database and imported all of the objects. This then allowed us to open the Access 2003 database in Access 2007 and perform the final upgrade steps.

    This particular database uses advanced VBA code and expected the data file to be in a particular position on the server. If the data file wasn't there, the reports didn't work. So we searched through the code removing this requirement. We also had to modify a few of the libraries

    Routt County Alcohol Board is a non-profit serving the city of Steam Boat in Colorado. Their database is a case management and reporting vehicle for their operations.

Here are some clients we have helped in Nashville

Client

Project Description

Williamson Medical Center

Williamson Medical Center needed to modify their existing Access Database. They needed an Access Guru to understand the complex nature of a database previously designed by an expert. This database tracks janitorial supplies and projects across this huge hospital.

From their website: Williamson Medical Center Williamson Medical Center has been a pillar of our region for over 60 years, with an impressive tradition and commitment to not only providing exceptional healthcare services to hundreds of thousands of patients, but also an overall dedication to the wellbeing of our community.

We also build expert PHP and MySQL web application solutions for the manufacturing industry. More information here: PHP and MySQL web application solutions for the health care industry

If you need your Access database converted to a web solution, we can do this as well. For example: we have built an Overall Equipment Effectiveness Access Databases and similar efficiency tracking databases for Pepsi Bottling and Clement Pappas. We have converted these applications for general use and more information is available here: Overall Equipment Effectiveness for the manufacturing industry

Central Parking System

Build Access database to track payments and receipts for parking lot company

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