Charlotte North Carolina

Microsoft Access Charlotte North Carolina

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

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