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