
Professional Access 2013 Programming
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Persons
Content
- 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
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.