Book description
This book addresses an unmet need in this topic area. It is a complete beginner's tutorial resource to tips, troubleshooting, techniques, and program development for Access 2002. The book covers fundamentals such as database normalization, query design, object manipulation, and optimization and custom programming for forms and reports. It makes the reader more efficient, productive, and knowledgeable in Access VBA. Speed techniques are mentioned. Shortcuts, tips, and techniques increase productivity. This book deals with getting data from outside sources and using VBA to ensure data integrity and consistency, which no other Access VBA book does. It also tackles problems in a variety of day-to-day situations that programmers often face.
Bob Villareal is a contributor and a resident expert for the "Inside Microsoft Access" Web journal and an Access instructor at a Tulsa Community College. He also does freelance programming and instruction. Bob has been developing databases in a large insurance firm for more than 15 years. He has more than seven years' experience of VBA programming in both Access and Excel and has written many tracking and management applications.
Table of contents
- Copyright
- About the Author
- Acknowledgments
- Tell Us What You Think!
- Introduction
-
Tables and Queries
- Planning and Designing Your Access Database
- Joins and Cascades
- The Table—The Heart of Any Database
-
Unleashing the Power of Queries
- Queries Ask Questions
- Queries Access Records
- The Query Grid
- Understanding Query Types
- Introduction to SQL
- Understanding “Ands” and “Ors” in the Query Grid
- Understanding Wildcards
- Understanding Grouping and Sorting
- Understanding Dynasets and Their Underlying Tables
- Dynasets Versus Snapshots for Query Optimization
- What’s Next
-
Forms for Input and Reports for Output
-
Exploring Forms and Controls
- Forms Versus Reports
- Defining Events
- Using a Wizard to Help Design Your Form
- Examining Your Form’s Properties
- Changing the Form’s Color
- Introduction to Controls
- How to Control a Control
- Creating a Calculated Control
- Another Way to Create Calculated Controls
- Creating a Command Button
- Dealing with the Underlying Records
- Designing a Relational Form
- What’s Next
-
Exploring Reports
- Reports Versus Spreadsheets
- Report Basics
- Creating a Report from Scratch
- Taking Charge of Report Controls
- Setting Up Spreadsheet-like Calculations in Report Controls
- Taking Charge of Grouping and Sorting
- Understanding Sections
- The On Open Event
- Working with the Record Source Property
- Designing a Relational Report Using a Wizard
- Conditional Formatting
- Creating a Group of Controls
- What’s Next
-
Exploring Forms and Controls
-
Automate Your Access Database Using Code
- Exploring Objects
- Writing Your Own Visual Basic for Applications Code
- Macros, Modules, and Messages
-
Using Procedures to Customize Your Database
- Exploring Procedures
- Functions Versus Subs
- What Is Scope?
- Creating Procedures
- More Than One Way to Loop
- More than One Way to Handle Conditions
- Using Functions to Fulfill Your Wish List of Features Access Forgot
- Using Functions to Customize Your Applications
- Using the Immediate Window to Test Your Functions
- Using Functions for Pattern Matching in Queries
- What’s Next?
- Handling Access Error Codes
-
Access Visual Basic Tools, Tips, and Techniques
- Comparing DAO and ADO
- Using VBA to Run Queries
- Manipulating Recordsets Using Collections Versus Manipulating Recordsets Using Queries
- DAO Collections and Objects
- ADO Collections and Objects
- Cursors and Cursor Types
- How to Use DAO and ADO to Manipulate Data
- How to Use DAO and ADO to Enumerate Objects
- Creating a List of Objects
- Creating a List of Fields
- What’s Next
- Taking Advantage of the Latest Access Features
- Overcoming Access Development Obstacles
Product information
- Title: Access 2002 Programming by Example
- Author(s):
- Release date: January 2002
- Publisher(s): Que
- ISBN: 9780789725943
You might also like
book
Programming Microsoft® ADO.NET 2.0 Applications: Advanced Topics
Get in-depth coverage and expert insights on advanced ADO.NET programming topics such as optimization, DataView, and …
book
Access 2003 Programming by Example with VBA, XML, and ASP
This book is designed to take Microsoft Access users to the next step in programming. Its …
book
Absolute Beginner’s Guide to Microsoft® Access 2002
Microsoft Access 2002 is a powerful, relational database software package that makes it easy to create …
book
Access™ 2007 VBA Programmer's Reference
This resource provides the tools you need to leverage Access 2007's built-in functionality and VBA in …