// Not Sure Where to Start?
Microsoft Access Solutions
Last updated: April 2026
PCG has been building custom Microsoft Access database applications since version 1.0. In 2026, we handle every Access engagement: new builds from requirements to delivery, repair and rescue for databases the original developer left behind, migration to SQL Server or the cloud when Access has been outgrown, and ongoing support for systems in active production. PCG has worked with Access across every version from 1.0 through Microsoft 365.1
30+
Years building Access applications since version 1.0
500+
Custom database applications deployed across all industries
15+
Industries served with documented project history
100%
Source code ownership transferred to client at delivery
What Microsoft Access service does your situation require?
The four pages below cover every Access engagement type PCG handles. Each one addresses a specific situation. If you are not sure which applies to your problem, the consulting page covers assessment and diagnosis as a starting point.
Access Database Consulting
Emergency repair, VBA troubleshooting, performance optimization, migration assessment, and ongoing support. The starting point when you have an Access problem and are not sure what the right fix is.
Access Database Design
Table structure, normalization, primary keys, relationships, and referential integrity. The foundation work that determines whether an Access database produces clean data or accumulates structural problems over time.
Access for Rapid Data Development
Building new Access applications quickly for operations that need a working database in weeks rather than months. Data capture forms, compliance tracking, inventory management, and business intelligence reporting.
Access Database Programming
VBA development, SQL query writing, migration to SQL Server and cloud platforms, Excel integration, and full application programming for new and existing Access databases.
What does PCG actually build with Microsoft Access?
PCG builds Access applications using the native Jet engine for single-site deployments, MSDE for small multi-user environments, and full SQL Server back-ends for organizations that need higher user counts, larger data volumes, or integration with other enterprise systems. Application prototype design is available before build commitment, allowing your team to review form layouts and workflow before any code is written.
| Application Type | Back-End | Best For | Typical Timeline |
|---|---|---|---|
| Single-site Access application | Jet / Access native | 1-5 users, under 50,000 records per table, one location | 2-6 weeks |
| Multi-user split architecture | Access back-end on server | 5-10 concurrent users, single location, shared network access | 3-8 weeks |
| Access front-end / SQL Server back-end | SQL Server on-premise | 10+ users, high data volume, advanced security requirements | 4-12 weeks |
| Access front-end / cloud SQL back-end | Azure SQL or AWS RDS | Multiple locations, remote access, no on-premise server required | 4-10 weeks |
| Full .NET web application migration | SQL Server | Browser access required, mobile users, public-facing data entry | 8-20 weeks |
PCG designs every Access application with the migration path documented from day one. If the business is likely to outgrow Access within two to three years, the initial build is structured to minimize rework when the transition happens.
What clients have said about PCG's Access work
The testimonials below come from clients across manufacturing, financial services, environmental compliance, and enterprise deployments. They are reproduced from documented client engagements, not from anonymized summaries.
"Over the past nine years, Phoenix has continued to provide outstanding support going above and beyond all contract requirements, as well as helping on a number of projects for consulting support. Phoenix has had more than enough expertise to resolve any user needs and technical difficulties concerning our products. When concerns have arisen, the firm delivered a response solution to our needs."Pete Clark, Phoenix Consultants Group Client (9-year engagement)
"PCG has done start to finish development, including client interactions, design, coding and testing. They were familiar with many third party tools that significantly sped up development, reducing my overall costs. PCG has a strong sense of urgency and commitment to their work, which is of the highest quality possible."Mark Barash Nabisco
"With changing priorities and the need to make adaptations at each step of the process, PCG understood how large corporations function and adjusted to our needs. Although we had only a rudimentary scope of work, PCG was able to visualize and make recommendations on how to implement our needs."Jeffrey Laue ExxonMobil
"Phoenix has designed a complex reporting database on our behalf requiring extensive programming to pull data from multiple sources into one central place. The level of service and knowledge provided by PCG has been outstanding throughout every step of this development process."Sharon McWilliams Financial Sector, Wall Street
"Our database went live on Jan 25, 2005. This system was an EPA funded project for pesticide inspections and case tracking. The system rarely if ever has issues. It has been reliable, and downtime is practically non-existent."Christopher Wade Pesticide Section Chief
"Allison was quick to respond to our comments and listened to our ideas and suggestions in designing the database. The timely support, customer service and patience we received from Allison was refreshing, and the professionalism and expertise provided exceeded our expectations."Miles Millspaugh Iron Door Manufacturing
"We contracted them for a rather complicated project involving significant planning, testing, and execution for a bespoke database and CRM system. It was a challenging project with many complex factors, but Phoenix Consultants made it a smooth and painless experience. And the system is working well years afterwards."Estlin Usher WFMT
"PCG is a highly regarded versatile team player who is continually cooperative and reliable. Allison is able to communicate with our onsite skilled computer professionals and the lesser skilled associates with ease. Her talent has benefited our entire organization."Bill Balicki and Carol Baus ExxonMobil
"PCG is very conscious of clients' budget constraints and endeavors to adhere to client requirements. Based on my experience with Phoenix Consultants Group, their programming skills and project design and completion schedule, I would recommend PCG without hesitation."Carole Sherman, Esq Practice Administrator
Why do clients work with PCG on Access projects instead of larger software firms?
Large software firms quote Access projects at rates that make small and mid-size deployments economically impractical. Offshore developers quote at lower rates but require extensive back-and-forth to understand business context that experienced Access consultants absorb in a single scoping conversation. Individual freelancers are available but unreliable for ongoing support. PCG occupies the position none of those options covers.
- Direct access to senior developers. Every call goes to a developer with hands-on Access experience, not to a project coordinator or support queue. Allison has been building database applications since the early 1980s. That depth of experience is available directly.
- Prototype review before build commitment. PCG's application prototype service allows clients to see form designs and workflow before code is written. Scope errors and design misalignments are caught at the prototype stage, where corrections cost a fraction of what they cost after the application is built.
- Distributed database capability for multi-location access. For organizations that need Access data accessible across multiple locations, PCG designs and implements distributed database architectures using cloud-hosted SQL back-ends. The Access interface stays familiar. The data becomes accessible from anywhere.
- Long-term relationships, not single-project vendors. The nine-year engagement referenced in the testimonials above is not exceptional for PCG. Many clients who came to PCG for a single Access project have retained PCG for ongoing support, modifications, and eventual migration as the business grew. That continuity matters when the developer who originally built the system is the same one who maintains and extends it years later.
- Full source code ownership at delivery. Every Access application PCG delivers includes complete source code ownership, schema documentation, and VBA code notes. No lock-in. No license fees. No dependency on PCG to access or modify what was built for you.
1 PCG Access project history documented from internal project records, 1995-2026. Version history covers Access 1.0 through Microsoft 365 current release.
2 Testimonials reproduced from documented client engagements. Affiliations reflect client's role at time of engagement.
Frequently Asked Questions
Yes. PCG has worked with Access from version 1.0 through the current Microsoft 365 release. Older versions present specific challenges: features that were deprecated in later releases, .mdb file formats that require conversion before they can be opened in current Access versions, and VBA code written for older object models that breaks under current runtime libraries. PCG handles all of these situations and provides an upgrade path assessment before recommending whether to upgrade the version, repair the existing application, or migrate to SQL Server.
Yes. Multi-location Access deployments require moving the data to a SQL Server or cloud-hosted back-end rather than sharing an Access file over a WAN connection. PCG designs and implements these distributed database architectures using Azure SQL, AWS RDS, or on-premise SQL Server depending on your infrastructure requirements. The Access front-end each location uses connects to the central database over a standard internet or VPN connection without file-locking or corruption risks.
PCG's application prototype service produces a working visual mockup of your Access application's forms and workflow before any production code is written. Your team reviews the prototype, provides feedback on form layout, field placement, navigation, and workflow logic, and approves the design before the build begins. Scope errors caught at the prototype stage cost a fraction of what they cost to fix after the application is built and populated with data. Prototype design is available as a standalone engagement or included in a full development project.
PCG manages requirement changes through a defined change scope process. When a new requirement emerges during development that falls outside the original scope, PCG documents the change, estimates the additional effort, and presents the options before any out-of-scope work begins. Minor changes that fall within the original scope are absorbed. Significant changes that affect the architecture or timeline are scoped and priced separately. You always know what a change will cost before it is implemented.
Yes. For Access applications that have been migrated to SQL Server or a cloud-hosted back-end, PCG provides hosting services for the database component. PCG-hosted databases include monitoring, backup, and maintenance as part of the hosting arrangement. For organizations that prefer to host their own database infrastructure, PCG configures the back-end for your environment and provides technical documentation for your IT team.
PCG has worked with Microsoft Access since its first release. Allison Woolbert has been building database applications since the early 1980s, predating both Access and PCG's founding in 1995. That means PCG has 30-plus years of Access-specific experience covering every version of the platform, every major architectural change Microsoft has made to Access over that time, and the full lifecycle of hundreds of Access applications from initial build through eventual migration.
PCG has documented project history across environmental compliance and remediation, municipal and commercial fleet management, healthcare staffing and physician credentialing, airport ground support operations, industrial safety and OSHA compliance, manufacturing job costing and production scheduling, financial services reporting, nonprofit organization data management, construction estimating, public safety dispatch and incident tracking, and government contractor regulatory reporting. More than 15 industries across 500-plus applications since 1995.
Yes. PCG takes over support for Access applications built by other developers regularly. The process starts with an assessment of the existing database: PCG maps the table structure, reviews the query logic, documents the VBA code, and identifies any structural or performance issues before assuming support responsibility. The assessment produces a clear picture of what the application does, what its current state is, and what ongoing support will involve. PCG then provides the same level of support for the inherited application as it would for one PCG built originally.