Professional Access® 2013 Programming -- Copyright -- Credits -- About the Authors -- About the Technical Editors/ Contributors -- Technical Contributors -- Acknowledgments -- Contents -- Introduction -- Who This Book Is For -- What This Book Covers -- Part I: Access Web Application Design and Development -- Part II: Client Server Design and Development -- Online Material -- 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 -- Chapter 1: Introduction to Access Web Apps and Architecture -- Deprecated Components -- Access Data Projects -- Jet Replication -- Menus and Toolbars -- Import/Export/Link to Jet 3.x and dBASE Files -- PivotTables and PivotCharts -- Collect Data via E-mail -- SharePoint Workflow -- Source Code Control Extension -- Packaging Wizard -- Upsizing Wizard -- Creating Access Web Databases -- New Components Added -- Database Compare -- Audit and Control Management Server -- What Is an App? -- How Is an App Hosted? -- How Is an App Distributed? -- App Marketplace for Publicly Available Solutions -- App Catalogs for Internal-Facing Solutions -- How are Security and Trust Managed In Apps? -- Setting Up a SharePoint Site for Your Apps -- Setting Up an Office 365 Trial Account -- 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 -- Creating Tables Using Nouns -- Creating Tables from Imported Data Sources -- Creating Tables the Traditional Way -- Tables and Their Related Views -- Data Type Changes from Previous Versions -- Text Data Type -- Hyperlink Fields -- Numeric Data Type -- Date/Time Data Type -- Image Data Type -- Lookup Data Type -- Field Properties.

Linking Sharepoint Lists -- Summary -- Chapter 3: Understanding the New User Interface -- Web Navigation -- Navigation Tools -- The New Approach to Layout -- The New Ribbon -- Mobile Devices Support -- Sharepoint and Office 365 -- Creating a Web App via Team Site -- Deleting Web Apps -- Sharing Web Apps with Others -- Summary -- Chapter 4: Designing Views -- View Design Surface -- Ribbon -- Tiles -- Links and Creating Views -- Field List -- Popup Properties -- Manipulating Control Placement -- Duplicating a View -- Action Bar and Action Bar Buttons -- Action Bar Button Properties -- Default Action Button -- Custom Action Buttons -- Controls -- Changed Controls -- New Controls -- Common Properties -- Client Controls with No Counterparts -- Web Browser Control -- Summary -- Chapter 5: Creating Queries and Writing Expressions -- Query Architecture -- SQL Server Views -- Table-Valued Functions -- Changes in the Query Designer -- Creating, Editing, Saving, and Previewing Queries -- Action Queries -- Parameterized Queries -- Aggregates, Unique Values, and Top Values -- Query Properties -- Functions and Expressions -- Delimiters -- Operator Differences -- New Constants -- Data Type Inspection and Conversion -- String Functions -- Date and Time Functions -- Math Functions -- Other Functions -- Availability by Context -- Summary -- Chapter 6: Creating Macros -- Why We Need a New Web-Compatible Macro Language -- Where We've Been -- Access's Traditional Role as Tool of First Choice -- Macro Designer -- Action Catalog -- Expressions and Expression Builder -- Data Macro Tracing -- Parameter Box -- Macro Links -- Interacting with the Macro Designer -- Different Types of Macros -- UI Macros -- Data Macros -- Data Macro Architecture -- UI Macro Architecture -- Block Macro Action -- Creating and Editing Data Macros -- Creating a Standalone Data Macro.

Using the Action Catalog -- Using the Add New Action Drop-Down -- Using Program Flow Actions -- How to Use the LookupRecord Data Block -- How to Use ForEachRecord and EditRecord -- How to Use DeleteRecord -- Creating and Editing UI Macros -- How to Use SetProperty -- How to Use ChangeView and OpenPopup -- How to Use RequeryRecords -- How to Use Data Entry Operations -- Using UI and Data Macros Together -- How to Create and Use Parameters -- How to Return Values -- Summary -- Chapter 7: Designing the Table Structure -- New Data Types -- Short and Long Text Fields -- Number Fields -- Date/Time Fields -- Currency -- Yes/No -- Hyperlink -- Image -- Calculated Fields -- Lookup Fields -- Validation Rules and Text -- Field Level Validation -- Record Level Validation -- Editing Validation Rules with Existing Data -- Validation Rules Design Consideration -- Leveraging Calculated Fields -- Creating Concatenated Fields -- Configuration Tables -- Tally Table -- Utility Table -- 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 -- Traditional Navigation Patterns -- Web Design Principles -- Tile-Bound View and Popup Views -- Creating a Splash Screen -- Designing an Index Form -- List View: Searching on a field -- Summary View: Searching on an Aggregated Value -- Datasheet: Filtering Cumulatively -- Creating a Query by View -- SQL Construction -- Techniques for Filtering -- Design Requirements -- Creating Filter Tables -- Creating Data Macro to Clear Selections -- Creating Query By View -- Filtering Query -- Building Data Macros to Populate Filter Tables -- Building a Popup View to Display the Filter Results -- Building a Click Event Handler -- Summary -- Chapter 9: Solving Business Problems with Macros.

