Access Database Consultants, Programmers and Developers


- VBA Programming

- Fixing Advanced Databases

- Migrating Access to Web

- Connecting Access to SQL Server and MySQL

Philadelphia, Pennsylvania

Access Database Programmers Philadelphia, Pennsylvania



We love Philadelphia!



We build Access Databases in Philadelphia. Our databases often include VBA Programming. Dekra Consulting in Blue Bell (outside of Philadelphia) is one of our clients with a very complex Access Database we modify and support as they need changes completed.

Thank you Wikipedia:
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 Germany—the 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.

Our sister company: Data-Bolt.com PHP and MySQL developers and programmers for web applications: Data-blade.com

Specifc Access database expert solutions are here

We also build Access databases in Los Angeles California

>We also build Access databases in Houston Texas

Thank you Photographer for great picture!!!



Clients
  • 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.
  • Epitome Systems
    Network Engineering Firm in Columbia, Maryland.

    They subcontracted us to Fix an Access database for determining hospital emergency room time differentials for their client Bon Secours in Baltimore, MD.

    This Access database was developed to track efficiency of the emergency room operation at Hospitals for Bon Secours. The various stages of a patient's visit are tracked and the minutes recorded for moving through each stage of the emergency room visit.

    This database uses extensive Forms that have built to provide the quickest data entry possible for the user.
  • UpTime Solutions Professional Services Group
    Network Engineering Firm in Richmond, Virginia.

    This is a Quality tracking and improvement Access database for a manufacturing firm: Greystone in Toano, VA (near Westpoint and Williamsburg).

    This application receives multiple excel files throughout the day that are produced from quality control machiney in the plant. The excel files are imported to the Access database automatically.

    The Access database scrolls through the excel files, parsing out the relevant information from the excel file and appends the relevant data points to a table that is then used to run monthly and quarterly quality control reports.

    The data is pertinent to the automobile manufacturing process and determines which production batches should or should not be accepted for Greystones automobile manufacturing clients.

    We built this database through our strategic partner: Uptime Solutions, a premier network integration and engineering firm in Richmond, VA and Tampa, FL.
  • Old Dominion Controls, LLC
    Old Dominion Controls: Over 25 years of serving the natural gas industries of Virginia and Tennessee. We provide instrumentation and control equipment from the wellhead to the end user in the natural gas world.
  • Virginia Association for Home Care and Hospice
    Fixed and modifed an exiting Access database for an Association. This client manages their client invoicing and payments with an Access Database. They desired to share the database from home and work, so we migrated the data tables to a MySQL database in the cloud (Data Control Servers)
  • 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.
  • API Services
    Precision measurement and tool calibration for manufacturing clients, we built an Access database for API Sensor that tracks associates timesheets and expenses for management reporting and reimbursement/payroll. This application connects to SQL Server which is hosted on Data Control's Web Server. 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.
  • 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.
  • 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

Project Description

DEKRA Certification, Inc.

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.

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.

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
  • The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
    The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
  • Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
    Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
  • 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