Charlotte North Carolina

Microsoft Access Charlotte North Carolina

Data Control, LLC is a group of Microsoft Access Gurus with 20+ years of experience serving Business, Military, Government and University Clients

We Scope projects with you, provide you a quote, and deliver professional databases.

We often modify existing databases

Charlotte is the most populous city in the U.S. state of North Carolina. It is the county seat of Mecklenburg County. In 2016, the U.S.Census Bureau estimated the population was 842,051, making it the 17th-most populous city in the United States. The Charlotte metropolitan area ranks 22nd-largest in the U.S., and had a 2016 population of 2,474,314. The Charlotte metropolitan area is part of a sixteen-county market region or combined statistical area with a 2016 U.S.Census population estimate of 2,632,249. Between 2004 and 2014, Charlotte was ranked as the country's fastest growing metro area, with 888,000 new residents. Based on U.S. Census data from 2005 to 2015, it also tops the 50 largest U.S. cities as the millennial hub. It is the second-largest city in the southeastern United States, just behind Jacksonville, Florida. It is the third-fastest growing major city in the United States. It is listed as a "gamma-minus" global city by the Globalization and World Cities Research Network. Residents are referred to as "Charlotteans". Charlotte is home to the corporate headquarters of Bank of America and the east coast operations of Wells Fargo, which along with other financial institutions made it the second-largest banking center in the United States from 1995 to 2017 and the third-largest from 2017 to present. Among Charlotte's many notable attractions, some of the most popular include the Carolina Panthers of the National Football League (NFL), the Charlotte Hornets of the National Basketball Association (NBA), the Charlotte Independence of the United Soccer League (USL), the Charlotte Hounds of Major League Lacrosse, two NASCAR Cup Series races and the NASCAR All-Star Race, the Wells Fargo Championship, the NASCAR Hall of Fame, the Charlotte Ballet, Carowinds amusement park, and the U.S. National Whitewater Center. Charlotte Douglas International Airport is a major international hub, and was ranked the 23rd-busiest airport in the world by passenger traffic in 2013. Charlotte has a humid subtropical climate. It is located several miles east of the Catawba River and southeast of Lake Norman, the largest man-made lake in North Carolina. Lake Wylie and Mountain Island Lake are two smaller man-made lakes located near the city. We've developed Access Databases in Charlotte for Porter's Construction Printing and Matlen Silver Group (Federal Government Contractor that subcontracted us to their Army client for an inventory database). 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
  • Strategic Technology Systems
    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).

    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.
  • B to B Solutions
    Partner / Subcontract to build Access, SQL Server, .NET applications for their clients: Chemical Engineering client DuPont, their staffing client Apex Systems, Their health industry client Result Performance, and their insurance client Affinity Group Underwriters in Richmond, VA
  • Ritchie & Associates
    Ritchie is a management consulting firm headquartered outside of Los Angeles, California. They consult with Fortune 500 firm Meadwestvaco (now WestRock). They advised the paper and packaging firm to build an historical demand based Access Database. It incorporated not only ERP (SAP) sourced 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.

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
  • 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.
  • PepsiCo Worldwide Flavours
    Built Access Database for Concentrate portion of Bottling Business. This Access database is used for tracking productivity of resources within the manufacturing / bottling facility. We modified a previous Access database built for the Pepsi Pennsylvania plant and imported raw data from Excel.

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.

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