Access 2002

Master all the powerful features of Access 2002. This complete reference explains in full detail how to design and use Access tables, queries, forms, and reports and maximize all the program's capabilities. Chapters on VBA techniques pave your way to Access programming, and a special section on using Access on the Internet is also included. The CD-ROM contains database files from the book's examples so you can recreate the sample projects. You'll also get Test Yourself software to help you prepare for the MOUS Certification Exams for Access 2002.
The Most Authoritative Guide to the #1 Database Program
Build a highly responsive Access database, and turn information into a powerful tool. Access 2002: The Complete Reference contains everything you need to gather, organize, and analyze data more effectively than ever. Construct a comprehensive information management solution, then raise productivity and decision efficiency based on analysis of data trends and relationships. Learn to streamline your work with wizards, queries, and sorting and filtering methods. Enable secure online use, multiple party access, and remote data management. Plus—get a hit-the-ground-running introduction to Visual Basic and learn to integrate Access data with outside sources.

• Track and plan for, new trends by using this powerful relational database program
• Work concurrently on databases with multiple users—on site or remotely
• Collaborate over an intranet or the Internet with dynamic or static data
• Integrate Access with other components of the Microsoft Office XP suite
• Create advanced queries to extract and manipulate specific information
• Learn multiple task pathways for accomplishing simple to complex Access functions
• Utilize flexible functionality—including sorting, filtering, writing macros, and more
• Create and customize all manner of data interpretation and presentation grids
• Locate and retrieve stored information quickly from existing databases

Contents

Part I: Getting Started.

• Chapter 1: Quick Tour of Access 2002.
• Chapter 2: The World of Relational Databases.
• Chapter 3: Creating a Database.
• Chapter 4: Creating and Modifying Tables.
• Chapter 5: Relating Tables.
• Chapter 6: Entering and Editing Data.

Part II: Retrieving and Presenting Information.

• Chapter 7: Sorting, Filtering and Printing Records.
• Chapter 8: Extracting Information with Queries.
• Chapter 9: Creating Advanced Queries.
• Chapter 10: Creating Form and Report Designs.
• Chapter 11: Using the Form Wizard.
• Chapter 12: Customizing Forms.
• Chapter 13: Using the Report Wizard.
• Chapter 14: Customizing Reports.
• Chapter 15: Creating Charts, PivotTables, and PivotCharts.

Part III: Improving the Workplace.

• Chapter 16: Customizing the Workplace.
• Chapter 17: Improving Database Performance.
• Chapter 18: Understanding Events and the Event Model.
• Chapter 19: Automating with Macros.
• Chapter 20: Customizing Menus and Toolbars.
• Chapter 21: Creating Custom Switchboards and Dialog Boxes.
• Part IV: Exchanging Data with Others
• Chapter 22: Exchanging Databases Objects and Text
• Chapter 23: Exchanging Data with Outside Sources
• Chapter 24: Access 2002 on the Internet

Part V: Application Development

• Chapter 25: Introducing Microsoft Visual Basic
• Chapter 26: Sharing with multiple Users
• Chapter 27: Securing a Database
• Chapter 28 Developing an End-User Application
• Chapter 29: Converting to Access 2002