You are previewing Professional Access 2013 Programming.
O'Reilly logo
Professional Access 2013 Programming

Book Description

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

    1. Cover Page
    2. Title Page
    3. Copyright
    4. Dedication
    5. CREDITS
    6. ABOUT THE AUTHORS
    7. ABOUT THE TECHNICAL EDITORS/CONTRIBUTORS
    8. TECHNICAL CONTRIBUTORS
    9. ACKNOWLEDGMENTS
    10. CONTENTS
    11. INTRODUCTION
      1. WHO THIS BOOK IS FOR
      2. WHAT THIS BOOK COVERS
      3. HOW THIS BOOK IS STRUCTURED
      4. WHAT YOU NEED TO USE THIS BOOK
      5. CONVENTIONS
      6. SOURCE CODE
      7. ERRATA
      8. P2P.WROX.COM
    12. PART I: Access Web Application Design and Development
      1. 1: Introduction to Access Web Apps and Architecture
        1. DEPRECATED COMPONENTS
        2. NEW COMPONENTS ADDED
        3. WHAT IS AN APP?
        4. HOW IS AN APP HOSTED?
        5. HOW IS AN APP DISTRIBUTED?
        6. HOW ARE SECURITY AND TRUST MANAGED IN APPS?
        7. SOLVING BUSINESS PROBLEMS
        8. THE MAID TO ORDER WORK SCHEDULE DATABASE
        9. SUMMARY
      2. 2: Designing Tables
        1. CREATING A BLANK APP
        2. KEEPING YOUR LOG INS STRAIGHT
        3. CREATING TABLES
        4. DATA TYPE CHANGES FROM PREVIOUS VERSIONS
        5. FIELD PROPERTIES
        6. LINKING SHAREPOINT LISTS
        7. SUMMARY
      3. 3: Understanding the New User Interface
        1. WEB NAVIGATION
        2. MOBILE DEVICES SUPPORT
        3. SHAREPOINT AND OFFICE 365
        4. SUMMARY
      4. 4: Designing Views
        1. VIEW DESIGN SURFACE
        2. ACTION BAR AND ACTION BAR BUTTONS
        3. CONTROLS
        4. SUMMARY
      5. 5: Creating Queries and Writing Expressions
        1. QUERY ARCHITECTURE
        2. CHANGES IN THE QUERY DESIGNER
        3. FUNCTIONS AND EXPRESSIONS
        4. SUMMARY
      6. 6: Creating Macros
        1. WHY WE NEED A NEW WEB-COMPATIBLE MACRO LANGUAGE
        2. MACRO DESIGNER
        3. DIFFERENT TYPES OF MACROS
        4. CREATING AND EDITING DATA MACROS
        5. CREATING AND EDITING UI MACROS
        6. USING UI AND DATA MACROS TOGETHER
        7. SUMMARY
      7. 7: Designing the Table Structure
        1. NEW DATA TYPES
        2. VALIDATION RULES AND TEXT
        3. LEVERAGING CALCULATED FIELDS
        4. SUMMARY
      8. 8: Designing the User Interface
        1. NAMING CONVENTION FOR WEB APPS
        2. PLANNING THE USER INTERFACE
        3. REUSING CREATE, READ, UPDATE, AND DELETE VIEWS
        4. EFFECTIVE NAVIGATION DESIGN
        5. CREATING A SPLASH SCREEN
        6. DESIGNING AN INDEX FORM
        7. CREATING A QUERY BY VIEW
        8. SUMMARY
      9. 9: Solving Business Problems with Macros
        1. MACRO DESIGN CONSIDERATIONS
        2. USING FREESTANDING MACROS
        3. USING TABLE EVENTS
        4. SUMMARY
      10. 10: Extending Web Apps
        1. INTEGRATION OPTIONS
        2. LINKING A WEB APP FOR ADDITIONAL FUNCTIONALITY
        3. INLINING A WEB APP IN ACCESS WEB APP
        4. ADDING A PAYPAL BUTTON
        5. ADDING A SITE MAILBOX
        6. USING APIS WITH A WEB BROWSER CONTROL
        7. CONSUMING ZIP-LOOKUP WEB SERVICES IN THE CLIENT
        8. SUMMARY
      11. 11: Connecting to Your Web App
        1. INFO BACKSTAGE
        2. CONNECTIONS
        3. USING THE ACCESS CLIENT
        4. USING EXCEL
        5. USING SSMS
        6. SUMMARY
      12. 12: Web Apps in the Enterprise
        1. CREATING A DOCUMENT LIBRARY
        2. CUSTOMIZING AN APP PACKAGE
        3. LINKING TO A TEMPLATE FILE
        4. SYNCHRONIZING DATA BETWEEN APP DATABASES
        5. SUMMARY
      13. 13: Implementing Security Models for the Access Web App
        1. SECURITY CONSIDERATIONS
        2. SHAREPOINT SECURITY
        3. SECURING WEB APPS IN THE WEB BROWSER
        4. TRADITIONAL METHODS FOR SECURITY IN CLIENT SOLUTIONS
        5. WEB APP LINKED FILE SECURITY
        6. SUMMARY
      14. 14: Deploying Access Web Apps
        1. DEPLOYING ACCESS WEB APPS
        2. SUMMARY
    13. PART II: Client-Server Design and Development
      1. 15: Managing Data Sources
        1. NORMALIZATION
        2. NORMALIZATION EXAMPLES
        3. PRIMARY KEYS
        4. OVERVIEW OF ACCESS FILES AND THE DATABASE ENGINE
        5. OTHER DATA SOURCES
        6. QUERYING EXTERNAL DATA EFFECTIVELY
        7. SUMMARY
      2. 16: Programming Using VBA, APIs, and Macros
        1. VBA
        2. LEVERAGING QUERIES
        3. API
        4. INTRODUCTION TO DATA MACROS
        5. CREATING DATA MACROS
        6. SUMMARY
      3. 17: Creating Intuitive Forms
        1. CREATING INTUITIVE FORMS
        2. LEVERAGING BUILT-IN FUNCTIONALITY
        3. THE DEMO FORMS
        4. MULTI-VALUE FIELDS
        5. REPORT RUNNER
        6. SUMMARY
      4. 18: Creating Powerful Reports
        1. INTRODUCTION TO REPORTS
        2. CREATING REPORTS
        3. REPORT EXAMPLES
        4. PROFESSIONAL POLISH
        5. FILLING OUT PDF FORMS USING ACCESS
        6. SUMMARY
      5. 19: Automating and Integrating with Other Programs
        1. OVERVIEW OF INTEROPERABILITY
        2. GETTING STARTED WITH AUTOMATION
        3. AUTOMATING OFFICE PROGRAMS
        4. MICROSOFT EXCEL INTEGRATION
        5. WORD INTEGRATION
        6. POWERPOINT INTEGRATION
        7. OUTLOOK INTEGRATION
        8. INTEGRATING ACCESS WITH OTHER APPLICATIONS
        9. SUMMARY
      6. 20: Securing, Deploying, and Maintaining Access Applications
        1. USER LEVEL SECURITY AND AUDIT TRAIL
        2. DEPLOYMENT CONSIDERATIONS
        3. MAINTAINING DIFFERENT ENVIRONMENTS
        4. DEVELOPMENT, TEST, AND PRODUCTION ENVIRONMENTS
        5. DATA MAINTENANCE
        6. OWNERSHIP OF CODE
        7. SUMMARY
      7. 21: Maximizing SQL Server Capabilities
        1. UPSIZING
        2. WORKING WITH SQL SERVER AS THE BACK END
        3. SUMMARY
    14. INDEX