Subcontract / Partner with us for your Client's database



How Partnership Works

  • Networking Technologies and Support
    This Access database for a conveyor manufacturing company tracks is a project management database with multiple dates for the completion of manufacturing and engineering tasks with advanced calendaring.
  • ACSG
    Subcontractor to Build Access Database for tracking contract information for their Military client: Air Force Bases in Washington DC. ACSG is a Federal Prime Vendor and they went after a military contract that desired Access databases to manage contracts for the military bases in DC. This Access database we developed was identical but rolled out separately to manage the contracts that each Air Force base currently had in existence.
  • MatlenSilver Group ltd.
    Partner / Subcontracted to their Tobacco /Food Manufacturing Philip Morris (now Altria) for Manufacturing Training Tracking in Richond, VA. Matlen Silver is a staffing firm with a contract at Altria, the tobacco and food products giant. 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
  • ActivSupport
    Partner/Subcontractor to fix various Access, SQL Server, and Sharepoint Databases for their clients in Charlottesville, VA. Active Support needed an expert database company to support their clients without having to worry about the end results. Keeping their client happy was most important to ActivSupport. Our Access database skills helped them.
  • URS Corporation
    Built Access database for URS' client: Marine Corps Camp Lejeune. Database tracks Hunter Information Screen, License Screen, Violation Screen. Rank Maintenance screen and Record of Sales Report. Camp LeJeune is in North Carolina and is a Department of Defense, Military, Marine Corps URS is a prime vendor to the Federal Government and the Military Branches. This Access database helped the Marine base successfuly manage the land use of the base.
  • Bear Technologies
    Partner to fix Access database for their Police Client: Police Department, Klamath Falls, OR. We provided them with this quote: 1. Asp.net application that can be run from any computer using a web browser this will be used on any and all PCs used by the department 2. 3 tables plus asp.net log in tables a. Crime Report currently 130 +/- fields b. Officers currently 9 fields; add user name field from asp.net for correlation c. State Abbreviations currently 1 field 3. Forms for data input a. Log in to asp.net app b. New user to asp.net app c. Edit/Add officer to SQL database there will be an association of New user to asp.net using user name from asp.net d. Edit/Add State Abbreviations to SQL database e. Edit/Add Crime Report to SQL database 4. Reports a. Crime Report 5. Search feature on Crime Report form 6. Record navigation feature on Crime Report 7. Print Button on Crime Report 8. Sync Button on log in to asp.net form requires password 9. Sync new records to SQL Server Express 10. Update modified records to SQL Server Express 11. At present a sync from SQL Server Express to the asp.net application is not included 12. At present migrating old data from MS Access to SQL Server Express is not included
  • 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
  • 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
  • Sycom Technologies
    Access Database to track Employee Stock Distributions. Sycom's client, Tredegar Industries, needed to get out of a Lotus 123 Spreadsheet and into an Access database. We converted they're advanced Lotus Macros and now they create distributions, deposits, etc. for their stock plan with the new Access database. We were the Microsoft Access Database programmers for this project
  • 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

Build / Fix your Access Database



How we Build and Fix an Access Database

  • WestRock
    Build Access database for Fortune 500 paper and packaging company. Database manages 1 Billion of Inventory
  • Boone Homes, Inc.
    Build access database for residential home builder: Warranty Management
  • Crenshaw Corporation
    Build Access database for scheduling Truck Body work
  • Capital One - MTR
    Built Access database for Fortune 500 credit card company
  • Apex Properties
    Build Access database to track property management
  • Brown Distributing Company
    Build Access database for beer distributor. Database provides desired reports from company's accounting system
  • 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
  • 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
  • All Faith Consortium
    Fix SQL Server Database
  • Capital One - Auto Finance
    Build Access database for Fortune 500 credit card company

Integrate Access with Other programs



How Integration Works

  • 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 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.
  • 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
  • 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
  • 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.
  • 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.
  • 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