Microsoft Access Richmond virginia, Custom Microsoft Access Database Development provided by Data Control, LLC Programming in Richmond Virginia

Subcontract / Partner with us for your Client's database



How Partnership Works

  • Greystone
    We built a Quality tracking database that imports text files from machinery and reports defects for this automotive part manufacturer
  • West Broad Hyundai Dealership
    We've built an Access Database that imports lead data from a variety of sources, massages the data and reports it the way the dealership wants to see it.
  • 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).
  • B to B - DuPont
    SQL Server Admininstration Support
  • B to B Solutions
    Partner / Subcontract to build Access, SQL Server, .NET applications for their clients: Chemical Engineering client DuPont, their staffing client Apex Systems, Their health industry client Result Performance, and their insurance client Affinity Group Underwriters in Richmond, VA
  • 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.
  • 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.

Build / Fix your Access Database



How we Build and Fix an Access Database

  • Hercules Chemical - Alizay
    Supported their Access Database
  • Hercules Chemical - Franklin
    Supported their Access Database
  • Glave Firm, The
    A NATIONALLY RECOGNIZED ARCHITECTURE, interior design, and planning firm, Glavé & Holmes Architecture was founded in 1965 in Richmond, Virginia. The firm of 60 architects, interior designers, historic preservationists, and supporting staff, maintains a diverse and integrated portfolio demonstrating expertise in numerous market areas, including Higher Education, Cultural, Civic, Hospitality, and Residential. Clients are provided with comprehensive services whether projects involve new buildings, additions to buildings, renovations, or adaptive reuse.
  • E.I. DuPont - Nashville Payment Center
    Delivery of MS Project file including timeline. Delivery of Proposal for completion of project. Delivery of Data Description and Application Navigation Excel File.
  • Shaheen Law Group
    Modifying existing Access database that performs document mangement for the firm.
  • Hercules Chemical Corporation
    Building Access Database program to track and report batch processing efficiency
  • Clingman & Hanger
    Build multiple access database for attorney firm. Firm specializes in bankruptcy management. This Richmond Virginia based attorney firm specializes on managing the bankruptcies of retail operations. The databases we built tracked the various claimants, their amounts, their claim types and more. We disbursed funds from this database.
  • 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.
  • 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.
  • Chase, Inc - HVAC
    Build Access database to track heating/air conditioning clients and deliveries and installations. This is a Mechanical Engineering Firm in Chesterfield, Virginia (a suburb of Richmond, Virginia). About Chase HVAC: Mike Burton has been with Chase, Inc. in Richmond since 1982 and is the sole owner. Unlike many heating/air and plumbing companies, at Chase, you will not be treated like “just another customer.” Chase strives to keep its “Mom and Pop” reputation in Richmond over the years. If you’d like to speak directly with Mike when you call, it’s no problem. He is never too busy to speak with you. Otherwise, our office staff is more than glad to take your call and schedule an appointment to meet your heating/air and plumbing needs. We appreciate your business and look forward to continuing to serve you and your family for many more years to come.

Integrate Access with Other programs



How Integration Works

  • 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
  • B to B - DuPont
    SQL Server Admininstration Support
  • 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.
  • 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
  • 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.
  • 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.
  • 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
  • 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
  • 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.

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
Close