Pittsburgh, Pennsylvania

Microsoft Access Database in 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.

Clients
  • LOMC, LLC / PrimeLegal
    LOMC LC / Prime Legal is a prepaid law firm. We built a web application to manage their referral network
  • GUSA Soccer
    GUSA Soccer is a Soccer league in Goochland, Virginia. We built a website to manage their player registations
  • At Home Care
    AT Home Health and Hospice Care is an established, full-service home health agency and hospice that provides a superior quality of services in a caring manner. We built a web application to manage their Doctor sign off process
  • Dominion Partners
    Dominion Partners desired an Access Guru to build an access database to manage their investment banking back office operations. They contracted us for this Access Database project.
  • Holiday Signs
    Holiday Signs need an expert Access Database consultant to revise their Customer Relationship Manager application. This is an Access database that provides at-your-fingertip pipeline data to help both the salesmen and sales managers keep track of ongoing sales leads. Metrics come out of this database to help evaluate and improve sales performance.

    We are also the PHP Developer and MySQL Consultant for Holiday signs. You may find more information about these services here: Data Bolt provides PHP and MySQL consulting
  • Maisonettes Apartments
    Maisonnettes Apartments runs an apartment complex and a trailer park. We upgraded their previous DOS based monthly rent collection application into an Access Database. Now all functionality of tracking tenants monthly rent is handled in Access. This database also provide the lease agreements and tracks historical tenants (tenants that have previously lived at the property)
  • API Services
    Precision measurement and tool calibration for manufacturing clients, we built (and Host) a MySQL database for API Sensor that tracks associates timesheets and expenses for management reporting and reimbursement/payroll. This is a backoffice application that runs the expense side of a company with geographically dispersed employees. They track their billable time and expenses, assigning both to projects/clients.
  • Strategic Technology Systems
    An Access database with a SQL Server back end was already in place at CeMark, STS's client. We were asked to migrate the data file to a new version of SQL Server.
  • ActivSupport
    ActivSupport contacted us to fix various SQL Server, and Sharepoint Databases for their clients in Charlottesville, VA.

    Active Support needed an expert database consulting company to support their clients without having to worry about the end results. Keeping their client happy was most important to ActivSupport. By supplying professional database developers to ActivSupport and their clients, we kept both our partner and their client happy

Here are some clients we have helped in Pittsburgh

Client

Project Description

Our Clients Include:

  • The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
    The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
  • Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database
    Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database