Yorktown, Virginia

access database consultant developer programmer staunton 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 (1861–1865), 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 Zweibrücken 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.

Clients
  • LOMC, LLC / PrimeLegal
    LOMC LC / Prime Legal is a prepaid law firm. We built a web application to manage their referral network
  • GUSA Soccer
    GUSA Soccer is a Soccer league in Goochland, Virginia. We built a website to manage their player registations
  • At Home Care
    AT Home Health and Hospice Care is an established, full-service home health agency and hospice that provides a superior quality of services in a caring manner. We built a web application to manage their Doctor sign off process
  • Dominion Partners
    Dominion Partners desired an Access Guru to build an access database to manage their investment banking back office operations. They contracted us for this Access Database project.
  • Holiday Signs
    Holiday Signs need an expert Access Database consultant to revise their Customer Relationship Manager application. This is an Access database that provides at-your-fingertip pipeline data to help both the salesmen and sales managers keep track of ongoing sales leads. Metrics come out of this database to help evaluate and improve sales performance.

    We are also the PHP Developer and MySQL Consultant for Holiday signs. You may find more information about these services here: Data Bolt provides PHP and MySQL consulting
  • Maisonettes Apartments
    Maisonnettes Apartments runs an apartment complex and a trailer park. We upgraded their previous DOS based monthly rent collection application into an Access Database. Now all functionality of tracking tenants monthly rent is handled in Access. This database also provide the lease agreements and tracks historical tenants (tenants that have previously lived at the property)
  • API Services
    Precision measurement and tool calibration for manufacturing clients, we built (and Host) a MySQL database for API Sensor that tracks associates timesheets and expenses for management reporting and reimbursement/payroll. This is a backoffice application that runs the expense side of a company with geographically dispersed employees. They track their billable time and expenses, assigning both to projects/clients.
  • Strategic Technology Systems
    An Access database with a SQL Server back end was already in place at CeMark, STS's client. We were asked to migrate the data file to a new version of SQL Server.
  • ActivSupport
    ActivSupport contacted us to fix various SQL Server, and Sharepoint Databases for their clients in Charlottesville, VA.

    Active Support needed an expert database consulting company to support their clients without having to worry about the end results. Keeping their client happy was most important to ActivSupport. By supplying professional database developers to ActivSupport and their clients, we kept both our partner and their client happy

Here are some clients we have helped in Yorktown

Client

Project Description

Ryson Conveyor

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.

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
  • 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