Access Database Consultants, Programmers and Developers

- Web Enabling Access

- Migrating Access To Cloud

- Migrating Access to the Web

- Access and Excel Visual Basic for Applications (VBA) programming

Importing Data Files

Repetitive data file import is a very common task in Access databases. Oftentimes, the source is a .csv file (comma separated value). But there are lots of other data files that we've imported including Excel files, Quickbook files, SAP files

Here are some clients we have helped:

Client

Location

Project Description

Old Dominion Controls, LLC

Richmond, VA

Old Dominion Controls: Over 25 years of serving the natural gas industries of Virginia and Tennessee. We provide instrumentation and control equipment from the wellhead to the end user in the natural gas world.

CSG Store

Richmond, VA

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

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