Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Contents
Part I: Access Web Application Design and Development
Chapter 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
Chapter 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
Chapter 3: Understanding The New User Interface
Web Navigation
Mobile Devices Support
SharePoint and Office 365
Summary
Chapter 4: Designing Views
View Design Surface
Action Bar and Action Bar Buttons
Controls
Summary
Chapter 5: Creating Queries and Writing Expressions
Query Architecture
Changes in the Query Designer
Functions and Expressions
Summary
Chapter 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
Chapter 7: Designing the Table Structure
New Data Types
Validation Rules and Text
Leveraging Calculated Fields
Summary
Chapter 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
Chapter 9: Solving Business Problems with Macros
Macro Design Considerations
Using Freestanding Macros
Using Table Events
Summary
Chapter 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
Chapter 11: Connecting to Your Web App
Info Backstage
Connections
Using the Access Client
Using Excel
Using SSMS
Summary
Chapter 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
Chapter 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
Chapter 14: Deploying Access Web Apps
Deploying Access Web Apps
Summary
Part II: Client-Server Design and Development
Chapter 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
Chapter 16: Programming Using VBA, APIs, and Macros
VBA
Leveraging Queries
API
Introduction to Data Macros
Creating Data Macros
Summary
Chapter 17: Creating Intuitive Forms
Creating Intuitive Forms
Leveraging Built-in Functionality
The Demo Forms
Multi-Value Fields
Report Runner
Summary
Chapter 18: Creating Powerful Reports
Introduction to Reports
Creating Reports
Report Examples
Professional Polish
Filling Out PDF Forms Using Access
Summary
Chapter 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
Chapter 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
Chapter 21: Maximizing SQL Server Capabilities
Upsizing
Working with SQL Server as the Back End
Summary
Introduction
Advertisement
← Prev
Back
Next →
← Prev
Back
Next →