Devlin Nexley: Microsoft 365 Access Application Architecture, Kartoniert / Broschiert

Klappentext

Microsoft Access continues to power a significant class of departmental, operational, and business-critical applications. The challenge is not simply building an Access database, but engineering an Access solution that can remain reliable, secure, maintainable, and operationally viable as users, data, integrations, and business requirements grow.

This book presents Microsoft Access from an enterprise software engineering perspective. Rather than focusing on introductory database exercises or step-by-step interface instructions, it examines the architectural decisions, engineering practices, integration patterns, performance considerations, and lifecycle controls required to operate serious Access-based applications.

The book explores relational data modeling, application architecture, query engineering, VBA-based business logic, multi-user concurrency, reporting systems, security, deployment, observability, backup and recovery, performance benchmarking, and capacity planning. It also examines how Access applications interact with enterprise data platforms and services, including SQL Server, Azure SQL, Microsoft 365, and the Microsoft Power Platform.

Particular attention is given to modernization. Many organizations operate Access applications that have accumulated years of business logic, data dependencies, integrations, and technical debt. Completely replacing such systems is rarely a simple technical exercise. The book examines practical architectural pathways for stabilizing existing applications, separating application and data layers, moving workloads toward SQL Server or Azure, integrating Power Apps and Power Automate, and determining when incremental modernization is preferable to full replacement.

Topics covered include:

Microsoft Access application and database architecture Relational data modeling and integrity engineering Front-end and back-end separation Advanced query and performance engineering Maintainable VBA application architecture Multi-user concurrency and transaction design Enterprise reporting architectures Security, governance, and auditability SQL Server and Azure SQL integration ODBC and external data connectivity Microsoft 365 and enterprise service integration Access and Power Platform architectures Deployment and release management Operational monitoring and centralized logging Backup, recovery, and business continuity Performance benchmarking and capacity planning Legacy Access assessment and modernization Migration strategies and hybrid architectures Long-term lifecycle and support engineering Architectural criteria for retiring Access applications

Designed for experienced developers, database professionals, solution architects, consultants, IT engineers, and technical leaders, this book treats Access as part of a broader Microsoft technology ecosystem rather than as an isolated desktop database product.

Whether an organization is maintaining a mature Access estate, integrating Access with enterprise SQL infrastructure, extending existing applications into the cloud, or evaluating a migration toward modern Microsoft platforms, the architectural principles in this book provide a framework for making those systems more reliable, governable, and sustainable.