Yorktown Virginia

Microsoft Access Yorktown Virginia

Yorktown is a census-designated place (CDP) in York County, Virginia, United States. It is the county seat of York County, one of the eight original shires formed in colonial Virginia in 1682. Yorktown's population was 195 as of the 2010 census, while York County's population was 66,134 in the 2011 census estimate. The town is most famous as the site of the siege and subsequent surrender of General Charles Cornwallis to General George Washington and the French Fleet during the American Revolutionary War on October 19, 1781. Although the war would last for another year, this British defeat at Yorktown effectively ended the war. Yorktown also figured prominently in the American Civil War (18611865), serving as a major port to supply both northern and southern towns, depending upon who held Yorktown at the time. Today, Yorktown is one of three sites of the Historic Triangle, which also includes Jamestown and Williamsburg as important colonial-era settlements. It is the eastern terminus of the Colonial Parkway connecting these locations. Yorktown is also the eastern terminus of the TransAmerica Trail, a bicycle touring route created by the Adventure Cycling Association. One of Yorktown's historic sister cities is Zweibrcken in Germany, based on participation of a unit from there during the American Revolutionary War. We have built an overall project management database for a conveyor belt manufacturer in Yorktown, Virginia. This database tracks the production of complex conveyor belts with complex calendaring reports. This Access database also tracks shipments, financial transactions and client information.


Subcontract / Partner with us for your Client's database

How Partnership Works
  • Greystone
    We built a Quality tracking database that imports text files from machinery and reports defects for this automotive part manufacturer
  • West Broad Hyundai Dealership
    We've built an Access Database that imports lead data from a variety of sources, massages the data and reports it the way the dealership wants to see it.
  • Strategic Technology Systems
    Strategic Technology Systems is a full service IT company that provides consulting and support to their clients that need hardware, networks, servers, etc. running smoothly for their companies. Adam Mears, owner of STS contacted me to build an Access database for his client, The Snead Company, a commercial window supplier to the commercial construction industry. This Access database is web enabled with a SQL Server back end. Additionally it interacts with Sharepoint, providing light document management services. The Snead Company creates proposals for their clients using this Access database and then tracks the progress of those proposals to winning status (or dead status).

Build / Fix your Access Database

How we Build and Fix an Access Database
  • Hercules Chemical - Alizay
    Supported their Access Database
  • Hercules Chemical - Franklin
    Supported their Access Database
  • Glave Firm, The
    A NATIONALLY RECOGNIZED ARCHITECTURE, interior design, and planning firm, Glav & Holmes Architecture was founded in 1965 in Richmond, Virginia. The firm of 60 architects, interior designers, historic preservationists, and supporting staff, maintains a diverse and integrated portfolio demonstrating expertise in numerous market areas, including Higher Education, Cultural, Civic, Hospitality, and Residential. Clients are provided with comprehensive services whether projects involve new buildings, additions to buildings, renovations, or adaptive reuse.

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
  • B to B - DuPont
    SQL Server Admininstration Support
  • Masonomics
    Microsoft Access Database for a commercial mason that sends text messages, connects to SQL Server web database for mobile web pages, and retrieves Timberline project information for project resource scheduling. This is one of the most complex Access Databases we've built considering the number of integrations with other systems.

Here are some clients we have helped in Yorktown

Client

Location

Project Description

Ryson Conveyor Yorktown, VA We were subcontracted to Ryson through our network engineering strategic partner Network Technologies and Solutions (NTS). Ryson's Chief Operating officer had been slowly putting together and Access Database to replace a series of complex Excel files in order to manage the process of building conveyor belts. We took over the Access database, enforced naming conventions, developed easy to use navigation forms and maintenance tables. Now this conveyor manufacturer has a backbone database application that provides completion timeline information to the engineering departments, the manufacturing departments, the finance departments and the sales department. A calendar is created for everyone to see. Huge printouts showing all current projects and the people needed to sign off are printed out and put up throughout the facility. We hope to replace these with direct feeds to monitors.
Networking Technologies and Support Yorktown, VA 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.

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