How Partnership Works

  • 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
  • Epitome Systems
    Network Engineering Firm in Columbia, Maryland.

    They subcontracted us to Fix an Access database for determining hospital emergency room time differentials for their client Bon Secours in Baltimore, MD.

    This Access database was developed to track efficiency of the emergency room operation at Hospitals for Bon Secours. The various stages of a patient's visit are tracked and the minutes recorded for moving through each stage of the emergency room visit.

    This database uses extensive Forms that have built to provide the quickest data entry possible for the user.
  • UpTime Solutions Professional Services Group
    Network Engineering Firm in Richmond, Virginia.

    This is a Quality tracking and improvement Access database for a manufacturing firm: Greystone in Toano, VA (near Westpoint and Williamsburg).

    This application receives multiple excel files throughout the day that are produced from quality control machiney in the plant. The excel files are imported to the Access database automatically.

    The Access database scrolls through the excel files, parsing out the relevant information from the excel file and appends the relevant data points to a table that is then used to run monthly and quarterly quality control reports.

    The data is pertinent to the automobile manufacturing process and determines which production batches should or should not be accepted for Greystones automobile manufacturing clients.

    We built this database through our strategic partner: Uptime Solutions, a premier network integration and engineering firm in Richmond, VA and Tampa, FL.
  • Ritchie & Associates
    Ritchie is a management consulting firm headquartered outside of Los Angeles, California. They consult with Fortune 500 firm Meadwestvaco (now WestRock). They advised the paper and packaging firm to build an historical demand based Access Database. It incorporated not only ERP (SAP) sourced historical demand, but also provided advanced logistic support to this Paper and packaging corporation.

    This Access database determined optimim supply levels in plants and warehouses throughout the US including Maine, North Carolina, Ohio, California, Texas, Colorado, Washington, Oregon, and Michigan.
  • Sherman Howard
    Partner to build Access databases for their Communications client Verizon Wireless in Denver Colorado.

    This is a land use management for Verizon, tracking all of the land the wireless company owns.
  • Networking Technologies and Solutions
    Network Engineers in Richmond, Virginia. NTS has subcontracted us many times to build Access & SQL server databases to the Virginia Lottery, the Virginia Beach Fire Department, Townes Engineering, EHS Laboratories and more.

    For the Lottery, we've built machine maintenance tracking databases and number tracking databases (historical record of the numbers that won)

    For the Virginia Beach Fire department, we built a Microsoft Access truck inventory database.

    For Townes Engineering, we modified their website

    For EHS Laboratories we also modified their website
  • Strategic Technology Systems
    An Access database with a SQL Server back end was already in place at CeMark, STS's client. We were asked to migrate the data file to a new version of SQL Server and modify the existing Access database with a bunch of punch list items.
  • Convergent Business Solutions LLC
    Convergent is a consulting firm in Richmond, Virginia. We partnered to build an Access database for their Retirement Home client: Virginia Baptist Homes, a retirement community.

    We modified this existing Access database for the IT manager of VA Baptist Homes. The database receives daily text files from the retirement home's phone systems (6 geographic retirement home locations). The 6 text files are imported, staged, scrubbed and processed into consolidated, individual invoices for the members of the retirement community. The receive monthly bills for the phone calls they make / receive.

    We provided the Microsoft Access Database expertise for this project
  • Sycom Technologies
    Subcontract to build Access databases for their clients Fire Life Safety America (Mechanical Engineering), Henrico County public utilities, and Arcet Welding Supply & CO2 distributors in Richmond, VA

    For Fire Life Safety America we modified a SQL Server database and an Access database for tracking sales commissions

    For Henrico County Public Schools, we modified their Access database

    For Arcet (now Arc3) we supported a CO2 distribution database that tracked routes for their people to maintain customer accounts
  • Ensafe
    Subcontracted to build a web application/SQL Server database for their Military client: Camp Peary, Department of Defense, CIA training in Williamsburg, VA. This database tracks the hazardous materials brought onto the military base, the current inventory levels of those hazardous materials, and the disposal of the hazardous materials. The Access database produces the annual reports required by the Environmental Protection Agency including Form R and Tier I and Tier II reports. We were the Microsoft Access Database consultants for this project
