Prentice Hall
Information Technology
ISBN-10: 0672329328
ISBN-13: 9780672329326
Publisher: Sams Publishing
Copyright: 2007
Format: Paper; 1248 pp
Published: 05/31/2007
Suggested retail price: $59.99
Buy from myPearsonStore
Microsoft Office 2007 is a major upgrade from the last version of Office; Access will also be greatly revised. Alison Balter is the name that Access developers will trust to guide them through Access 2007's new features. She has the rare ability to take complex topics and explain them clearly, as shown by the success of her ten previous books on Access. Balter is known for providing real-world solutions to specific Access development problems. She also is known for her ability to back up her practical examples with just enough underlying theory to give the reader a good overall understanding of Access. In short, this book will provide beginning and intermediate Access developers with everything that they need to know to design and build Access 2007 applications. It should also appeal to DBAs and power users who want or need to get started building custom Access apps. This latest book in her Mastering Access series will not disappoint her many fans who anxiously await each new version, and should win her new fans as well.
Introduction
Part I The Basics of Access Development
1 Access as a Development Tool. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
2 What Every Developer Needs to Know About Databases and Tables . . . . . . . 75
3 Relationships: Your Key to Data Integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115
4 What Every Developer Needs to Know About Query Basics. . . . . . . . . . . . . . . . . 137
5 What Every Developer Needs to Know About Forms. . . . . . . . . . . . . . . . . . . . . . . . . . 189
6 What Every Developer Needs to Know About Reports. . . . . . . . . . . . . . . . . . . . . . . . 269
7 What Are Macros, and When Do You Need Them? . . . . . . . . . . . . . . . . . . . . . . . . . . . 315
8 VBA: An Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 345
9 Objects, Properties, Methods, and Events Explained . . . . . . . . . . . . . . . . . . . . . . . . . . 401
10 Advanced Form Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431
11 Advanced Report Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 493
12 Advanced Query Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 539
13 Advanced VBA Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 599
14 Exploiting the Power of Class Modules. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 637
15 What Are ActiveX Data Objects, and Why Are They Important?. . . . . . . . . . 671
Part II What to Do When Things Don’t Go as Planned
16 Debugging: Your Key to Successful Development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 727
17 Error Handling: Preparing for the Inevitable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 755
18 Optimizing Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 801
Part III Developing Multiuser and Enterprise Applications
19 A Strategy to Developing Access Applications. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 835
20 Using External Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 847
21 Access 2007 and SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 883
22 Developing Multiuser and Enterprise Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . 909
00_0672329328_FM.qxd 5/4/07 9:23 AM Page iii
Part IV Black Belt Programming
23 Working with and Customizing Ribbons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 935
24 Automation: Communicating with Other Applications. . . . . . . . . . . . . . . . . . . . . . 949
25 Exploiting the Power of the Windows API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 985
26 Creating Your Own Libraries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1011
27 Using Builders and Wizards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1027
28 An Introduction to Access and the Internet/Intranet. . . . . . . . . . . . . . . . . . . . . . . . 1055
Part V Adding Polish to Your Application
29 Documenting Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1073
30 Maintaining Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1091
31 Database Security Made Easy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1103
The following appendixes are available for download
at www.samspublishing.com/title/0672329328.
Part VI Appendixes
A Naming Conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1131
B Table Structures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1137
Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1193
Provides beginning and intermediate Access developers with everything they need to know to design and build Access 2007 applications
- Access 2007 is a major change from previous versions; even experienced Access developers will need a guide to its new features
- Written in a clear, easy to understand style, using the author's proven solution-oriented style
- Author is a widely-known Access expert
- Should be one of the first books available on Access 2007 for developers
Introduction
Part I The Basics of Access Development
1 Access as a Development Tool. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
2 What Every Developer Needs to Know About Databases and Tables . . . . . . . 75
3 Relationships: Your Key to Data Integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115
4 What Every Developer Needs to Know About Query Basics. . . . . . . . . . . . . . . . . 137
5 What Every Developer Needs to Know About Forms. . . . . . . . . . . . . . . . . . . . . . . . . . 189
6 What Every Developer Needs to Know About Reports. . . . . . . . . . . . . . . . . . . . . . . . 269
7 What Are Macros, and When Do You Need Them? . . . . . . . . . . . . . . . . . . . . . . . . . . . 315
8 VBA: An Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 345
9 Objects, Properties, Methods, and Events Explained . . . . . . . . . . . . . . . . . . . . . . . . . . 401
10 Advanced Form Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431
11 Advanced Report Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 493
12 Advanced Query Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 539
13 Advanced VBA Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 599
14 Exploiting the Power of Class Modules. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 637
15 What Are ActiveX Data Objects, and Why Are They Important?. . . . . . . . . . 671
Part II What to Do When Things Don’t Go as Planned
16 Debugging: Your Key to Successful Development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 727
17 Error Handling: Preparing for the Inevitable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 755
18 Optimizing Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 801
Part III Developing Multiuser and Enterprise Applications
19 A Strategy to Developing Access Applications. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 835
20 Using External Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 847
21 Access 2007 and SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 883
22 Developing Multiuser and Enterprise Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . 909
00_0672329328_FM.qxd 5/4/07 9:23 AM Page iii
Part IV Black Belt Programming
23 Working with and Customizing Ribbons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 935
24 Automation: Communicating with Other Applications. . . . . . . . . . . . . . . . . . . . . . 949
25 Exploiting the Power of the Windows API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 985
26 Creating Your Own Libraries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1011
27 Using Builders and Wizards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1027
28 An Introduction to Access and the Internet/Intranet. . . . . . . . . . . . . . . . . . . . . . . . 1055
Part V Adding Polish to Your Application
29 Documenting Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1073
30 Maintaining Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1091
31 Database Security Made Easy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1103
The following appendixes are available for download
at www.samspublishing.com/title/0672329328.
Part VI Appendixes
A Naming Conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1131
B Table Structures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1137
Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1193
Access [TRADE TITLES: SAMS] (CIS: Office Applications)
Database Applications - ACCESS [KEY TRADE TITLES] (MIS)
Alison Balter has been programming, teaching, and writing about Access for more than 12 years, since the release of Access 95. She is the author or co-author of ten books on Access. Alison is a regular speaker at conferences worldwide. She is the founder of InfoTechnology Partners, Inc. Her clients include Shell Oil, the Archdiocese of Los Angeles, Southern California Edison, Accenture, Prudential Insurance, and the International Cinematographer's Guild.
Microsoft Office 2007 is a major upgrade from the last version of Office; Access will also be greatly revised. Alison Balter is the name that Access developers will trust to guide them through Access 2007's new features. She has the rare ability to take complex topics and explain them clearly, as shown by the success of her ten previous books on Access. Balter is known for providing real-world solutions to specific Access development problems. She also is known for her ability to back up her practical examples with just enough underlying theory to give the reader a good overall understanding of Access. In short, this book will provide beginning and intermediate Access developers with everything that they need to know to design and build Access 2007 applications. It should also appeal to DBAs and power users who want or need to get started building custom Access apps. This latest book in her Mastering Access series will not disappoint her many fans who anxiously await each new version, and should win her new fans as well.
Introduction
Part I The Basics of Access Development
1 Access as a Development Tool. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
2 What Every Developer Needs to Know About Databases and Tables . . . . . . . 75
3 Relationships: Your Key to Data Integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115
4 What Every Developer Needs to Know About Query Basics. . . . . . . . . . . . . . . . . 137
5 What Every Developer Needs to Know About Forms. . . . . . . . . . . . . . . . . . . . . . . . . . 189
6 What Every Developer Needs to Know About Reports. . . . . . . . . . . . . . . . . . . . . . . . 269
7 What Are Macros, and When Do You Need Them? . . . . . . . . . . . . . . . . . . . . . . . . . . . 315
8 VBA: An Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 345
9 Objects, Properties, Methods, and Events Explained . . . . . . . . . . . . . . . . . . . . . . . . . . 401
10 Advanced Form Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431
11 Advanced Report Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 493
12 Advanced Query Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 539
13 Advanced VBA Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 599
14 Exploiting the Power of Class Modules. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 637
15 What Are ActiveX Data Objects, and Why Are They Important?. . . . . . . . . . 671
Part II What to Do When Things Don’t Go as Planned
16 Debugging: Your Key to Successful Development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 727
17 Error Handling: Preparing for the Inevitable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 755
18 Optimizing Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 801
Part III Developing Multiuser and Enterprise Applications
19 A Strategy to Developing Access Applications. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 835
20 Using External Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 847
21 Access 2007 and SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 883
22 Developing Multiuser and Enterprise Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . 909
00_0672329328_FM.qxd 5/4/07 9:23 AM Page iii
Part IV Black Belt Programming
23 Working with and Customizing Ribbons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 935
24 Automation: Communicating with Other Applications. . . . . . . . . . . . . . . . . . . . . . 949
25 Exploiting the Power of the Windows API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 985
26 Creating Your Own Libraries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1011
27 Using Builders and Wizards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1027
28 An Introduction to Access and the Internet/Intranet. . . . . . . . . . . . . . . . . . . . . . . . 1055
Part V Adding Polish to Your Application
29 Documenting Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1073
30 Maintaining Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1091
31 Database Security Made Easy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1103
The following appendixes are available for download
at www.samspublishing.com/title/0672329328.
Part VI Appendixes
A Naming Conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1131
B Table Structures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1137
Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1193
- PHIT TIPS Microsoft Access 2007
PrenticeHall
© 2008 | Prentice Hall | Study Card; 4 pages | Instock
ISBN-10: 0131588346 | ISBN-13: 9780131588349
Buy from myPearsonStore - PHIT Tips: File Management
PrenticeHall
© 2008 | Prentice Hall | Study Card; 2 pages | Instock
ISBN-10: 0131588354 | ISBN-13: 9780131588356
Buy from myPearsonStore - PHIT Tips: Microsoft Office 2007
PrenticeHall
© 2008 | Prentice Hall | Study Card; 4 pages | Instock
ISBN-10: 0132332221 | ISBN-13: 9780132332224
Buy from myPearsonStore - PHIT Tips: Microsoft Outlook 2007
PrenticeHall
© 2008 | Prentice Hall | Study Card; 4 pages | Instock
ISBN-10: 0132050625 | ISBN-13: 9780132050623
Buy from myPearsonStore - PHIT Tips: Microsoft PowerPoint 2007
PrenticeHall
© 2008 | Prentice Hall | Study Card; 4 pages | Instock
ISBN-10: 0132332558 | ISBN-13: 9780132332552
Buy from myPearsonStore - PHIT Tips: Microsoft Word 2007
PrenticeHall
© 2008 | Prentice Hall | Study Card; 4 pages | Instock
ISBN-10: 0132050617 | ISBN-13: 9780132050616
Buy from myPearsonStore - PHIT Tips: WinZip for Microsoft Office 2007
PrenticeHall
© 2008 | Prentice Hall | Study Card | Instock
ISBN-10: 0131588311 | ISBN-13: 9780131588318
Buy from myPearsonStore - Phit TIPS: Microsoft Excel 2007
PrenticeHall
© 2008 | Prentice Hall | Study Card; 4 pages | Instock
ISBN-10: 0136128017 | ISBN-13: 9780136128014
Buy from myPearsonStore - Shortcut Key Card: Microsoft Access 2007
PrenticeHall
© 2008 | Prentice Hall | Study Card | Instock
ISBN-10: 0132050609 | ISBN-13: 9780132050609
Buy from myPearsonStore - Shortcut Key Card: Microsoft Excel 2007
PrenticeHall
© 2008 | Prentice Hall | Study Card; 4 pages | Instock
ISBN-10: 0132332531 | ISBN-13: 9780132332538
Buy from myPearsonStore - Shortcut Key Card: Microsoft Office 2007
PrenticeHall
© 2008 | Prentice Hall | Study Card; 2 pages | Instock
ISBN-10: 0131588400 | ISBN-13: 9780131588400
Buy from myPearsonStore - Shortcut Key Card: Microsoft PowerPoint 2007
PrenticeHall
© 2008 | Prentice Hall | Study Card | Out of Stock
ISBN-10: 013158832X | ISBN-13: 9780131588325 - Shortcut Key Card: Microsoft Word 2007
PrenticeHall
© 2008 | Prentice Hall | Study Card; 2 pages | Instock
ISBN-10: 0136128009 | ISBN-13: 9780136128007
Buy from myPearsonStore - Windows Vista PHIT Tip
CIS Prentice Hall
© 2008 | Prentice Hall | Study Card; 4 pages | Instock
ISBN-10: 0136128025 | ISBN-13: 9780136128021
Buy from myPearsonStore
Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, contact your Pearson Higher Education representative for pricing and ordering information.
Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.