Subcontract / Partner with us for your Client's database



How Partnership Works

  • Convergent Business Solutions LLC
    Partner to build Access database for their Retirement Home client: Virginia Baptist Homes, a retirement community. We modified this existing Access 2007 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 help for this project
  • 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.
  • NTS
    Subcontracted to build Access & SQL server databases to the Virginia Lottery, the Virginia Beach Fire Department, Townes Engineering, EHS Laboratories and more
  • Ritchie and Associates
    Ritchie is a management consulting firm that was working for Fortune 500 firm Meadwestvaco (now WestRock). They were advising the paper and packaging firm to build an historical demand based Access Database. This Access database was used to manage inventory for their paper packaging manufacturing client: MeadWestvaco (Fortune 500) in Richmond, VA. It incorporated not only ERP fed 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.
  • Epitome Systems
    Subcontract to Fix 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.
  • 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
  • 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.
  • Uptime Solutions
    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.
  • Strategic Technology Systems
    Strategic Technology Systems is a full service IT company that provides consulting and support to their clients that need hardware, networks, servers, etc. running smoothly for their companies. Adam Mears, owner of STS contacted me to build an Access database for his client, The Snead Company, a commercial window supplier to the commercial construction industry. This Access database is web enabled with a SQL Server back end. Additionally it interacts with Sharepoint, providing light document management services. The Snead Company creates proposals for their clients using this Access database and then tracks the progress of those proposals to winning status (or dead status).

Build / Fix your Access Database



How we Build and Fix an Access Database

  • Naval Laboratory
    The Naval Research Laboratory in Waldorf, MD contacted us to build an inventory database. This Access Database handles the entire process of purchasing and inventorying all items on the base including all test equipment used at the Naval Research Laboratory. We all use hand scanner so complete physical inventories on base that stores/forwards information to the Access Database.
  • Ferrara Candy
    Ferrara Candy is a Candy Manufacturer the produces Candy in the United States and Mexico. Our Access database tracks, manages, and reports the overall equipment effectiveness of the manufacturing plants.
  • Capital One - Art
    Build Access database for Fortune 500 credit card company. Database tracks artwork throughout company
  • Ritchie and Associates
    Ritchie is a management consulting firm that was working for Fortune 500 firm Meadwestvaco (now WestRock). They were advising the paper and packaging firm to build an historical demand based Access Database. This Access database was used to manage inventory for their paper packaging manufacturing client: MeadWestvaco (Fortune 500) in Richmond, VA. It incorporated not only ERP fed 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.
  • The Pancake Man
    Fix Access Database to run Pancake catering business outside of Milwaukee, WI. Heavy interaction with Microsoft Outlook including customized calendar events. Mail Merge letters accomplished through Access Reports. Complex Data entry logic. We provided the free Microsoft Access quote for this project and did the development as well.
  • Simpson Strong Tie
    Built New Batch process tracking Access database to manage the production and shipping of batches. Simpson Strong Tie is a Fortune 500 company that strategically uses Access Database to manage department activities
  • Blake Law Firm
    Fixed and modified Access Database for matter tracking for a Chicago Illinois attorney firm. We also host this database on our server for them.
  • Gateway Global Delivery
    Gateway provides logistics services to their clients. The Access database we modified for them imports data files from FedEx. This data is then manipulated into complex invoices to send to Gateway's clients. This access database improves the efficiency of the overall organization. We were the Access database consultants for this project.
  • Mulit Interest Services Group
    MISC is a company that services the Import / Export industry. They specialize in getting your goods into the United States and out of the United states. The Access Database we've built tracks the process of containers coming in and out of the country including invoicing, transportation, payments, warehousing, etc.
  • Verizon Wireless - Rockies
    Real Estate Purchase tracking for cell phone towers. This database was built specifically for the Rocky Mountain division of Verizon for operations in Colorado, Nevada, Utah and Wyoming We provided the Free Microsoft Access quote for this project for this project. We then did the Access development as well.

Integrate Access with Other programs



How Integration Works

  • France Environmental
    Importing leads from Peachtree And Outlook to generate sales/marketing emails that come from the Access Database and Integrate with Outlook. This is an Access database that manages the environmental compliance training classes that France Environmental offers their clients. We've built Outlook import process for both inbox and contacts. We've also built email functionality with attachments from within the Access Database.
  • 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.
  • API Services
    Precision measurement and tool calibration for manufacturing clients, we built an Access database for API Sensor that tracks associates timesheets and expenses for management reporting and reimbursement/payroll. This application connects to SQL Server which is hosted on Data Control's Web Server. This is a backoffice application that runs the expense side of a company with geographically dispersed employees. They track their billable time and expenses, assigning both to projects/clients.
  • NuFarm
    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 Consulting
    Dekra Consulting provides Certification Services to their clients. 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
  • Blue Ridge Products
    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.
  • 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.
  • 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.
  • Bravo Wine Imports
    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. Bravo Wine is in Harrisonburg, Virginia. We provided the Microsoft Access help for this project

Welcome to Data Control

We’ve been building Access databases for the past 20 years. We love them and we respect them and take them seriously as business tools to improve your processes and make them more efficient.

Our clients include the Army, Navy, Air Force and Marines. The Virginia State Government, the Virginia Lottery, The University of Virginia, Virginia Commonwealth University, the University of Maryland, Pepsi Bottling, Capital One, DuPont, Altria, Vulcan Materials, West Rock, Carmax and 100s of smaller companies

Nationwide, we’ve built, modified and supported Access databases in Wichita, KS, Dallas, TX, Portland, OR, Sacramento, CA, Denver, CO, Chicago, IL, Milwaukee, WI, Pittsburgh, PA, Harrisburg, PA, New York, New York, Fayetteville, AR, St. Louis, MO, Raleigh, NC, Charlotte, NC, Orlando, FL and more.

Our Access databasese improve the business processes in the Manufacturing, Financial, Distribution, Education, Health Care, Governmental, Defense, Transportation, Pesticide, Aggregate, Housing, Bottling, Legal and Power industries.

If you need your Access database integrated with other systems, we’ve done this as well. Quick Books. Peachtree, Timberline. SAP. Oracle. Sharepoint. SQL Server and many more.

How about interacting with Excel and Word and Outlook? We are experts at automating Access using VBA Code and have written articles in our blog on this subject.

Training? We train people in Access database development as well. We’ve recently been to the FDA in Silver Spring, Maryland to train the Food and Drug Administration personnel in advanced Access database techniques. We’ve also trained at Carmax, Pepsi, Capital One, Crown Petroleum, Baltimore Gas and Electric, Prince William County and many more places.

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
Close