How we Build and Fix an Access Database

  • 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
  • Pepsi Bottling - Los Angeles
    Trained Pepsi on an Access Database we built tracking plant efficiency. We worked in Los Angeles (Riverside plant) and also created a training manual for the plant.
  • PepsiCo Global Concentrate Solutions
    In Atlanta, we are working with PepsiCo Global Concentrate Solutions to implement a Plant Picking database we built for Pepsi's Carlisle, PA plant. Pepsi Bottling approached us 20 years ago to build a Plant Efficiency tracking database that was rolled out nationwide. The other divisions within Pepsi then contacted and contracted us to build other professional Access database solutions.
  • Burgess & Co.
    Fix Access database for accounting firm
  • 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
  • Commonwealth Center for Advanced Manufacturing
    CCAM contacted us to convert their Excel Spreadsheet into an Access Database. They needed expert Access programmers for this task. Their spreadsheet was calculating the SPI Index for ongoing projects. But not working due to the complex nature of the calculation. A database was necessary and Microsoft Access was the perfect solution for converting this spreadsheet to a database.

    From the CCAM Website: THE COMMONWEALTH CENTER FOR ADVANCED MANUFACTURING "CCAM" IS WHERE THE BEST OF INDUSTRY, ACADEMIA AND GOVERNMENT COME TOGETHER TO SOLVE ADVANCED MANUFACTURING CHALLENGES.

    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 manufacturing industry

    We have also built 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
  • Progress Energy
    We built a certification tracking Access database application for Progress Energy to keep help them stay in compliance. This application tracks employee certifications for nuclear power training and alerts them when certifications will expire.

    We've worked on similar certification tracking applications for other clients like ClementPappas (food and beverage) and International Marine and Industrial Applicators (Military Subcontractor). The IMIA application is a PHP MySQL Application and more information may be found here: PHP and MySQL Development

    From Wikipedia: Progress Energy, headquartered in Raleigh, North Carolina, is a subsidiary of Duke Energy and prior to its merger with Duke Energy was a Fortune 500 energy company with more than 21,000 megawatts of generation capacity and $9 billion in annual revenues. Progress Energy includes two major electric utilities that serve approximately 3.1 million customers in the Carolinas and Florida.

  • Sequoia Tax Relief
    Sequoia Tax Relief is a collections agency in Denver, Colorado that specializes in Government Tax collections. They contacted us to modify their Access Databases
  • CSG Store
    CSG Store is a Verizon Product Reseller. They were challenged with tracking 1000s of invoices against a series of multiple payments by their clients (various verticals in the chain). We converted their spreadsheet nightmare into an Access Database. They can now process a month's worth of invoices in literally 5 minutes whereas the process was previously taking 3 mandays. This is the type of efficiency you can receive by using Microsoft Access.

    From the CSG Store website: CSG Store At Connected Solutions Group, we have a simple belief that every wireless hardware deployment has a sensible and significantly more affordable solution just waiting to be unearthed. With nearly a dozen years of experience directly inside the downstream trade of wireless technology, our ownership prides itself on problem-solving, cost-effective, and innovative ways to bring your hardware application to life.

    Other Access Solutions for Communications clients:Expert Access Solutions for Communications
  • Group Dynamics Entertainment
    This Entertainment Company needed an Access Database developed for them as a back end to their Horse Racing Movie Product. We developed the Access Database and project managed the movie development that interacts with the Access Database.
