// Looking for Access Experts?
Access Database Consulting
Last updated: April 2026
PCG provides Microsoft Access consulting for every situation: a database that is throwing errors and the original developer is gone, a system that worked at 5,000 records and now crawls at 80,000, a business that needs Access connected to SQL Server or the cloud, and organizations that need a new Access application built correctly from the start. PCG has worked with Access since its first release. Most engagements are scoped within one business day.1
What does PCG's Access database consulting actually cover?
The grid below maps every category of Access consulting PCG handles. Each cell represents a distinct engagement type. Most clients need one or two. Some need several in sequence as their system evolves.
Rescue
Emergency Repair, Recovery, and Troubleshooting
Database throwing errors, corrupted records, or behaving unpredictably after an Office update. PCG diagnoses the problem before touching anything, then repairs or recovers what is broken. VBA code failures after version changes, broken queries, and form errors that appeared after a user modification are all covered. Most Access emergencies are diagnosed within hours of first contact.
Performance
Query Optimization and Schema Restructuring
A database that ran acceptably at lower record counts and now takes minutes to open a form or run a report. PCG audits query structure, index design, and table relationships, rewrites the slow components, and restructures the schema where the architecture is the underlying cause. Most optimization engagements are completed in one to two weeks without replacing the application.
New Build
Full-Cycle Custom Access Application Development
Building a new Access database from requirements gathering through deployment. PCG works with your team to document functional requirements, designs the table structure and relationships, builds forms and reports, writes VBA automation logic, migrates any existing data, and delivers a tested application with complete documentation. PCG can also enter the development process at any stage if a partial build already exists.
Redesign
Legacy Application Redesign and Refactoring
Outdated Access applications that work but are built on a structure that no longer supports the business need: poorly normalized tables, undocumented VBA logic, forms that have been patched repeatedly without addressing the underlying design. PCG reverse-engineers what the application does, refactors the code and schema, and delivers a rebuilt application on a maintainable foundation with the same business logic preserved.
Reporting
Business Intelligence Reports, Charts, and Dashboards
Creating or rewriting Access reports, management dashboards, and data visualizations including charts and graphs for operational and executive reporting. PCG builds reports from multiple related tables, with VBA automation for scheduled runs and distribution. If your current reports produce inconsistent results or require manual cleanup before they can be trusted, PCG traces the query logic producing the error and corrects it at the source.
Migration
Access to SQL Server and Cloud Migration
When user count, data volume, or multi-location requirements exceed what Access can handle, PCG migrates the back-end to SQL Server or a cloud-hosted platform such as Azure SQL or AWS RDS. The Access front-end stays in place or is replaced with a .NET web application or Excel interface depending on what the business needs. Every record is validated after migration. Business logic stays intact.
Web
Access Web Applications and Multi-Device Access
Building and implementing Access applications that run through a standard web browser, allowing access from multiple locations and devices without a shared network file. PCG builds these on SQL Server or cloud back-ends with Access or browser-based front-ends. For organizations that need mobile access to their Access data, PCG implements PowerApps connections to the underlying database where the data structure supports it.
Integration
System Conversion, Integration, and Platform Customization
Converting data and workflows from one system to another, connecting Access to QuickBooks, CRM platforms, Excel, or other business systems via ODBC, import/export routines, or API-based integrations. PCG maps every data field and business process before beginning a conversion to verify that nothing is lost or distorted in the transfer. Existing platform-based products are customized with Access front-ends where direct integration is more cost-effective than a full rebuild.
Support
Ongoing Support, Upgrades, and Training
Long-term maintenance and support for Access databases PCG has built or taken over from other developers. Covers database upgrades from older Access versions to current releases, compatibility reviews before major Windows or Office updates, minor modifications as business requirements change, and staff training covering both end-user operation and developer-level VBA and query skills. Support is provided by the same developers who know the system.
Which industries has PCG consulted on Access databases across?
PCG has built and repaired Access databases across more than 15 industries since 1995. The industries below represent documented project history, not aspirational claims.
- Environmental compliance and remediation operations
- Municipal and commercial fleet management
- Healthcare staffing and physician credentialing
- Airport ground support equipment management
- Industrial safety and OSHA compliance tracking
- Manufacturing: job costing and production scheduling
- Nonprofit organization data management
- Construction estimating and project management
- Retail inventory and point-of-sale systems
- Financial services and audit trail management
- Public safety: dispatch and incident tracking
- Educational institutions and records management
- Professional services: client and project tracking
- Transportation and logistics compliance
- Government contractors and regulatory reporting
What this means for your project
If your industry is on this list, PCG has worked with the data your operation produces. Compliance record structures, operational workflows, reporting requirements, and the specific ways Access is used and abused in your sector are not new problems for PCG to learn. That depth of prior work means less time spent explaining the domain and more time spent solving the specific problem your database has today.
If your industry is not on this list, that does not rule out PCG. The underlying Access consulting disciplines apply across sectors. The domain learning happens during the scoping conversation.
PCG has answered every call from every industry with the same standard: diagnose before touching, explain the options before committing, deliver what was scoped, and document what was built. Since 1995.
How do you know which type of Access consulting engagement you actually need?
Most clients who contact PCG describe a symptom: the database is slow, or it is throwing an error they do not understand, or the developer who built it is gone. The engagement type follows from the diagnosis, not from the symptom. PCG scopes every Access engagement after a brief assessment of the current database, not from a menu of predefined service packages.
| What You Are Experiencing | Likely Engagement Type | Typical Timeline |
|---|---|---|
| Errors, crashes, or corrupted records | Emergency repair and recovery | 1-5 business days |
| Forms or reports take minutes to load | Query and schema optimization | 1-2 weeks |
| VBA code broke after an Office update | VBA code repair | 2-10 business days |
| Need more users or locations to access the database | SQL Server or cloud migration | 4-10 weeks |
| Original developer gone, no documentation | Reverse-engineering audit, then repair or migration | Audit: 3-7 days. Then project-specific. |
| Need a new database built from scratch | Custom Access application development | 2-8 weeks depending on complexity |
| Reports produce inconsistent or wrong results | Report rebuild or query correction | 3-10 business days |
These timelines assume standard complexity. Databases with undocumented business logic, large data volumes, or multiple external integrations take longer. PCG provides a fixed-scope estimate after the initial assessment. There are no open-ended hourly engagements that expand without a defined output.
What makes PCG different from other Access consultants?
Access consulting in 2026 is dominated by two types of providers: offshore development firms that quote fast but require extensive back-and-forth to understand business context, and individual freelancers who may handle your project well but disappear when something breaks six months later. PCG is neither.
- PCG answers the phone. Every call goes to a developer with direct knowledge of Access, not to a support queue or a project coordinator who has to relay your question. Most Access emergencies are diagnosed the same day.
- PCG has worked with Access since its first release. Allison Woolbert has been building database applications since the early 1980s. PCG was founded in 1995. The failure modes that appear in databases that have been running for 10 or 15 years are not new problems for PCG to diagnose.
- PCG diagnoses before touching anything. No changes are made to your database before the problem is understood and the fix is explained. This matters most in emergency situations where a well-intentioned but poorly understood repair can destroy data that was still recoverable.
- You own what PCG builds. Every engagement delivers full source code ownership, complete documentation, and schema notes that let any qualified developer maintain or extend the work without returning to PCG.
- PCG tells you when migration is the right answer. Some Access databases have structural problems that repair will not hold. PCG will say so directly after the initial assessment, explain the numbers, and give you the choice between continued repair and migration. No engagement is extended unnecessarily.
PCG has built and repaired Access databases across more than 500 deployed applications since 1995. That number represents every type of Access problem: databases inherited from developers who are gone, systems that worked fine for years and started failing as the business grew, and applications that were built incorrectly from the start and accumulated problems with every new record added.
The common thread in every successful engagement: diagnose the real problem before proposing a solution. PCG does not sell a fix before understanding what is broken.
1 Engagement scoping timelines based on PCG standard assessment process for Access consulting inquiries, 2020-2026.
2 Industry experience documented from PCG project records across Access consulting, development, and migration engagements since 1995.
Frequently Asked Questions
Yes. Most Access consulting engagements PCG handles involve databases built by someone else. PCG reverse-engineers the existing structure from the code and data rather than from documentation, maps what the database actually does, identifies what is wrong and why, and either repairs the existing application or migrates it depending on what the assessment reveals. The absence of the original developer, and the absence of documentation, extends the assessment phase but does not prevent the engagement.
PCG reviews the database structure, examines the table relationships and query design, identifies any VBA code that is relevant to the problem, and reviews a sample of the actual data. For emergency situations, PCG can begin this assessment remotely within hours of first contact. The assessment produces a clear description of what is wrong, what the fix involves, and what it will cost before any work begins.
Yes. PCG provides ongoing support for every Access database it builds or repairs. Support covers emergency response when something breaks, minor modifications as requirements change, compatibility reviews before major Office or Windows updates, and training for new staff who need to learn the system. Support is provided by the same developers who know the database, not by a separate support team.
Yes. PCG builds integrations between Access and QuickBooks, Sage, and other accounting platforms using ODBC connections, direct file imports, or API-based data exchange depending on what the accounting software supports. These integrations transfer specific data sets: invoices, payments, customer records, or inventory transactions between the two systems on a schedule or on demand, without manual export and re-entry steps.
Multi-location access requires moving the data out of a shared Access file on a network drive. Sharing an Access back-end file over a WAN connection produces locking errors, data corruption, and performance problems that worsen with distance and concurrent user count. PCG migrates the back-end to a cloud-hosted SQL database, such as Azure SQL or AWS RDS, and connects the Access front-end to the new back-end. Each location accesses the same data over a standard internet connection without the file-sharing problems.
Emergency repair engagements for isolated problems typically run between $1,500 and $5,000 depending on the complexity of the issue and the amount of reverse-engineering required. Optimization engagements for performance problems typically run between $2,000 and $6,000. Full migration projects from Access to SQL Server run between $8,000 and $25,000 depending on database size and complexity. New custom Access application development runs between $3,000 and $20,000. PCG provides a fixed-price estimate after the initial assessment for every engagement type.
PCG works with every version of Access from Access 2000 through the current Microsoft 365 release. This includes databases built in older versions that have not been upgraded, and databases that were migrated between versions and broke during the transition. If you are running a version of Access that Microsoft no longer supports and are experiencing compatibility problems with current Windows or Office versions, PCG can assess the upgrade path and its implications for your existing data and code.
Yes. PCG builds VBA-automated reporting routines that run on a defined schedule: daily, weekly, monthly, or triggered by a specific event in the database. Automated reports can export to Excel, PDF, or email distribution lists without manual intervention. This is a common requirement for compliance reporting, weekly management summaries, and operational dashboards that need to be available to leadership without someone running them manually each time.