Professional Access 2013 Programming

Authoritative and comprehensive coverage for building Access 2013 Solutions

Access, the most popular database system in the world, just opened a new frontier in the Cloud. Access 2013 provides significant new features for building robust line-of-business solutions for web, client and integrated environments.  This book was written by a team of Microsoft Access MVPs, with consulting and editing by Access experts, MVPs and members of the Microsoft Access team. It gives you the information and examples to expand your areas of expertise and immediately start to develop and upgrade projects.

• Explores the new development environment for Access web apps
• Focuses on the tools and techniques for developing robust web applications
• Demonstrates how to monetize your apps with Office Store and create e-commerce solutions
• Explains how to use SQL Server effectively to support both web and client solutions
• Provides techniques to add professional polish and deploy desktop application
• Shows you how to automate other programs using Macros, VBA, API calls and more.

Professional Access 2013 Programming is a complete guide on the latest tools and techniques for building Access 2013 applications for both the web and the desktop so that developers and businesses can move forward with confidence. Whether you want to add expand your expertise with Client/Server deployments or start developing web apps, you will want this book as a companion and reference.

Table of Contents

Part I: Access Web Application Design and Development
Chapter 1: Introduction to Access Web Apps and Architecture
Chapter 2: Designing Tables
Chapter 3: Understanding the New User Interface
Chapter 4: Designing Views
Chapter 5: Creating Queries and Writing Expressions
Chapter 6: Creating Macros
Chapter 7: Designing the Table Structure
Chapter 8: Designing the User Interface
Chapter 9: Solving Business Problems with Macros
Chapter 10: Extending Web Apps
Chapter 11: Connecting to Your Web App
Chapter 12: Web Apps in the Enterprise
Chapter 13: Implementing Security Models for the Access Web App
Chapter 14: Deploying Access Web Apps

Part II: Client-Server Design and Development
Chapter 15: Managing Data Sources
Chapter 16: Programming Using VBA, APIs, and Macros
Chapter 17: Creating Intuitive Forms
Chapter 18: Creating Powerful Reports
Chapter 19: Automating and Integrating with Other Programs
Chapter 20: Securing, Deploying, and Maintaining Access Applications
Chapter 21: Maximizing SQL Server Capabilities