How Integration Works

  • Hospital Hospitality House
    Developed Access database for charity hotel organization. This hotel management application interacts with both a Topaz Signature pad for capturing hotel guest signatures as well as Adobe Acrobat and for producing .pdf files.
  • 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.
  • Nufarm Americas Inc.
    NuFarm is a pesticide chemical manufacturer based in Australia. They're office in Raleigh North Carolina initially engaged us to build an Access Database to track Environmentl Protection Agency (EPA) forms. They have over 2,000 EPA forms on file with the US Government.

    Upon further conversation and discovering the intent of this chemical/pesticide client, we decided that an Access Database WAS NOT the proper solution.

    They desired people AROUND THE WORLD to enter and query their application. So we built this database using PHP web pages and a SQL Server data file. You may find more information about this application at www.data-blade.com

    From their website: We know that growing is about more than just crops and cultivation. It's about sunshine and rain, early mornings and hard work. It can be frustratingly unpredictable, but also wonderfully uplifting. More than anything, it's about people. Nufarm is the dependable partner behind thousands of agricultural success stories. Every day, growers around the world turn to our products and our people to help with the challenges of fighting disease, weeds and pests, and to increase crop yields.
  • 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.
  • DEKRA Certification, Inc.
    DEKRA Consulting is a Germany based company. Their Phildelphia office uses an Access Database as the backbone of their USA practice. It tracks clients, consultants, and the status of consulting project/engagements.

    We took their back end Access tables and converted them to MySQL tables. We then migrated the data from the current Access database to the MySQL tables.

    Now DEKRA's employees may easily use the database across the country and the world.

    We provided a free Microsoft Access quote for this project and then did the work

    We did this work for the DEKRA office in Philadelphia, PA.

    From the Dekra Website (https://www.dekra-consulting.com/en/process-optimisation): We have a proven track record improving quality, business performance, people skills, workflows and processes of our global clients. Today our team serves a variety of industrial clients, but the core of our expertise was built in the role of preferred partner to the global automotive industry. Our strong international presence, industry expertise and close ties with the automotive trade result in high recognition amongst manufacturers, importers, dealers, independent repairer chains, suppliers and automotive service providers.

  • France Environmental
    We built France Environmental and Access database for importing leads from Peachtree And Outlook to generate sales/marketing emails that come from the Access Database and Integrate with Outlook.

    We developed and programmed this Access database to manages the environmental compliance training classes that France Environmental offers their clients.

    We've built Outlook import processes for both inbox and contacts. We've also built email functionality with attachments from within the Access Database.

    France Environmental is an Environmental Engineering Firm in Chesterfield, Virgiia. From their website: France Environmental, Inc. (FEI) is a small minority owned/operated company based in Richmond, Virginia staffed by personnel that have worked in the Asbestos and Lead-based Paint industries for many years. Asbestos and lead-based paint consulting services are the main focus of our business. Our clients include Federal, State, and Local Government agencies as well as private industrial, commercial, and residential entities. FEI offers a direct response and service at a reasonable price compared to many larger firms due to our low overhead expenses and simple management structure. Our employees provide a level of quality that is above the typical industry standard.
  • Selma's Cookies
    This Access Database application also integrates with a barcode scanner and the FedEx software for creating shipping labels.

    Selma Cookies is an Orlando Cookie Manufacturing whose largest client is Disney Corporation.

    Selma found us on the internet about 10 years ago. We've been modifying and supporting her Access database since then.

    This is a customer order management database that helps Selma keep track and fulfill Yahoo orders.

    This database imports from Excel derived spreadsheets that are produced by Yahoo and stages these orders to fulfillment and shipping.

    From Selma's website:In 1990, Selma Sayin began as a passionate baker whose secret recipes warmed the hearts and satisfied the sweet tooth of friends, clients and family.
  • Masonomics
    Microsoft Access Database for a commercial mason that sends text messages, connects to SQL Server web database for mobile web pages, and retrieves Timberline project information for project resource scheduling. This is one of the most complex Access Databases we've built considering the number of integrations with other systems.
  • Bravo Wine Imports
    Bravo Wines is an importer from Harrisonburg, Virginia. They asked us to modify their Access database which integrates with Quickbooks

    Bravo Imports Wine mostly from Italy and sells, through agents, to restaurants and markets including Kroger. This database application provides both a web page for entering orders as well as Quickbooks integration for creating invoices from those orders and updating current inventory and product lists. This is accomplished through an ODBC connection directly to Quickbooks.

    Agents and Items are managed through the Access database which communicates with the Website via MySQL connection (attached tables in the Access database). When Agents place orders, those order are viewed in the Access database, massaged and approved. Again through the use of attached MySQL tables.

    We provided the Microsoft Access help for this project

    From their website: "Wine is one of the most civilized things in the world and one of the most natural things of the world that has been brought to the greatest perfection, and it offers a greater range for enjoyment and appreciation than, possibly, any other purely sensory thing." Ernest Hemingway
  • Blue Ridge Operations
    Blue Ridge Products, an internet storeplace to purchase products, hired us to perform FTP integration with Access 2013. Blue Ridge creates orders and FTPs those orders to various warehouses including Amazon's warehouses to further process those orders.

    Blue Ridge is an import company in Richmond, Virginia that creates their own products, has them produced in China, imports those products to the United States and sells (mostly) through Amazon.

    This Access database is the central backbone for the company. It details all of the products, sales of those products, forecasts of the product sales, tracks current inventor levels etc.

    In addition to integrating with FTP software, this database has complex integration with Excel, both importing/massaging excel files as well as producing Excel files for both the company's internal personnel as well as the various warehouses used by the company.

    We provided the Microsoft Access training and documentation

Welcome to Data Control

We support professional, mission critical Microsoft Access Databases for your small to medium size company or for your department within a large company.



Our clients include:



- 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

- 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

- Vulcan Materials in Birmingham, Alabama - Environmental Access database tracking parts per million of dust released into the air when aggregate is created

- ClementPappas Cranberry Bottler in Carneys Point, New Jersey and Fayetteville, Arkansas - Database for Factory Human Resource tracking employees level of training for Food Safety Certication (SQF)

and 100s of smaller companies over the past 20 years









Contact



Our Process

  1. Discovery Conversation
  2. Agree to scope of work
  3. Test plan creation
  4. Iterative database development with client input
  5. Database rough draft delivery
  6. Database final implementation
  7. Database user documents
  8. Database developer documents