Subcontract / Partner with us for your Client's database



How Partnership Works

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

Build / Fix your Access Database



How we Build and Fix an Access Database

  • 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.
  • PepsiCo Worldwide Flavours
    Built Access Database for Concentrate portion of Bottling Business. This Access database is used for tracking productivity of resources within the manufacturing / bottling facility. We modified a previous Access database built for the Pepsi Pennsylvania plant and imported raw data from Excel.
  • Capital One - Poseidon's Chariot, CapEx
    Build Access database for Fortune 500 credit card company.
  • 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.
  • Prairie Land Services
    Developed an Access Database for Car Repossesion Company in Wichita, Kansas. This database manages the back office expense entry and reporting for the various employees and subcontractors that work at Prairie Land. The employees weekly payroll is determined from this Access database.
  • 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
  • Tredegar Corporation
    About Tredegar: Deeply rooted in manufacturing, Tredegar Corporation is a global operating company with industry-leading businesses in the plastic films and aluminum extrusions markets. We were engaged through one of our strategic partners to help Tredegar manage a special bonus functionality in the Human Resource department. We've built many commission and bonus related Access databases in a variety of firms including Fortune 500 Altria and more, so we were well positioned to referred to Tredegar for this Microsoft Access database consulting engagement. Tredegar has a Lotus 123 spreadsheet (yes! Lotus 123) for keeping track of retired employees and the distributions those employees choose to take out of their retirement. Tredegar asked us to convert this Lotus 123 Spreadsheet into an Access Database. The new Access 2013 database will replace the Lotus 123 spreadsheet functionality of managing and administrating this human resource function of retired employee distributions. We were the Microsoft Access Database consultants for this project
  • Apex Properties
    Access Database Consulting, Design, Development, Installation and Training for Property Management Application in Sacramento, CA. This Access Database runs the office for a property management company.
  • 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

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

Welcome to Data Control

We are a small group of expert Microsoft Access Database developers. We love Access and enjoy improving business processes through the databases we develop.

We started building databases back in 1998. Pepsi Bottling Group (now Pepsi International), Hercules Chemical, Crown Petroleum and Christian Children’s Fund were a few of our earliest clients.

Since then, we’ve programmed Access databases for the Air Force, the Army, Capital One, DuPont, Circuit City, GenWorth Financial, Suntrust, Verizon Wireless and many, many more companies.

Our clients are across the nation and include Nestle Beverage in California, Prairie Land Services in Wichita Kansas, Capital One auto finace in Texas and Hibernia bank in Louisiana. We’ve also built Access databases for ClementPappas Beverages in Fayetteville Arkansas, for Pepsi Bottling outside of New York, New York, and New World Pasta in St Louis Missouri. But it doesn’t stop there. We’ve built Access databases for CFA Financial in Greenville, South Carolina; built training rolex replica tracking Access databases for Progress Energy in Raleigh North Carolina, and recently we’re working with ShermanHoward Law firm in Denver, Colorado. Still more! The Blake Horowitz Law Firm in Chicago, Illinois is our client and the Virginia Beach Fire department as well.

How and why do all these folks work with us? Well the why is because we are recognized across the nation as professional Microsoft Access Developers. Not only do we build professional databases with excellent naming conventions, coding practices, clean interfaces and professional reports, but we are excellent at communicating with clients, following up, debugging our work and more.

Over the past 20 years, we’ve also seen particular niches of database requests. It seems that environmental engineers (URS, Ensafe, Angler Environmental, France Environmental, Vulcan Material, and RockTenn Corporation) have a glaring need for Access databases. We also work with lots of quality managers for instance: Ball Corporation, Greystone Manufacturing, ClementPappas and more. Training tracking is yet another niche for the Access Experts at our firm. We’ve built training tracking databases for ClementPappas (again), Altria (parent company of Philip Morris), and Progress Energy (nuclear engineer training). We also see lots of demand from Mechanical Engineers including Fire Life Safety America, Hungerfoord Mechanical, and Chase Heating and Cooling. There’s also lots of demand for our services in the legal world. We count ShermanHoward, McGuireWoods (expert witness work), SandsAnderson, LeClairRyan, and many other firms as our clients.

Do you need a database that interacts with your accounting system? We integrate our databases with Timberline, Oracle, JD Edwards, SAP, Quickbooks, and Peachtree.

Do you need an Access database that imports / exports either .csv or Excel files? We’ve done lots of that too. Cleaning, scrubbing, and importing are all tasks we’ve gotten very good at doing.

Partnering with Data Control

About half of our business comes from strategic partners. We work with Network Engineering firms like ActivSupport (New York), Bear Technologies (Portland, OR), Fisk Information Technology (Pittsburgh), SyCom Technologies, and many more. We’ve also worked through Federal Contractors like ASCG, Goodwill, and MatlenSilver. Another group of folks partnering/subcontracting us is management consultants like Ritchie Consulting.

How does partnership work with us? Well first of all you should know that we take your client relationship very seriously watches store and professionally. We will bring you into all conversations and protect your client relationship. We will work as transparently as you like, or you might hand a client off to us because you don’t wish to be a middle man and we’ll take great care of them for you (and take care of you as well!)

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