Richmond Virginia

Microsoft Access Richmond Virginia

Data Control, LLC is a group of Microsoft Access Gurus with 20+ years of experience serving Business, Military, Government and University Clients

We Scope projects with you, provide you a quote, and deliver professional databases.

We often modify existing databases

As our headquarters and city of origin, Richmond has always held a special place for Data Control. It is here where we have had some of our biggest clients and where have a performed some of our best database development work. The custom database programming we have provided for the Fortune 500 clients in Richmond has yielded some of the most efficient and effective data management solutions to be found.


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.

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.

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.

Here are some clients we have helped in Richmond

Client

Location

Project Description

Commonwealth Center for Advanced Manufacturing ,
Strategic Technology Systems Richmond, VA 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.
Glave Firm, The Richmond, VA 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.
Hospital Hospitality House Richmond, VA 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.
B to B Solutions Richmond, VA 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
Crenshaw Corporation Richmond, VA Build Access database for scheduling Truck Body work
West Broad Hyundai Dealership Richmond, VA 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:
France Environmental Richmond, VA 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.
Masonomics Chesterfield, VA 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.
Brown Distributing Company Richmond, VA Build Access database for beer distributor. Database provides desired reports from company's accounting system
MatlenSilver Group ltd. Richmond, VA 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
Chase M. Adkins, Jr. CPA Richmond, VA We built an Access Database for Chase Adkins. Chase Adkins is located in Sandston, Virginia. This organization primarily operates in the Certified Public Accountant business / industry within the Engineering, Accounting, Research, and Management Services sector. This organization has been operating for approximately 27 years. Chase Adkins employs 1 people at this single location.
Tredegar Corporation Richmond, VA 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
Mulit Interest Services Group Richmond, VA 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.
Capital One - Art Richmond, VA Build Access database for Fortune 500 credit card company. Database tracks artwork throughout company. About Capital One: We are a Top 10 U.S. bank, with the strength and stability to meet the needs of your business. Our Commercial Banking group services a $65 billion loan portfolio and more than 6,100 clients. Let us show you the difference our partnership and proven experience can make.
Chase, Inc - HVAC Richmond, VA 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 youd like to speak directly with Mike when you call, its 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.
Burnstone Computer Services Richmond, VA 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.
Shaheen & Shaheen Richmond, VA Creating and modifying Access database for marketing purposes
Burgess & Co. Richmond, VA Fix Access database for accounting firm
UpTime Solutions Professional Services Group Richmond, VA Network Engineering Firm in Richmond, Virginia.

This is a 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.
B to B - DuPont Richmond, VA We were hired by BtoB, a SQL Server development and administration company to help their client: DuPont to provide administration support to their SQL Server Databases

The Chemical giant, DuPont, has a SQL Server farm that provides databases to the company's offices around the world.

We provided this service at the DuPont Chemical plant in Richmond, Virginia.

DuPont is a Fortune 500 Chemical Company headquartered in Wilmington, Delaware.

From their website: See what makes DuPont one of the most successful science and engineering companies in the world.

Values: Our core values govern our internal business practices and partnerships, and guide our innovations.

Leadership: Meet our Chair and CEO, board of directors, corporate executives, and regional and functional leaders.
Atlantic Constructors, Inc. Richmond, VA 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.
Networking Technologies and Solutions Richmond, VA Network Engineers in Richmond, Virginia. NTS has subcontracted us many times to build Access & SQL server databases to the Virginia Lottery, the Virginia Beach Fire Department, Townes Engineering, EHS Laboratories and more.

For the Lottery, we've built machine maintenance tracking databases and number tracking databases (historical record of the numbers that won)

For the Virginia Beach Fire department, we built a Microsoft Access truck inventory database.

For Townes Engineering, we modified their website

For EHS Laboratories we also modified their website
Roofing Consulting Services Richmond, VA 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 Richmond, VA 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.
Strategic Technology Systems Richmond, VA 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.
Convergent Business Solutions LLC Richmond, VA Convergent is a consulting firm in Richmond, Virginia. We partnered to build an Access database for their Retirement Home client: Virginia Baptist Homes, a retirement community.

We modified this existing Access 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 expertise for this project
Sycom Technologies Richmond, VA 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

For Fire Life Safety America we modified a SQL Server database and an Access database for tracking sales commissions

For Henrico County Public Schools, we modified their Access database

