Special Edition Using Access 97

• Making the best even better: All new coverage for the #1 Access book on the market
• Over 300,000 units of Special Edition Access have been sold within the past 3 years
• Expanded coverage of VBA and Office integration

Contents

Introduction

Learning Access Fundamentals ..... 19

1. Access 97 for Access 95 and 2.0 Users: What's New ..... 21

2. Building Your First Access Application ..... 47

3. Navigating Within Access ..... 73

4. Working with Access Databases and Tables ..... 115

5. Entering, Editing, and Validating Data in Tables ..... 169

6. Sorting, Finding, and Filtering Data in Tables ..... 187

7. Linking, Importing, and Exporting Tables ..... 211

Designing Queries ..... 267

8. Using Query by Example ..... 269

9. Understanding Operators and Expressions in Access ..... 295

10. Creating Multitable and Crosstab Queries ..... 327

11. Using Action Queries ..... 377

Creating Forms and Reports ..... 399

12. Creating and Using Forms ..... 401

13. Designing Custom Multitable Forms ..... 449

14. Printing Basic Reports and Mailing Labels ..... 519

15. Preparing Advanced Reports ..... 557

Publishing Data on Intranets and the Internet ..... 583

16. Working with Hyperlinks and HTML ..... 585

17. Exporting Data to World Wide Web Pages ..... 607

18. Creating Dynamic Web Pages ..... 635

Integrating Access with Other Office 97 Applications ..... 675

19. Adding Graphics to Forms and Reports ..... 677

20. Using Access with Microsoft Excel ..... 715

21. Using Access with Microsoft Word and Mail Merg ..... 749

Using Advanced Access Techniques ..... 771

22. Exploring Relational Database Design and Implementation ..... 773

23. Working with Structured Query Language ..... 821

24. Securing Multiuser Network Applications ..... 851

25. Connecting to Client/Server Databases ..... 899

Programming and Converting Access Applications ..... 941

26. Writing Visual Basic for Applications Code ..... 943

27. Understanding the Data Access Object Class ..... 989

28. Responding to Events with VBA 5.0 ..... 1015

29. Programming Combo and List Boxes ..... 1061

30. Working with Recordsets and Native Controls ..... 1083

31. Exchanging Data with Automation and ActiveX Controls ..... 1107

32. Migrating Access 2.0 and Access 95 Applications to Access 97 ..... 1147

Appendix A: Glossary ..... 1159

Appendix B: Naming Conventions for Access Objects and Variables ..... 1203

Appendix C: Data Dictionary for the Personnel Actions Table ..... 227

Index ..... 1231