Access Database Consultant Developer Programmer

Programmer

Programmer

Access Database Experts. We follow commonly accepted practices for database and VBA (Visual Basic for Applications) development. 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