Subcontract / Partner with us for your Client's database



How Partnership Works

  • 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 is used 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. There is an AQuality 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
  • AVB Solutions
    We were subcontracted to build Access database for their healthcare client: Veteran's Hospital in Richmond, VA. This Access database helped hospitals run their operations as was rolled out to a consortium of healthcare operations in Virginia, Maryland, and DC.
  • Burnstone Computer Services
    Subcontract to build Access databases for associations and retirement home management: Masons of Virginia. This Access database keeps track of the membership for the Virginia Masons. It provides invoicing functions and tracks the current positions of each Mason within their lodges.

Build / Fix your Access Database



How we Build and Fix an Access Database

  • Burgess & Co.
    Fix Access database for accounting firm
  • 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.
  • Nufarm Americas Inc.
    NuFarm is a pesticide chemical manufacturer that 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
  • Hercules Chemical - Alizay
    Supported their Access Database
  • Hercules Chemical - Franklin
    Supported their Access Database
  • DEKRA Certification, Inc.
    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. The Access Database they use is 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. DEKRA consulting is in Philadelphia, PA. Now DEKRA's employees may easily use the database across the country and the world. We provided the Free Microsoft Access quote for this project and then did the work
  • 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.
  • Atlantic Constructors, Inc.
    Build a Microsoft Access database in Chesterfield Virginia to determine pricing for this Mechanical Engineering firm. Developing this Pricing Access database was critical for their operations. About Atlantic Constructors, Inc: ACI works across the spectrum of business and industry,from busy production facilities, power plants, and the many factories in the Mid-Atlantic, to commercial and government buildings, universities, hospitals and specialized laboratories. Our customers know we can be counted on not just to get the job done, but to get it done right, safe and on-time.
  • Chemtreat
    Fix Access database for water purification company. About Chemtreat: Headquartered in Richmond, Virginia, ChemTreat is one of the largest and fastest growing industrial water treatment companies in North and South America. Since 1968 our entrepreneurial spirit and emphasis on hiring the very best field engineers have driven our success as we continue to find new ways to demonstrate value for our customers. Dedicated to industrial water treatment, we offer world class products and process improvement services focused on building long term satisfaction and commitment. We help our customers save millions of dollars every year, enabling us to achieve unparalleled growth in the water treatment industry.

Integrate Access with Other programs



How Integration Works

  • Greystone
    Manufacturing Firm in Toano, Virginia. We built a Quality tracking database that imports 1000s text files output from manufacturing machinery. This database reports defects during the manufacturing process for this automotive parts manufacturer
  • West Broad Hyundai Dealership
    Auto Dealership in Richmond, Virginia. We've built an Access Database performs an FTP import of lead data from a variety of sources, massages the data and creates sales pipeline reports.
  • 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.
  • Nufarm Americas Inc.
    NuFarm is a pesticide chemical manufacturer that 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
  • DEKRA Certification, Inc.
    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. The Access Database they use is 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. DEKRA consulting is in Philadelphia, PA. Now DEKRA's employees may easily use the database across the country and the world. We provided the Free Microsoft Access quote for this project and then did the work
  • Selma's Cookies
    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. This Access Database application also integrates with a barcode scanner and the FedEx software for creating shipping labels.
  • Roofing Consulting Services
    Commercial Roof Consulting Firm. The Company sends crews across the country to photograph and notate deficiencies in commercial roofs. That data is centrally collected, entered into the Access Database we support, and generates complex, 70 page .pdf file reports. The database gives the user the options to manipulate the sections of the reports prior to creating the .pdfs. We use VBA code to automate the .pdf file creation process.
  • VibrAlign
    Distributor of Vibration Analysis equipment to manufacturing firms. Access database connects to outlook to schedule training and equipment deliveries for that training. Connects to Navision to retrieve customer and contact information. This Access database also integrates heavily with Microsoft Outlook, providing both calendaring and email functionality VibraAlign is in Richmond VA and has clients across the country including Texas, California, Utah, Colorado, New York, Florida and Illinois.
  • Blue Ridge Operations
    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 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
  • 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.

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