Chicago Illinois

Microsoft Access Chicago Illinois

Chicago , officially the City of Chicago, is the third-most populous city in the United States. With over 2.7million residents, it is also the most populous city in both the state of Illinois and the Midwestern United States. It is the county seat of Cook County. The Chicago metropolitan area, often referred to as Chicagoland, has nearly 10million people and is the third-largest in the United States. Chicago has often been called a global architecture capital and is considered one of the most important business centers in the world. Chicago was incorporated as a city in 1837 near a portage between the Great Lakes and the Mississippi River watershed and grew rapidly in the mid-nineteenth century. After the Great Chicago Fire of 1871, which destroyed several square miles and left more than 100,000 homeless, the city made a concerted effort to rebuild on the damage. The construction boom accelerated population growth throughout the following decades, and by 1900 Chicago was one of the five largest cities in the world. During this period, Chicago made noted contributions to urban planning and zoning standards, new construction styles (including the Chicago School of architecture), the development of the City Beautiful Movement, and the eventual creation of the steel-framed skyscraper. Positioned along Lake Michigan, the city is an international hub for finance, commerce, industry, technology, telecommunications, and transportation. O'Hare International Airport is the second-busiest airport in the world when measured by aircraft traffic; the region also has the largest number of U.S. highways and railroad freight. In 2012, Chicago was listed as an alpha global city by the Globalization and World Cities Research Network, and it ranked seventh in the world in the 2016 Global Cities Index. Chicago has the third-largest gross metropolitan product in the United Statesabout $640billion according to 2015 estimates. The city has one of the world's largest and most diversified economies, with no single industry employing more than 14% of the workforce. In 2016, Chicago hosted a record 54million domestic and international visitors, making it one of the most visited cities in the United States. Landmarks in the city include Millennium Park, Navy Pier, the Magnificent Mile, the Art Institute of Chicago, Museum Campus, the Willis (Sears) Tower, the Museum of Science and Industry, and Lincoln Park Zoo. Chicago's culture includes the visual arts, novels, film, theater (especially improvisational comedy), and music, particularly jazz, blues, soul, hip-hop, gospel, and house music. There are many colleges and universities in the Chicago area, of which Northwestern University, the University of Chicago, and the University of Illinois at Chicago are classified as "highest research" doctoral universities. Our clients in Chicago include Ferrara Candy Corporation. The Access database we've built for Ferrara tracks Overall Equipment Effectiveness and provides transparency to their candy production operations. This Access database uses a SQL Server data file on Ferrara Servers. All of the reports we've built for them (30) export seamlessly to excel for further analysis. We also work with Blake Law Firm in Chicago. We house their Access attorney Matter Tracking database on our server.


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 Chicago

Client

Location

Project Description

Blake Law Firm Chicago, IL Fixed and modified Access Database for matter tracking for a Chicago Illinois attorney firm. We also host this database on our server for them.

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