Subcontract / Partner with us for your Client's database



How Partnership Works

  • Strategic Technology Systems
    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).

    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.
  • 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
  • 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.
  • 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.
    MatlenSilver Group, Inc subcontracted us to their Fortune 500 Tobacco /Food Manufacturing Philip Morris (now Altria) for Manufacturing Training Tracking in Richond, VA.

    The Matlen Silver Group, Inc. provides information technology (IT) staffing services.

    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
    ActivSupport contacted us to fix various Access, SQL Server, and Sharepoint Databases for their clients in Charlottesville, VA.

    Active Support needed an expert database consulting company to support their clients without having to worry about the end results. Keeping their client happy was most important to ActivSupport. By supplying professional database developers to ActivSupport and their clients, we kept both our partner and their client happy
  • URS Corporation
    URS, a Fortune 500 Consulting Firm, contacted us to build an Access database for their client: United States Marine Corps: Camp Lejeune.

    This Access Database tracks hunting on the Camp grounds through: Hunter Information Screen, License Screen, Violation Screen, and a Rank Maintenance screen. A Record of Sales Report can also be generated. 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 this US Marine Corps 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

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
  • 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.
  • 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.
  • 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.
  • Nufarm Americas Inc.
    NuFarm is a pesticide chemical manufacturer based in Australia. They're office in Raleigh North Carolina 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

    From their website: We know that growing is about more than just crops and cultivation. It's about sunshine and rain, early mornings and hard work. It can be frustratingly unpredictable, but also wonderfully uplifting. More than anything, it's about people. Nufarm is the dependable partner behind thousands of agricultural success stories. Every day, growers around the world turn to our products and our people to help with the challenges of fighting disease, weeds and pests, and to increase crop yields.
  • Boone Homes, Inc.
    Build access database for residential home builder: Warranty Management
  • Capital One - Poseidon's Chariot, CapEx
    Build Access database for Fortune 500 credit card company.
  • Crenshaw Corporation
    Build Access database for scheduling Truck Body 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.
  • DEKRA Certification, Inc.
    DEKRA Consulting is a Germany based company. Their Phildelphia office uses an Access Database as 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.

    Now DEKRA's employees may easily use the database across the country and the world.

    We provided a free Microsoft Access quote for this project and then did the work

    We did this work for the DEKRA office in Philadelphia, PA.

    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.

Integrate Access with Other programs



How Integration Works

  • 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.
  • Greystone
    Manufacturing Firm in Toano, Virginia.

    We built a Quality tracking database that imports 1000s text files output from manufacturing machinery.

    This microsoft access database reports defects during the manufacturing process for this automotive parts manufacturer

    From Greystone website: Greystone is a global leader in the production of high volume precision machined and plated components for the automotive, aerospace, defense and industrial markets. Specializing in safety critical machining, hard chrome plating, and anodizing, we take pride in developing innovative engineering solutions to difficult problems.
  • Nufarm Americas Inc.
    NuFarm is a pesticide chemical manufacturer based in Australia. They're office in Raleigh North Carolina 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

    From their website: We know that growing is about more than just crops and cultivation. It's about sunshine and rain, early mornings and hard work. It can be frustratingly unpredictable, but also wonderfully uplifting. More than anything, it's about people. Nufarm is the dependable partner behind thousands of agricultural success stories. Every day, growers around the world turn to our products and our people to help with the challenges of fighting disease, weeds and pests, and to increase crop yields.
  • West Broad Hyundai Dealership
    West Broad Hyundai is an Auto Dealership in Richmond, Virginia.

    We've built an Access Database that performs an FTP import of lead data from a variety of sources, massages the data and creates sales pipeline reports.

    Sales management decides on a variety of data sites to buy lists of leads. These leads are sent to our ftp site for processing into West Broad Hyundai's Access Data (that we built for them).

    After massaging the leads for freshness of data, the leads are then sent to salesmen for further followup. This follow up is also tracked by the Access database we developed and management reports are generated updating sales management and salesperson performance.

    From their website: We're glad you've come to the ALL NEW West Broad Hyundai, Richmond's state-of-the-art Hyundai superstore! Proudly serving Henrico, Mechanicsville, Midlothian, Chesterfield and Chester, we strive to deliver excellence from start to finish. Over eight acres of brand new Hyundai, Certified Pre-owned Hyundai and used cars await you! Stop by you will find great deals on every new eye-catching Hyundai model we sell, including:
  • DEKRA Certification, Inc.
    DEKRA Consulting is a Germany based company. Their Phildelphia office uses an Access Database as 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.

    Now DEKRA's employees may easily use the database across the country and the world.

    We provided a free Microsoft Access quote for this project and then did the work

    We did this work for the DEKRA office in Philadelphia, PA.

    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.

  • France Environmental
    We built France Environmental and Access database for importing leads from Peachtree And Outlook to generate sales/marketing emails that come from the Access Database and Integrate with Outlook.

    We developed and programmed this Access database to manages the environmental compliance training classes that France Environmental offers their clients.

    We've built Outlook import processes for both inbox and contacts. We've also built email functionality with attachments from within the Access Database.

    France Environmental is an Environmental Engineering Firm in Chesterfield, Virgiia. From their website: France Environmental, Inc. (FEI) is a small minority owned/operated company based in Richmond, Virginia staffed by personnel that have worked in the Asbestos and Lead-based Paint industries for many years. Asbestos and lead-based paint consulting services are the main focus of our business. Our clients include Federal, State, and Local Government agencies as well as private industrial, commercial, and residential entities. FEI offers a direct response and service at a reasonable price compared to many larger firms due to our low overhead expenses and simple management structure. Our employees provide a level of quality that is above the typical industry standard.
  • Selma's Cookies
    This Access Database application also integrates with a barcode scanner and the FedEx software for creating shipping labels.

    Selma Cookies is an Orlando Cookie Manufacturing whose largest client is Disney Corporation.

    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.

    From Selma's website:In 1990, Selma Sayin began as a passionate baker whose secret recipes warmed the hearts and satisfied the sweet tooth of friends, clients and family.
  • 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.
  • Bravo Wine Imports
    Bravo Wines is an importer from Harrisonburg, Virginia. They asked us to modify their Access database which integrates with Quickbooks

    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.

    We provided the Microsoft Access help for this project

    From their website: "Wine is one of the most civilized things in the world and one of the most natural things of the world that has been brought to the greatest perfection, and it offers a greater range for enjoyment and appreciation than, possibly, any other purely sensory thing." Ernest Hemingway
  • Blue Ridge Operations
    Blue Ridge Products, an internet storeplace to purchase products, hired us to perform 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 in Richmond, Virginia 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

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