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

Developer

Developer

We are Microsoft Access Database Developers. With 25 years of experience servicing business and government clients including Pepsi, Capital One, the states of Virginia and Maryland, and the US Navy; we follow commonly accepted practices for databases and VBA (Visual Basic for Applications) development.

We offer free shared view sessions to discuss your project. Please call us to set up an appointment or email us using the submission form above.

Do you want to migrate your Excel spreadsheet to Microsoft Access? We do that.

Do you want to integrate your excel spreadsheet with Microsoft Access? We do that.

Do you want to tie your Access database to your website, SQL Server or MySQL backend database? We do that.

Do you want to place your data in the cloud while keeping your Access databases forms/queries/reports? We do that.

Do you want to integrate your Access database with Outlook email and scheduling? We do that.

Do you want your Access database to produce .pdf files for your clients' quotes or invoices or any other reason? We do that.

Do you want to perform light document management with your Access database? We do that.

Do you want to connect your Access database to your Accounting System, SAP, Timberline, JD Edwards or any other ERP system? We do that.



Concerning our Microsoft Access Development, this is how we approach being professional developers:

We employ naming conventions on our database objects. Upon request we will also emply naming conventions on field names. We limit the use of queries to be essential objects that are helpful in the query window. We place SQL Statements mostly in Form/Report record sources and drop down row sources. We make every effort to make forms single table based and rely on drop downs to bring in information from other tables (or dlookups) and subforms for entire tables of related information.

We use Office automation regularly to connect access to Excel, Word, Outlook, Quickbooks and other programs. We have connected many databases to ERP and web databases such as MySQL, SQL Server, JD Edwards, SAP, Timberline and more.

We support mission critical databases. Our clients rely on the day-to-day operations of their Access databases. And they retain us to be available on an as needed basis. Examples of these database include Ferrara Candy's Operation Equipment Effectiveness database, Pepsi Bottling's Plant Tracking System, The Naval Observatory's Inventory database, Isometric (Vendor the the US Army)'s equipment part inventory and use and future demand database, Sequoia Tax' client list database, Dekra Consulting's back office account, audit and certification management database, ADV's order processing and inventory database.


Here are some clients we have helped:

Client

Location

Project Description

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