For Arcet (now Arc3) we supported a CO2 distribution database that tracked routes for their people to maintain customer accounts
Shaheen Law Group Newport News, VA Modifying existing Access database that performs document mangement for the firm.
AVB Solutions Richmond, VA 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.
E.I. DuPont - Nashville Payment Center Richmond, VA Delivery of MS Project file including timeline. Delivery of Proposal for completion of project. Delivery of Data Description and Application Navigation Excel File.
Sycom Technologies Richmond, VA 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
VBS Material Handling Richmond, VA MS Access / SQL Server database to manage material handling distributor company's contracts and Bills of Lading
Rocktenn Corporation Environmental database Richmond, VA Built Access database for environmental manager to track waste disposal
Health Savings Administrators, LLC Richmond, VA MS Access/SQL Server database to manage backoffice Medical Insurance practice management
Virginia Community Policing Institute Richmond, VA Virginia Community Policing Institute provides training material to police organization across the United States. We worked with them to build and Access database that would track which individuals received what training. This database also reminds VCPI that training is about to expire for certain individuals.
APTCO Richmond, VA Build Access database
Bill Judge and Associates Richmond, VA Build Access database to import .csv files of clients for Insurance Agent.
Sands Anderson Marks & Miller Richmond, VA Fixed Access database for attorney firm's real estate division tracking property permits
Altria - HR Richmond, VA Fix Access Database to report on premium payments for benefits department
Assura, Inc. Richmond, VA The purpose of this project was to develop a database for Assura that calculates the Residual Risk for vulnerabilities defined by clients of Assura. Scope: The project is expected to be developed using 8 tables, 9 forms, 1 report (actually the function to link the results to a MS Word document). Queries will be developed as needed to complete each object. Each form will be reviewed with the customer upon completion. Some of the functions may be incomplete at that time as it may be dependent upon completion of other objects. The review will be done to secure approval for the layout of the form as well as the functions that are working at the time of review.
Archadeck Richmond, VA Build Access database to determine pricing for residential construction company - deck building
Bigge Crane Richmond, VA Fix Access database for Crane Construction company
623 Landfill Richmond, VA Build Landfill Environmental Access database Landfill's have to meet State and Federal Environmental requirements and report on these requirements quarterly and annually. This Access database allows the users to easily record, maintain and report to meet these requirements. The 623 landfill is located in the Rockville/Manakin area of Richmond, VA
Children's Health Involving Parents Richmond, VA Fix Access database for charity organization
Capital One - SarbOx Richmond, VA Build Access database for Fortune 500 credit card company.
Capital One - Reservations Richmond, VA Build Access database for Fortune 500 credit card company.
Capital Advisory Group Richmond, VA Build Access database for reporting on portfolio of investment performance
Allen, Allen, Allen & Allen Richmond, VA Fix Access Database for Personal Injury Attorney Firm
Capital One - Team Trident Richmond, VA Build Access database for Fortune 500 credit card company.
Angler Environmental Richmond, VA Build Access database to track environmental impact of construction projects
Capital One - Employee History Richmond, VA Build Access database for Fortune 500 credit card company
Capital One - ARC Richmond, VA Build Access database for Fortune 500 credit card company
Capital One - IT Finance Richmond, VA Build Access database for Fortune 500 credit card company
ARB Journal Richmond, VA Build web application with .NET and SQL Server
Arc3 Richmond, VA Build Access database for CO2 distributor to track orders and delivery schedule
McCammon Group Richmond, VA build Web Application managing scheduling of attorneys, coordinating meetings
LOMC, LLC Richmond, VA Build Web Application - Referral network
GUSA Soccer Richmond, VA Build Web Application to manage registrations
Allied Environmental Richmond, VA Build Access Database for Environmental Engineer
At Home Care Richmond, VA Build Web Application to manage Doctor sign off process
Pack & Ride Richmond, VA Build Web Application to manage logistics of container delivery to clients
Capital One - Plass Richmond, VA Build Access database for Fortune 500 credit card company
Dealer Auto Direct Richmond, VA Build Web application that managed inventory flow among multiple dealers
Advanced Printing Richmond, VA Fix Access Database Advanced Printing is a full service printing firm in Richmond Virginia. They have an Access database for label making. They needed to do some advanced text concatenation in order to make labels properly for one of their clients. We've have a lot of experience handling .csv downloads into Access databases and scrubbing/manipulating the data. This experience was useful getting Advanced printing the Access database
Capital One - M. Maynes Richmond, VA Build Access database for Fortune 500 credit card company

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