Alison Balter's Mastering Microsoft Office Access 2003

Front Cover
Sams Publishing, 2004 - Computers - 1416 pages
0 Reviews

What Alison¿s book offers over other books in that she is able to take a highly technical topic and present it in a manner that is easy to comprehend. It is a book that the reader will often want to read from cover to cover, but it can also act as an excellent reference. Readers of this book will learn:

  • Access 11 application development and real-world solutions to specific development and programming problems.
  • Professional programming techniques backed by concise, no-nonsense explanations of the underlying theories.
  • Debugging and troubleshooting methods to solve problems quickly and get stalled development projects back on track.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Introduction
1
The Basics of Access Development
5
Access As a Development Tool
7
Summary
38
What Every Developer Needs to Know About Databases and Tables
39
Adding Smart Tags to Your Tables
73
Your Key to Data Integrity
91
What Every Developer Needs to Know About Query Basics
115
Exploiting the Power of Class Modules
591
What Are ActiveX Data Objects and Data Access Objects and Why Are They Important?
627
Understanding ADO Recordset Types
635
Working with ADO Recordset Properties and Methods
644
Modifying Table Data Using ADO Code
661
Creating and Modifying Database Objects Using ADO Code
668
Understanding DAO Recordset Types
684
Modifying Table Data Using DAO Code
701

Adding Smart Tags to Your Queries
149
Summary
164
What Every Developer Needs to Know About Forms
165
Selecting the Correct Control for the Job
181
Control Morphing
191
What Control Properties Are Available and Why Should
200
Bound Unbound and Calculated Controls
206
The Why and How
214
What Every Developer Needs to Know About Reports
237
An Introduction
283
Working with Variables
297
Using the Line Continuation Character
303
Passing Parameters and Returning Values
313
Working with Constants
320
Objects Properties Methods and Events Explained
341
Advanced Form Techniques
373
What Are the Section and Control Events and When Do
385
Referring to Me
393
Conserving Screen Real Estate
398
Adding Custom Menus Toolbars and Shortcut Menus to Your
406
Linking Versus
412
Power Combo Box and List Box Techniques
418
Power Subform Techniques
426
Windows XP Theme Support
433
Advanced Report Techniques
443
Advanced Query Techniques
491
Optimizing Queries
504
Self Joins
516
Union Queries
528
Using the Result of a Function as the Criteria for a Query
538
Summary
549
Advanced VBA Techniques
551
Using the DAO Containers Collection
710
Summary
716
What to Do When Things Dont Go as Planned
717
What to Do When Things Dont Co as Planned 15 Debugging Your Key to Successful Development
719
Preparing for the Inevitable
747
Optimizing Your Application
795
Letting the Performance Analyzer Determine Problem Areas
802
Summary
830
Developing Multiuser and Enterprise Applications
831
A Strategy to Developing Access Applications
833
Using External Data
849
Developing Multiuser and Enterprise Applications
891
The Roles Access Plays in the Application Design Model
903
An Introduction to Transaction Processing
912
Introduction to Replication
918
BlackBelt Programming
923
Access Application
930
Communicating with Other Applications
953
Exploiting the Power of the Windows API
989
Creating Your Own Libraries
1015
Using Builders Wizards and Menu Addlns
1033
An Introduction to Access and the InternetIntranet
1061
Adding Polish to Your Application
1097
Admins Group
1111
Advanced Security Techniques
1135
Documenting Your Application
1173
Maintaining Your Application
1191
Your Job Done Effectively
1203
Appendixes
1247
B Naming Conventions
1307
Index
1313
Copyright

Other editions - View all

Common terms and phrases

About the author (2004)

Alison Balter is the president of InfoTechnology Partners, Inc., a computer consulting firm based in the rural Santa Rosa Valley Area, close to Camarillo, California. Alison is a highly experienced independent trainer and consultant specializing in Windows applications training and development. During her 19 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTechnology Partners, Inc. (formerly Marina Consulting Group) in 1990, its client base has expanded to include major corporations and government agencies such as Shell Oil, Accenture, Northrop, the U.S. Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the U.S. Navy, and others.

InfoTechnology Partners, Inc., is a Microsoft Certified Partner, and Alison is a Microsoft Certified Professional. Alison was one of the first professionals in the computer industry to become a Microsoft Certified Solutions Developer.

Alison is a partner in the multimedia training company Blast Through Learning, Inc., and is the author of more than 300 internationally marketed computer training videos and CD-ROMs, including 18 Access 2000 videos, 35 Access 2002 videos, and 15 Access 2003 videos. These videos and CD-ROMs are available by contacting Alison's company, InfoTechnology Partners, Inc. Alison travels throughout North America, giving training seminars on Microsoft Access, Visual Studio .NET, Microsoft SQL Server, Visual Basic, and Visual Basic for Applications. She is also featured in several live satellite television broadcasts for National Technological University.

Alison is a regular contributing columnist for Access/Office/VB Advisor as well as other computer publications. She is also a regular on the Access, Visual Studio .NET, SQL Server, and Visual Basic national speaker circuits. She was one of four speakers on the Visual Basic 4.0 and 5.0 World Tours seminar series co-sponsored by Application Developers Training Company and Microsoft.

Alison is also the author of six other books published by Sams Publishing: Alison Balter's Mastering Access 95 Development, Alison Balter's Mastering Access 97 Development, Alison Balter's Mastering Access 2000 Development, Alison Balter's Mastering Access 2002 Desktop Development, Alison Balter's Mastering Access 2002 Enterprise Development, and Learning Office Access 2003 in 24 Hours. Alison is a coauthor of three Access books published by Sams Publishing: Essential Access 95, Access 95 Unleashed, and Access 97 Unleashed.

An active participant in many user groups and other organizations, Alison is a past president of the Independent Computer Consultants Association of Los Angeles and of the Los Angeles Clipper Users' Group.

On a personal note, Alison keeps herself busy horseback riding, skiing, ice skating, running, lifting weights, hiking, traveling, and dancing. She most enjoys spending time with her husband, Dan, their daughter, Alexis, their son, Brendan, and their golden retriever, Brandy.

Alison's firm, InfoTechnology Partners, Inc., is available for consulting work and on-site training in Microsoft Access, Visual Studio .NET, Visual Basic, and SQL Server, as well as for Windows Server 2003, Windows 2000, Windows NT, Windows 98, Windows XP, PC networking, and Microsoft Exchange Server. You can contact Alison by email at Alison@InfoTechnologyPartners.com, or visit the InfoTechnology Partners Web site at http://www.InfoTechnologyPartners.com.

Bibliographic information