Access Database Consultant Developer Programmer

Richmond, Virginia

access database guru expert richmond virginia



Custom Access Database experts based in Richmond, VA. Our clients in Richmond include the US Army, the Federal Government, the Virginia State Government, Capital One, Carmax and many more

Thank you Wikipedia:
Richmond is at the fall line of the James River, 44 miles (71 km) west of Williamsburg, 66 miles (106 km) east of Charlottesville, 91 miles (146 km) east of Lynchburg and 92 miles (148 km) south of Washington, D.C. Surrounded by Henrico and Chesterfield counties, the city is at the intersections of Interstate 95 and Interstate 64 and encircled by Interstate 295, Virginia State Route 150 and Virginia State Route 288. Major suburbs include Midlothian to the southwest, Chesterfield to the south, Varina to the southeast, Sandston to the east, Glen Allen to the north and west, Short Pump to the west and Mechanicsville to the northeast.

Our sister company: Data-Bolt.com PHP and MySQL developers and programmers for web applications: Data-blade.com

Specifc Access database expert solutions are here

We also build Access databases in Los Angeles California

>We also build Access databases in Houston Texas

Thank you Photographer for great picture!!!



Clients
  • Food and Drug Administration
    Dynamics Edge had a contract to Train the Food and Drug Administration. When they had an Advanced Access Class to train, they called us as Expert Access Consultants to perform the training in Silver Spring, MD
  • 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
  • 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
  • Virginia Association for Home Care and Hospice
    Fixed and modifed an exiting Access database for an Association. This client manages their client invoicing and payments with an Access Database. They desired to share the database from home and work, so we migrated the data tables to a MySQL database in the cloud (Data Control Servers)
  • Dominion Partners
    Dominion Partners desired an Access Guru to build an access database to manage their investment banking back office operations. They contracted us for this Access Database project.
  • Holiday Signs
    Holiday Signs need an expert Access Database consultant to revise their Customer Relationship Manager application. This is an Access database that provides at-your-fingertip pipeline data to help both the salesmen and sales managers keep track of ongoing sales leads. Metrics come out of this database to help evaluate and improve sales performance.

    We are also the PHP Developer and MySQL Consultant for Holiday signs. You may find more information about these services here: Data Bolt provides PHP and MySQL consulting
  • 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.
  • HORWITZ, RICHARDSON & BAKER, LLC
    Chicago Law Firm that used an Access database to manage their cases. We migrated their Access tables to MySQL tables in the cloud: Our Server.
  • Routt County Alcohol Council
    The Council contacted us to upgrade their Access 97 database to the current version of Access. We have to first move the database into Access 2003, and then into Access 2019 (365). The was further complicated due to a workgroup information file protecting the Access 97 database and then advanced vba code that needed modification.

    We are frustrated that Microsoft does not provide a transparent upgrade path from Access 97 directly to Access 365 (or whatever current version of Access is out today). We are further frustrated that Access discontinues support of features such as workgroup information files, pivot tables/report, Access Data Projects. So clients are forced to contact consultants like Data Control. We realize the importance of your database and the dilemma you are in. So we try to fairly price the upgrade to the new version of Access hoping that we can get future development work from you.

    To get around the Workgroup Information File issue (the client had no documentation of this which is understandable considering the database is 20 years old and the original developer long gone), we opened a new Access 2003 database and imported all of the objects. This then allowed us to open the Access 2003 database in Access 2007 and perform the final upgrade steps.

    This particular database uses advanced VBA code and expected the data file to be in a particular position on the server. If the data file wasn't there, the reports didn't work. So we searched through the code removing this requirement. We also had to modify a few of the libraries

    Routt County Alcohol Board is a non-profit serving the city of Steam Boat in Colorado. Their database is a case management and reporting vehicle for their operations.

Here are some clients we have helped in Richmond

Client

Project Description

Dominion Partners

Dominion Partners desired an Access Guru to build an access database to manage their investment banking back office operations. They contracted us for this Access Database project.

Brown Distributing Company

Build Access database for beer distributor. Database provides desired reports from company's accounting system

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

Mulit Interest Services Group

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.

Group Dynamics Entertainment

This Entertainment Company needed an Access Database developed for them as a back end to their Horse Racing Movie Product. We developed the Access Database and project managed the movie development that interacts with the Access Database.

Burgess & Co.

Fix Access database for accounting firm

CSG Store

CSG Store is a Verizon Product Reseller. They were challenged with tracking 1000s of invoices against a series of multiple payments by their clients (various verticals in the chain). We converted their spreadsheet nightmare into an Access Database. They can now process a month's worth of invoices in literally 5 minutes whereas the process was previously taking 3 mandays. This is the type of efficiency you can receive by using Microsoft Access.

From the CSG Store website: CSG Store At Connected Solutions Group, we have a simple belief that every wireless hardware deployment has a sensible and significantly more affordable solution just waiting to be unearthed. With nearly a dozen years of experience directly inside the downstream trade of wireless technology, our ownership prides itself on problem-solving, cost-effective, and innovative ways to bring your hardware application to life.

Other Access Solutions for Communications clients:Expert Access Solutions for Communications

Sequoia Tax Relief

Sequoia Tax Relief is a collections agency in Denver, Colorado that specializes in Government Tax collections. They contacted us to modify their Access Databases

