Professional Access 2013 Programming

Name: Professional Access 2013 Programming
Brand: Wrox
Price: 35.99 EUR
Availability: OnlineOnly

Teresa Hennig Ben Clothier George Hepworth Dagi (Doug) Yudovich(Autor*in)

Wrox (Verlag)

Erschienen am 1. August 2013

1008 Seiten

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-1-118-53082-5 (ISBN)

35,99 €inkl. 7% MwSt.

Systemvoraussetzungen

für PDF mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Personen

Inhalt

Intro
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
Primary Keys
Overview of Access Files and the Database Engine
Other Data Sources
Overview of ODBC Linking
Managing Linked Objects
Querying External Data Effectively
Linked Object Performance and Query Optimization
Passthrough Query and T-SQL
Comparing Access SQL and T-SQL
Summary
Chapter 16: Programming Using VBA, APIs, and Macros
VBA
Procedures
User-Defined Functions
Error Handling
Debugging
Leveraging Queries
Enhancing Query Techniques
Query by Form
Creating a Query On the Fly Using VBA
API
Obtaining Documentation for API Functions
Mapping Data Types
VBA User-Defined Types and C-Style Structs
Pointers and Handles
32-Bit vs. 64-Bit
Putting It All Together: Create and Manage an Explorer Window
API Declaration
Declaring the Enumeration Function
Declaring the Callback Function
Determining the Class Name of a Window
Preparing the EnumChildProc for Two Different Uses
Creating the Main Procedure
Retrieving Window Information
Tips and Techniques
Introduction to Data Macros
Why Use Data Macros?
Differences in Client and Web Data Macros
Use Cases for Data Macros
Creating Data Macros
Maintaining Calculated Values to Support Indexing
Maintaining Quantity On Hand to Support Business Logic
Data Macros and VBA
Summary
Chapter 17: Creating Intuitive Forms
Creating Intuitive Forms
Clean Layout
Guiding the User Through the Process
Showing and Verifying Data in a Timely Manner
User-Friendly Messages and Tips
Leveraging Built-in Functionality
Textbox
Label
Command Buttons
Split Forms
Pop-up, Modal, or Dialog Forms
The Demo Forms
Tag Property
Displaying Images
List and Combo Boxes
Datasheet View Search Forms
Multiple Instances of a Form
Multi-Value Fields
Appending MVFs
Appending Attachments
Report Runner
Creating the Foundation
Setting Up the Report and Its Criteria Fields
Selecting the Criteria and Running the Report
Summary
Chapter 18: Creating Powerful Reports
Introduction to Reports
Creating Reports
Fundamentals
Creating and Customizing Reports
SubReports
Drill Down Reports
Report Examples
Grouping Data
Reports with Simple Criteria
Reports with Simple Groupings
One Flexible Report
Calling the Criteria Form from the Report
Reports that Compare Values
Professional Polish
Report Criteria
Confidentiality Statement
Page Numbers and Report Date
Report Name
Using Work Tables
Filling Out PDF Forms Using Access
Using Reports
Using an XFDF file
Summary
Chapter 19: Automating and Integrating with Other Programs
Overview of Interoperability
Getting Started with Automation
Declare and Instantiate Variables
Early Binding Versus Late Binding
Automating Office Programs
Microsoft Excel Integration
Integration with Excel Using Ribbons, Menus, and Macros
Referencing the Excel Object Library
Working with the Excel Object Model
Using Automation to Send Data to Excel
Creating an Excel PivotTable from Access
Generating an Excel Chart from Access
Word Integration
Integration with Word Using Ribbons, Menus, and Macros
Referencing the Word Object Library
Working with the Word Object Model
Sending Access Data to Word with Automation
Using Access Automation to Create Word Tables
Powerpoint Integration
Setting a Reference to the PowerPoint Object Library
Working with the PowerPoint Object Model
Creating a Presentation from an Access Table
Outlook Integration
Sending Outlook Mail Using a Macro Action
Referencing the Outlook Object Model
Sending Mail Using VBA and Automation
Reading and Moving Mail Using VBA and Automation
Creating Other Outlook Items Using VBA and Automation
Integrating Access with Other Applications
Summary
Chapter 20: Securing, Deploying, and Maintaining Access Applications
User Level Security and Audit Trail
Local User Table
Network Identity
Network Identity with a User Table In Access Database
Different Front-end Files for Different User Roles
Security Summary
Converting from .mdb with User Level Security to .accdb
Audit Trail
Using VBA
Using Data Macros
Remote Query
Deployment Considerations
Deploying Front-end Files
Auto-Updating the Front End
Deploying Back-end Changes
Maintaining Different Environments
Development, Test, and Production Environments
Promoting Files from Test to Production
Version Control
Data Maintenance
Automating Backups
Automating Maintenance
How to Kick Users Out of the Application
Ownership of Code
Intellectual Property Rights
Trial Version
Summary
Chapter 21: Maximizing SQL Server Capabilities
Upsizing
When to Upsize
The Upsizing Process
Things to Watch for When Upsizing
Working with SQL Server as the Back End
SQL Server Management Studio
SQL Server Objects
Troubleshooting
Summary
Index
Advertisement

Inhalt (PDF)

Systemvoraussetzungen

Als PDF speichern Als Link merken