Skip to main content

Mastering Access 2002, Premium Edition

Mastering Access 2002, Premium Edition

ISBN: 978-0-782-15304-0

Feb 2006

1177 pages

Select type: E-Book

$32.99

Product not available for purchase

Description

Master Everything Access 2002 Has to Offer

Reap the benefits of the latest release of Microsoft Access with Mastering Access 2002 Premium Edition. Get clelear, in-depth coverage of the entire range of Access functionality, from basic to advanced. Special attention to new features makes the transition from an earlier version quick and painless, and 200 pages of bonus macro material teaches you ways to customize and automate Access to make it work for you.

Establish Key Skills

  • Create a database that meets your precise needs
  • Design easy-to-use forms with effective visual elements
  • Expand and collapse views to bring in supporting details
  • Import and export data, including XML
  • Examine data using subdatasheet views
  • Summarize, analyze, and trend data with PivotTables and PivotCharts
  • Filter data and create reports
  • Publish Access data to a Web server
  • Personalize Access menus and toolbars
  • Keep your data secure
  • Take advantage of improved integration with other Office applications
  • Create custom error messages

Then Tackle These Cutting-Edge Topics

  • Recording and running macros
  • Maintaining data with macros
  • Handling complex macro navigation
  • Using macros to work with groups of records
  • Identifying and correcting macro errors
  • Using Access as SQL Server's front end
  • Using Access as the core of a database-driven Web site
  • Managing replication and conflict resolution
  • Using Visual Basic to get the most out of Access

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Introduction.

PART I: AN OVERVIEW OF ACCESS.

Chapter 1: Getting Started and Getting Around.

Chapter 2: Understanding Databases.

Chapter 3: Access in an Evening.

Chapter 4: About Access, Office, Windows, and the Internet.

PART II: CREATING A DATABASE PROJECT.

Chapter 5: Creating a Database.

Chapter 6: Creating Access Tables.

Chapter 7: Linking, Importing, and Exporting Data.

Chapter 8: Adding, Editing, and Viewing Data.

Chapter 9: Sorting, Searching, Filtering, and Printing.

Chapter 10: Querying Your Tables.

Chapter 11: Creating Forms with Form Wizards.

Chapter 12: Creating Reports with Report Wizards.

Chapter 13: Creating Custom Forms and Reports.

Chapter 14: Creating Data Access Pages.

Chapter 15: Creating Charts and PivotTables.

PART III: DATABASE TUNING AND ADMINISTRATION.

Chapter 16: Personalizing Access.

Chapter 17: Speeding Up Your Database.

Chapter 18: Administering Your Database.

Chapter 19: Networking and Security.

PART IV: BUILDING A CUSTOM APPLICATION.

Chapter 20: Creating a Custom Application.

Chapter 21: Using Macros to Create Custom Actions.

Chapter 22: Creating Custom Switchboards.

Chapter 23: Creating Custom Dialog Boxes.

Chapter 24: Creating Custom Toolbars.

Chapter 25: Creating Custom Menus.

PART V: REFINING A CUSTOM APPLICATION.

Chapter 26: Introducing Visual Basic.

Chapter 27: Creating Custom Error Messages.

Chapter 28: Interacting with Other Programs.

Chapter 29: Pulling It All Together.

Chapter 30: Working with Projects.

PART VI: MACRO PROGRAMMING FROM INDUSTRY EXPERT SUSANN NOVALIS.

Chapter 31: Macro Basics.

Chapter 32: Dealing with Errors in Macros.

Chapter 33: Navigation with Macros.

Chapter 34: Data Maintenance with Macros.

Chapter 35: Working with Groups of Records Using Macros.

PART VII: APPENDICES.

Appendix A: Checking Your Hardware.

Appendix B: About the CD-ROM.

Appendix C: Installing and Using Fulfill 2002.

Index.