Flylib.com
Beginning Access 2007 VBA
Beginning Access 2007 VBA
ISBN: 0470046848
EAN: 2147483647
Year: 2004
Pages: 143
Authors:
Denise M. Gosnell
BUY ON AMAZON
Table of Contents
Back Cover
Beginning Access 2007 VBA
Introduction
What This Book Covers
How This Book Is Structured
What You Need to Use This Book
Conventions
Source Code
Errata
p2p.wrox.com
Chapter 1: Introduction to Access 2007 VBA
What Is Access 2007 VBA?
Whats New in Access 2007 VBA?
Access 2007 VBA Programming 101
Summary
Exercises
Chapter 2: The Basics of Writing and Testing VBA Code
Creating Modules
Standard Modules versus Class Modules
Creating and Calling Procedures
Using Variables and Constants to Store Values
Controlling Program Flow
Documenting Your Code
Error Debugging
Error Handling
Summary
Exercises
Chapter 3: Programming Applications Using Objects
Viewing Objects Using the Object Browser
Ways to Refer to Objects
Using Access Collections and Objects
Summary
Exercises
Chapter 4: Creating Your Own Objects
Create Custom Properties for Existing Objects
Create Custom Methods for Existing Objects
Summary
Exercises
Chapter 5: Interacting with Data Using ADO and SQL
Using ADODB to Work with Data
Introduction to SQL
Using ADOX to Manipulate Data Objects
Summary
Exercises
Chapter 6: Building Interactive Forms
Form Navigation and Flow
Working with Controls
Building User Interaction
Adding Polish to Your Forms
Summary
Exercises
Chapter 7: Importing, Linking, and Exporting Using External Data Sources
Linking, Importing, and Exporting Overview
Access and Other Databases
Transferring Complete SQL Server Database
Spreadsheets
Text Files
XML Files
E-mails and Outlook
Other Ways to Export Data
Summary
Exercises
Chapter 8: Using Access with Web Services and SharePoint Lists
Introduction to Web Services
Using Data from Web Services
Introduction to SharePoint Lists
Using Data from SharePoint Lists
Summary
Exercises
Chapter 9: Creating Reports and Web-Enabled Output
Exporting Access Data to Web Formats
Summary
Exercises
Chapter 10: Building SQL Server Applications with Access Projects
Setting Up SQL Server
Creating Access Projects (ADPs)
Working with SQL Server Objects from Access
Migrating an Existing Access Database to an Access Project
Summary
Exercises
Chapter 11: Advanced Access Programming
Using Dynamic Link Libraries (DLLs)
Automation
ActiveX Controls
Libraries
Add-Ins
Transactions
Summary
Exercises
Chapter 12: Finishing the Application
Multiuser Considerations
Optimizing Your Applications
Securing Your Application
Distributing Your Application
Maintaining the Application
Summary
Exercises
Chapter 13: Case Study 1-Project Tracker Application
Design Specifications
Building the Database
Building the User Interface
Building the Class Modules for the Objects
Building the Standard Modules
Connecting the User Interface to the Code
Touring the Finished Project Tracker Application
Summary
Chapter 14: Case Study 2-Customer Service Application
Design Specifications
Building the Database and Database Objects
Building the User Interface
Building the Class Module for the Objects
Building the Standard Modules
Connecting the User Interface to the Code
Touring the Finished Customer Service Application
Summary
Index
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
List of Try It Outs
Beginning Access 2007 VBA
ISBN: 0470046848
EAN: 2147483647
Year: 2004
Pages: 143
Authors:
Denise M. Gosnell
BUY ON AMAZON
Project Management JumpStart
Building the Foundation
Initiating the Project
Defining the Project Goals
Planning and Acquiring Resources
Appendix C Sample Project Management Checklists
A+ Fast Pass
Domain 2 Diagnosing and Troubleshooting
Domain 3 Preventive Maintenance
Domain 6 Basic Networking
Domain 1 Operating System Fundamentals
Domain 3 Diagnosing and Troubleshooting
Visual C# 2005 How to Program (2nd Edition)
Value Types vs. Reference Types
(Optional) Extensible Stylesheet Language and XSL Transformations
Summary
G.4. Basic XHTML Forms
J.2. Class ATM
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 3. Connect Mac OS X with a Bluetooth Phone
Hack 61. Unwire Your Pistol Mouse
Hack 70. Pebble
Hack 85. Pringles Can Waveguide
Hack 95. Build a Wireless Network for the Large House
Junos Cookbook (Cookbooks (OReilly))
Tracing OSPF Protocol Traffic
Authenticating BGP Peers
Automatically Allocating Bandwidth
Adding a VPN for a Second Customer
Configuring PIM-SM
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Key Points
Modifying Shape Connections
Importing Data to Create Organization Charts
Key Points
Creating Network Diagrams
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies