Pittsburgh Pennsylvania

Microsoft Access Pittsburgh Pennsylvania

Pittsburgh is a city in the Commonwealth of Pennsylvania in the United States, and is the county seat of Allegheny County. As of 2017, a total population of 305,704 lives within the city limits, making it the 63rd-largest city in the U.S. The metropolitan population of 2,353,045 is the largest in both the Ohio Valley and Appalachia, the second-largest in Pennsylvania (behind Philadelphia), and the 26th-largest in the U.S. Located at the confluence of the Allegheny, Monongahela, and Ohio rivers, Pittsburgh is known as both "the Steel City" for its more than 300 steel-related businesses, and as the "City of Bridges" for its 446 bridges. The city features 30 skyscrapers, two inclined railways, a pre-revolutionary fortification and the Point State Park at the confluence of the rivers. The city developed as a vital link of the Atlantic coast and Midwest, as the mineral-rich Allegheny Mountains made the area coveted by the French and British empires, Virginians, Whiskey Rebels, and Civil War raiders. Aside from steel, Pittsburgh has led in manufacturing of aluminum, glass, shipbuilding, petroleum, foods, sports, transportation, computing, autos, and electronics. For part of the 20th century, Pittsburgh was behind only New York and Chicago in corporate headquarters employment; it had the most U.S. stockholders per capita. America's 1980s deindustrialization laid off area blue-collar workers and thousands of downtown white-collar workers when the longtime Pittsburgh-based world headquarters moved out. This heritage left the area with renowned museums, medical centers, parks, research centers, libraries, a diverse cultural district and the most bars per capita in the U.S. Today, Google, Apple, Bosch, Facebook, Uber, Nokia, Autodesk, and IBM are among 1,600 technology firms generating $20.7 billion in annual Pittsburgh payrolls. The area has served as the long-time federal agency headquarters for cyber defense, software engineering, robotics, energy research and the nuclear navy.The area is home to 68 colleges and universities, including research and development leaders Carnegie Mellon University and the University of Pittsburgh. The nation's eighth-largest bank, eight Fortune 500 companies, and six of the top 300 U.S. law firms make their global headquarters in the Pittsburgh area, while RAND, BNY Mellon, Nova, FedEx, Bayer and NIOSH have regional bases that helped Pittsburgh become the sixth-best area for U.S. job growth. In 2015, Pittsburgh was listed among the "eleven most livable cities in the world";The Economist's Global Liveability Ranking placed Pittsburgh as the first- or second-most livable city in the United States in 2005, 2009, 2011, 2012 and 2014.The region is a hub for Leadership in Energy and Environmental Design, sustainable energy, and energy extraction We've been making Access Database changes for Global Delivery. They already had an Access Database in place, but need an expert consultant to make further changes.


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 Pittsburgh

Client

Location

Project Description

Gateway Global Delivery Pittsburgh, PA Gateway provides logistics services to their clients. The Access database we modified for them imports data files from FedEx. This data is then manipulated into complex invoices to send to Gateway's clients. This access database improves the efficiency of the overall organization. We were the Access database consultants for this project.

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