Harrisonburg Virginia

Microsoft Access Harrisonburg Virginia

We've developed Access Databases in Harrisonburg for Ball Corporation (Manufacturing database tracking clients and invoices). These are professionally built database with advanced navigation forms, criterion for reports, and normalized table structure.


Subcontract / Partner with us for your Client's database

How Partnership Works
  • ACSG
    Subcontractor to Build Access Database for tracking contract information for their Military client: Air Force Bases in Washington DC. ACSG is a Federal Prime Vendor and they went after a military contract that desired Access databases to manage contracts for the military bases in DC. This Access database we developed was identical but rolled out separately to manage the contracts that each Air Force base currently had in existence.
  • Networking Technologies and Support
    This Access database for a conveyor manufacturing company tracks is a project management database with multiple dates for the completion of manufacturing and engineering tasks with advanced calendaring.
  • MatlenSilver Group ltd.
    Partner / Subcontracted to their Tobacco /Food Manufacturing Philip Morris (now Altria) for Manufacturing Training Tracking in Richond, VA. Matlen Silver is a staffing firm with a contract at Altria, the tobacco and food products giant. 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

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
  • Boone Homes, Inc.
    Build access database for residential home builder: Warranty Management
  • Crenshaw Corporation
    Build Access database for scheduling Truck Body work

Integrate Access with Other programs

How Integration Works
  • Selma's Cookies
    Selma found us on the internet about 10 years ago. We've been modifying and supporting her Access database since then. This is a customer order management database that helps Selma keep track and fulfill Yahoo orders. This database imports from Excel derived spreadsheets that are produced by Yahoo and stages these orders to fulfillment and shipping. This Access Database application also integrates with a barcode scanner and the FedEx software for creating shipping labels.
  • 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.
  • 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.

Here are some clients we have helped in Harrisonburg

Client

Location

Project Description

Blue Ridge Products Richmond, VA FTP integration with Access 2013. Blue Ridge creates orders and FTPs those orders to various warehouses including Amazon's warehouses to further process those orders. Blue Ridge is an import company that creates their own products, has them produced in China, imports those products to the United States and sells (mostly) through Amazon. This Access database is the central backbone for the company. It details all of the products, sales of those products, forecasts of the product sales, tracks current inventor levels etc. In addition to integrating with FTP software, this database has complex integration with Excel, both importing/massaging excel files as well as producing Excel files for both the company's internal personnel as well as the various warehouses used by the company. We provided the Microsoft Access training and documentation
Bravo Wine Imports Harrisonburg, VA Bravo Imports Wine mostly from Italy and sells, through agents, to restaurants and markets including Kroger. This database application provides both a web page for entering orders as well as Quickbooks integration for creating invoices from those orders and updating current inventory and product lists. This is accomplished through an ODBC connection directly to Quickbooks. Agents and Items are managed through the Access database which communicates with the Website via MySQL connection (attached tables in the Access database). When Agents place orders, those order are viewed in the Access database, massaged and approved. Again through the use of attached MySQL tables. Bravo Wine is in Harrisonburg, Virginia. We provided the Microsoft Access help for this project

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