Philadelphia Pennsylvania

Microsoft Access Philadelphia Pennsylvania

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

Philadelphia is the largest city in the Commonwealth of Pennsylvania and the sixth-most populous city in the United States, with an estimated population of 1,567,872 and more than 6million in the seventh-largest metropolitan statistical area, as of 2016. Philadelphia is the economic and cultural anchor of the Delaware Valley region, located along the lower Delaware and Schuylkill Rivers. The region's population of 7.2million ranks it as the eighth-largest combined statistical area in the United States. William Penn, an English Quaker, founded the city in 1682 to serve as capital of the Pennsylvania Colony. Philadelphia played an instrumental role in the American Revolution as a meeting place for the Founding Fathers of the United States, who signed the Declaration of Independence in 1776 at the Second Continental Congress, and the Constitution at the Philadelphia Convention of 1787. Several other key events occurred in Philadelphia during the Revolutionary War including the First Continental Congress, the preservation of the Liberty Bell, the Battle of Germantown, and the Siege of Fort Mifflin. Philadelphia was one of the nation's capitals during the revolution, and served as temporary U.S. capital while Washington, D.C., was under construction. In the 19th century, Philadelphia became a major industrial center and a railroad hub. The city grew from an influx of European immigrants, most of whom came from Ireland, Italy and Germanythe three largest reported ancestry groups in the city as of 2015. In the early 20th century, Philadelphia became a prime destination for African Americans during the Great Migration after the Civil War, as well as Puerto Ricans. The city's population doubled from one million to two million people between 1890 and 1950. The Philadelphia area's many universities and colleges make it a top study destination, as the city has evolved into an educational and economic hub. According to the Bureau of Economic Analysis, the Philadelphia area had a gross domestic product of US$431billion in 2016, the eighth-largest metropolitan economy in the United States.[14] Philadelphia is the center of economic activity in Pennsylvania and is home to five Fortune 1000 companies. The Philadelphia skyline is expanding, with a market of almost 81,900 commercial properties in 2016, including several nationally prominent skyscrapers. Philadelphia has more outdoor sculptures and murals than any other American city. Fairmount Park, when combined with the adjacent Wissahickon Valley Park in the same watershed, is one of the largest contiguous urban park areas in the United States. The city is known for its arts, culture, and colonial history which attracted 42 million domestic tourists in 2016 who spent $6.8 billion, generating an estimated $11 billion in total economic impact in the city and surrounding four counties of Pennsylvania.[20] Philadelphia has also emerged as a biotechnology hub. We modified a complex Access database for Dekra Consulting. This database existed but was slow and unnecessarily complex. We improved the VBA code and made that application easier to understand and quicker.


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.

Here are some clients we have helped in Philadelphia

Client

Location

Project Description

Ritchie & Associates Philadelphia, PA 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.
DEKRA Certification, Inc. Philadelphia, PA DEKRA Consulting is a Germany based company. Their Phildelphia office uses an Access Database as the backbone of their USA practice. It tracks clients, consultants, and the status of consulting project/engagements.

We took their back end Access tables and converted them to MySQL tables. We then migrated the data from the current Access database to the MySQL tables.

Now DEKRA's employees may easily use the database across the country and the world.

We provided a free Microsoft Access quote for this project and then did the work

We did this work for the DEKRA office in Philadelphia, PA.

From the Dekra Website (https://www.dekra-consulting.com/en/process-optimisation): We have a proven track record improving quality, business performance, people skills, workflows and processes of our global clients. Today our team serves a variety of industrial clients, but the core of our expertise was built in the role of preferred partner to the global automotive industry. Our strong international presence, industry expertise and close ties with the automotive trade result in high recognition amongst manufacturers, importers, dealers, independent repairer chains, suppliers and automotive service providers.

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