Commonwealth Center for Advanced Manufacturing

CCAM contacted us to convert their Excel Spreadsheet into an Access Database. They needed expert Access programmers for this task. Their spreadsheet was calculating the SPI Index for ongoing projects. But not working due to the complex nature of the calculation. A database was necessary and Microsoft Access was the perfect solution for converting this spreadsheet to a database.

From the CCAM Website: THE COMMONWEALTH CENTER FOR ADVANCED MANUFACTURING "CCAM" IS WHERE THE BEST OF INDUSTRY, ACADEMIA AND GOVERNMENT COME TOGETHER TO SOLVE ADVANCED MANUFACTURING CHALLENGES.

We also build expert PHP and MySQL web application solutions for the manufacturing industry. More information here: PHP and MySQL web application solutions for the manufacturing industry

We have also built Overall Equipment Effectiveness Access Databases and similar efficiency tracking databases for Pepsi Bottling and Clement Pappas. We have converted these applications for general use and more information is available here: Overall Equipment Effectiveness for the manufacturing industry

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.

Chase M. Adkins, Jr. CPA

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.

Shaheen & Shaheen

Creating and modifying Access database for marketing purposes

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

Hercules Chemical - Franklin

Supported their Access Database. Chemical Manufacturer. We built a batch tracking application for them

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.

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.

Networking Technologies and Solutions

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

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.

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.

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

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.

Shaheen Law Group

Modifying existing Access database that performs document mangement for the firm.

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.

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.

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.

Burnstone Computer Services

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.

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.

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.

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.

WestRock

Build Access database for Fortune 500 paper and packaging company. Database manages 1 Billion of Inventory

Harris, Williams & Co.

Harris, Williams & Co contacted us to build a portfolio management database. They wanted expert Access Consultants to work for them. We built a professional Access Database application that match their clients' desired needs to their portfolio of companies for sale.

Maisonettes Apartments

Maisonnettes Apartments runs an apartment complex and a trailer park. We upgraded their previous DOS based monthly rent collection application into an Access Database. Now all functionality of tracking tenants monthly rent is handled in Access. This database also provide the lease agreements and tracks historical tenants (tenants that have previously lived at the property)

UpTime Solutions Professional Services Group

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.

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.

Boone Homes, Inc.

Build access database for residential home builder: Warranty Management

Strategic Technology Systems

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.

B to B - DuPont

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.

Sycom Technologies

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

Crenshaw Corporation

Build Access database for scheduling Truck Body work

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

Pack & Ride

Build Web Application to manage logistics of container delivery to clients

Apex Systems, Inc.

Build SQL Server database for staffing company

Capital Advisory Group

Build Access database for reporting on portfolio of investment performance

Children's Health Involving Parents

Fix Access database for charity organization

Advanced Printing

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

Advanous a division of Enterbridge

Fix Access Database

Affinity Group Underwriters

Fix Access Database for Insurance Company

Dealer Auto Direct

Build Web application that managed inventory flow among multiple dealers

Allen, Allen, Allen & Allen

Fix Access Database for Personal Injury Attorney Firm

At Home Care

Build Web Application to manage Doctor sign off process

Allied Environmental

Build Access Database for Environmental Engineer

Virginia Hospital & Healthcare Association

This is an Association Management database that manages the entire organization. Virginia Hospital & Healthcare Association is a group of Hospitals that lobbys the Virginia State Government. This Access database produces an online directory of members, keeps track of which members are in which House and Senate districts, emails the members and invoices the members.

GUSA Soccer

Build Web Application to manage registrations

LOMC, LLC

Build Web Application - Referral network

McCammon Group

build Web Application managing scheduling of attorneys, coordinating meetings

Virginia Community Policing Institute

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.

Sands Anderson Marks & Miller

Fixed Access database for attorney firm's real estate division tracking property permits

Angler Environmental

Build Access database to track environmental impact of construction projects

ARB Journal

Build web application with .NET and SQL Server

Arc3

Build Access database for CO2 distributor to track orders and delivery schedule

APTCO

Build Access database

Health Savings Administrators, LLC

MS Access/SQL Server database to manage backoffice Medical Insurance practice management

Rocktenn Corporation Environmental database

Built Access database for environmental manager to track waste disposal

VBS Material Handling

MS Access / SQL Server database to manage material handling distributor company's contracts and Bills of Lading

Bill Judge and Associates

Build Access database to import .csv files of clients for Insurance Agent.

Bigge Crane

Fix Access database for Crane Construction company

Archadeck

Build Access database to determine pricing for residential construction company - deck building

Assura, Inc.

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.

623 Landfill

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

Bimbo Bakeries

Build Access Database to track tax related accounting expenses. From wikipedia: Bimbo Bakeries USA is the American corporate arm of the Mexican multinational bakery product manufacturing company Grupo Bimbo. It is the largest bakery company in the United States. The company, headquartered in Horsham, Pennsylvania, a suburb of Philadelphia, owns six of the top twelve fresh bread brands in the United States, including Entenmann's, Sara Lee, and Thomas. It is also a top advertising sponsor for many major soccer teams around the globe.

Altria - HR

Fix Access Database to report on premium payments for benefits department

ATC Panels

Built Access database for manufacturing plant tracking production efficiency

Our Clients Include:

  • The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
    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
    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
    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
    Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database