Williamsburg Virginia

Microsoft Access Williamsburg Virginia

Williamsburg was founded in 1632 as Middle Plantation, a fortified settlement on high ground between the James and York rivers. The city served as the capital of the Colony and Commonwealth of Virginia from 1699 to 1780 and was the center of political events in Virginia leading to the American Revolution. The College of William & Mary, established in 1693, is the second-oldest institution of higher education in the United States and the only one of the nine colonial colleges located in the South; its alumni include three U.S. presidents as well as many other important figures in the nation's early history


Subcontract / Partner with us for your Client's database

How Partnership Works
  • Epitome Systems
    Subcontract to Fix Access database for determining hospital emergency room time differentials for their client Bon Secours in Baltimore, MD. This Access database is used to track efficiency of the emergency room operation at Hospitals for Bon Secours. The various stages of a patient's visit are tracked and the minutes recorded for moving through each stage of the emergency room visit. This database uses extensive Forms that have built to provide the quickest data entry possible for the user.
  • Ritchie & Associates
    Ritchie is a management consulting firm that was working for Fortune 500 firm Meadwestvaco (now WestRock). They were advising the paper and packaging firm to build an historical demand based Access Database. This Access database was used to manage inventory for their paper packaging manufacturing client: MeadWestvaco (Fortune 500) in Richmond, VA. It incorporated not only ERP fed historical demand, but also provided advanced logistic support to this Paper and packaging corporation. This Access database determined optimim supply levels in plants and warehouses throughout the US including Maine, North Carolina, Ohio, California, Texas, Colorado, Washington, Oregon, and Michigan.
  • NTS
    Subcontracted to build Access & SQL server databases to the Virginia Lottery, the Virginia Beach Fire Department, Townes Engineering, EHS Laboratories and more

Build / Fix your Access Database

How we Build and Fix an Access Database
  • Ritchie & Associates
    Ritchie is a management consulting firm that was working for Fortune 500 firm Meadwestvaco (now WestRock). They were advising the paper and packaging firm to build an historical demand based Access Database. This Access database was used to manage inventory for their paper packaging manufacturing client: MeadWestvaco (Fortune 500) in Richmond, VA. It incorporated not only ERP fed historical demand, but also provided advanced logistic support to this Paper and packaging corporation. This Access database determined optimim supply levels in plants and warehouses throughout the US including Maine, North Carolina, Ohio, California, Texas, Colorado, Washington, Oregon, and Michigan.
  • DEKRA Certification, Inc.
    From the Dekra Website (https://www.dekra-consulting.com/en/process-optimisation): We have a proven track record improving quality, business performance, people skills, workflows and processes of our global clients. Today our team serves a variety of industrial clients, but the core of our expertise was built in the role of preferred partner to the global automotive industry. Our strong international presence, industry expertise and close ties with the automotive trade result in high recognition amongst manufacturers, importers, dealers, independent repairer chains, suppliers and automotive service providers. The Access Database they use is the backbone of their USA practice. It tracks clients, consultants, and the status of consulting project/engagements. We took their back end Access tables and converted them to MySQL tables. We then migrated the data from the current Access database to the MySQL tables. DEKRA consulting is in Philadelphia, PA. Now DEKRA's employees may easily use the database across the country and the world. We provided the Free Microsoft Access quote for this project and then did the work
  • 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.

Integrate Access with Other programs

How Integration Works
  • Bravo Wine Imports
    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
  • DEKRA Certification, Inc.
    From the Dekra Website (https://www.dekra-consulting.com/en/process-optimisation): We have a proven track record improving quality, business performance, people skills, workflows and processes of our global clients. Today our team serves a variety of industrial clients, but the core of our expertise was built in the role of preferred partner to the global automotive industry. Our strong international presence, industry expertise and close ties with the automotive trade result in high recognition amongst manufacturers, importers, dealers, independent repairer chains, suppliers and automotive service providers. The Access Database they use is the backbone of their USA practice. It tracks clients, consultants, and the status of consulting project/engagements. We took their back end Access tables and converted them to MySQL tables. We then migrated the data from the current Access database to the MySQL tables. DEKRA consulting is in Philadelphia, PA. Now DEKRA's employees may easily use the database across the country and the world. We provided the Free Microsoft Access quote for this project and then did the work
  • Nufarm Americas Inc.
    NuFarm is a pesticide chemical manufacturer that initially engaged us to build an Access Database to track Environmentl Protection Agency (EPA) forms. They have over 2,000 EPA forms on file with the US Government. Upon further conversation and discovering the intent of this chemical/pesticide client, we decided that an Access Database WAS NOT the proper solution. They desired people AROUND THE WORLD to enter and query their application. So we built this database using PHP web pages and a SQL Server data file. You may find more information about this application at www.data-blade.com

Here are some clients we have helped in Williamsburg

Client

Location

Project Description

Ensafe Richmond, VA Subcontracted to build a web application/SQL Server database for their Military client: Camp Peary, Department of Defense, CIA training in Williamsburg, VA. This database tracks the hazardous materials brought onto the military base, the current inventory levels of those hazardous materials, and the disposal of the hazardous materials. The Access database produces the annual reports required by the Environmental Protection Agency including Form R and Tier I and Tier II reports. We were the Microsoft Access Database consultants 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