Macro Design Considerations -- When to Use Data Macros -- When to Use UI Macros -- On Start Macro -- Using Freestanding Macros -- Cloning a Record -- Generating a Set of Records with Variable Parameters -- Generating Records in Different Tables -- Updating and/or Deleting Several Records -- Using Table Events -- Performance Considerations -- Preventing Deletions of Completed Records -- Acquiring Default Values from Other Tables -- Maintaining a History of Change -- Summary -- Chapter 10: Extending Web Apps -- Integration Options -- Security Considerations -- Introduction to Web Services -- Linking a Web App for Additional Functionality -- Locating and Adding the Locations Mapper App -- Configuring and Using the Locations Mapper App -- Inlining a Web App in Access Web App -- Adding a PayPal Button -- Getting the PayPal HTML -- Authoring a Custom Page In SharePoint Designer -- Allowing Framing of Custom Page -- Adding the PayPal HTML -- Showing a PayPal Button on an Access Web App -- Adding a Site Mailbox -- Configuration for a Site Mailbox -- Setting Up the Site Mailbox -- Team Site Mailbox as a Shared Tool -- Using APIs with a Web Browser Control -- Building a Page to Handle JavaScript Code -- Development Experience -- Adding the Charting Page to Access Web App -- Consuming Zip-Lookup Web Services in the Client -- Creating a User Account for the Web Service -- Library References and Code -- Summary -- Chapter 11: Connecting to Your Web App -- Info Backstage -- Connections -- Enable/Disable Connection -- Getting Connection Details -- Reset Passwords -- Using the Access Client -- Adding VBA Code to Relink -- Best Practices -- Using Excel -- Creating an ODC Connectio -- Creating an Excel Table -- Creating an Excel PivotChart -- Creating an Excel PivotTable -- External Data Considerations -- Sharing Excel Workbooks on the Web -- Using SSMS.

Connecting to a Web App Database -- Adding a Linked Server on the Web App Database -- Querying Data in a Linked Server -- Using Linked Server Programmability Objects -- Summary -- Chapter 12: Web Apps in the Enterprise -- Creating a Document Library -- Creating a Custom Content Type -- Importing Image Files -- Customizing a Library -- Customizing a Library Ribbon -- Version Control -- Customizing an App Package -- Linking to a Template File -- Synchronizing Data Between App Databases -- Local Differential Backup -- Choosing Approaches -- Summary -- Chapter 13: Implementing Security Models for the Access Web App -- Security Considerations -- File-Based Security -- Agent-Based Security -- Securing Web Apps on SharePoint -- Security In the Application Layer -- Sharepoint Security -- Team Sites and Personal Storage -- Managing User Accounts -- Extending Permissions -- External User Accounts -- Anonymous Access -- Securing Web Apps in the Web Browser -- Using Subsites to Restrict Users to Specific Apps -- Sites and Subsites -- Traditional Methods for Security in Client Solutions -- Web App Linked File Security -- DSN-Less Linking and Relinking -- Password Storage/Non-Storage -- Local SQL Server -- Summary -- Chapter 14: Deploying Access Web Apps -- Deploying Access Web Apps -- Web Apps and App Catalogs -- On-Premises SharePoint Server -- Versioning Web Apps -- Summary -- Part II: Client-Server Design and Development -- Chapter 15: Managing Data Sources -- Normalization -- First Normal Form: Eliminate Repeating Groups -- Second Normal Form: Eliminate Duplicate Data -- Third Normal Form: Eliminate Fields That Do Not Depend on the Key -- Other Normalization Forms -- Normalization Examples -- Un-Normalized Table -- First Normal Form: Eliminate Repeating Groups -- Second Normal Form: Eliminate Duplicate Data.

Third Normal Form: Eliminate Fields That Do Not Depend on the Key.