Jacksonville North Carolina

Microsoft Access Database in Jacksonville, North Carolina

Jacksonville is a city in Onslow County, North Carolina, United States. As of the 2010 United States census, the population stood at 70,145, which makes Jacksonville the 14th largest city in North Carolina. Jacksonville is the principal city of Onslow County and is included in the Jacksonville, North Carolina metropolitan area. In 2014, Forbes magazine ranked Jacksonville as the fifth fastest-growing small city in the United States. Demographically, Jacksonville is the youngest city in the United States with an average age of 22.8 years old, which can be attributed to the large military presence. The low age may also be in part due to the population drastically going up over the past 80 years, from a mere 783 in the 1930 census to 70,145 in the 2010 census. It is the county seat of Onslow County, and the home of the United States Marine Corps' Camp Lejeune and New River Air Station. Jacksonville is located adjacent to North Carolina's Southern Outer Banks (SOBX) area. On 21 June 2016, the City of Jacksonville, NC, became the first jurisdiction to adopt a paid holiday honoring the 13th Amendment to the United States Constitution which made slavery in the United States and its territories illegal. The resolution of adoption targets the prevention of the modern slavery epidemic in the form of human trafficking, which includes forcing children to engage in labor, sex, and combat. In recognition of the history of African Americans (and remembering the Montford Point Marines who faced second class citizenship), Jacksonville honored their heritage and the enfranchisement their ancestors received from the 13th Amendment. The holiday (Freedom Day) will be celebrated on the second Monday in December, which will always fall between the dates of the states' ratification (6 December 1865) and Secretary of State's proclamation of the 13th Amendment to the U.S. Constitution (18 December 1865). We've developed Access Databases in Jacksonville for Camp LeJeune (Hunter/Game tracking access database subcontracted through URS Corporation). 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
  • WSI Web Strategies
    Subcontract build Access & Web applications to Pack & Ride and Vatex and a Soccer Association. We subcontracted to WSI Web Strategies to help their clients. Both are in Richmond, Virginia
  • Epitome Systems
    Network Engineering Firm in Columbia, Maryland.

    They subcontracted us to Fix an Access database for determining hospital emergency room time differentials for their client Bon Secours in Baltimore, MD.

    This Access database was developed 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.
  • UpTime Solutions Professional Services Group
    Network Engineering Firm in Richmond, Virginia.

    This is a Quality tracking and improvement Access database for a manufacturing firm: Greystone in Toano, VA (near Westpoint and Williamsburg).

    This application receives multiple excel files throughout the day that are produced from quality control machiney in the plant. The excel files are imported to the Access database automatically.

    The Access database scrolls through the excel files, parsing out the relevant information from the excel file and appends the relevant data points to a table that is then used to run monthly and quarterly quality control reports.

    The data is pertinent to the automobile manufacturing process and determines which production batches should or should not be accepted for Greystones automobile manufacturing clients.

    We built this database through our strategic partner: Uptime Solutions, a premier network integration and engineering firm in Richmond, VA and Tampa, FL.

Build / Fix your Access Database

How we Build and Fix an Access Database
  • Burgess & Co.
    Fix Access database for accounting firm
  • Hospital Hospitality House
    Developed Access database for charity hotel organization. This hotel management application interacts with both a Topaz Signature pad for capturing hotel guest signatures as well as Adobe Acrobat and for producing .pdf files.
  • Hercules Chemical - Alizay
    Supported their Access Database

Integrate Access with Other programs

How Integration Works
  • Hospital Hospitality House
    Developed Access database for charity hotel organization. This hotel management application interacts with both a Topaz Signature pad for capturing hotel guest signatures as well as Adobe Acrobat and for producing .pdf files.
  • Greystone
    Manufacturing Firm in Toano, Virginia.

    We built a Quality tracking database that imports 1000s text files output from manufacturing machinery.

    This microsoft access database reports defects during the manufacturing process for this automotive parts manufacturer

    From Greystone website: Greystone is a global leader in the production of high volume precision machined and plated components for the automotive, aerospace, defense and industrial markets. Specializing in safety critical machining, hard chrome plating, and anodizing, we take pride in developing innovative engineering solutions to difficult problems.
  • Nufarm Americas Inc.
    NuFarm is a pesticide chemical manufacturer based in Australia. They're office in Raleigh North Carolina 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

    From their website: We know that growing is about more than just crops and cultivation. It's about sunshine and rain, early mornings and hard work. It can be frustratingly unpredictable, but also wonderfully uplifting. More than anything, it's about people. Nufarm is the dependable partner behind thousands of agricultural success stories. Every day, growers around the world turn to our products and our people to help with the challenges of fighting disease, weeds and pests, and to increase crop yields.

Here are some clients we have helped in Jacksonville

Client

Project Description

URS Corporation URS, a Fortune 500 Consulting Firm, contacted us to build an Access database for their client: United States Marine Corps: Camp Lejeune.

This Access Database tracks hunting on the Camp grounds through: Hunter Information Screen, License Screen, Violation Screen, and a Rank Maintenance screen. A Record of Sales Report can also be generated. Camp LeJeune is in North Carolina and is a Department of Defense, Military, Marine Corps URS is a prime vendor to the Federal Government and the Military Branches. This Access database helped this US Marine Corps base successfuly manage the land use of the base.

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