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
Similar book on Amazon
Quantitative Methods in Project Management
Access 2007 VBA Programmer's Reference (Programmer to Programmer)
Access 2007 VBA Programming For Dummies
Microsoft Access VBA Programming for the Absolute Beginner
Access 2007 VBA Bible: For Data-Centric Microsoft Office Applications
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
CompTIA Project+ Study Guide: Exam PK0-003
Project Initiation
Comprehensive Project Plan
Project Control
Appendix A Systems Development Life Cycle
Appendix B Standard IT Project Documents
Agile Project Management: Creating Innovative Products (2nd Edition)
Practice: Product Vision Box and Elevator Test Statement
Practice: Daily Team Integration Meetings
Progress
Phase: Adapt
Self-Organization Extensions
Special Edition Using Crystal Reports 10
Troubleshooting
Understanding the Importance of Reuse in Reporting
Troubleshooting
Delivering Reports in Web Applications
Programming with the Report Engine Object Model
What is Lean Six Sigma
Key #3: Work Together for Maximum Gain
Key #4: Base Decisions on Data and Facts
When Companies Start Using Lean Six Sigma
Making Improvements That Last: An Illustrated Guide to DMAIC and the Lean Six Sigma Toolkit
Six Things Managers Must Do: How to Support Lean Six Sigma
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
Intelligent Networks
1G: Analog Transmission
Beyond 3G
Mobile TV
Mobile Content
Comparing, Designing, and Deploying VPNs
L2TPv3 Pseudowire Operation
Summary
Implementing Full Network Access Using the Cisco SSL VPN Client
Understanding IPLS
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