9780782140088

Summary

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 Server2s 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

xxxiii

PART I. AN OVERVIEW OF ACCESS

(124)

Getting Started and Getting Around

(34)

Understanding Databases

(10)

Access in an Evening

(54)

About Access, Office, Windows, and the Internet

101

(24)

PART II. CREATING A DATABASE PROJECT

125

(482)

Creating a Database

127

(16)

Creating Access Tables

143

(50)

Linking, Importing, and Exporting Data

193

(44)

Adding, Editing, and Viewing Data

237

(50)

Sorting, Searching, Filtering, and Printing

287

(44)

Querying Your Tables

331

(54)

Creating Forms with Form Wizards

385

(24)

Creating Reports with Report Wizards

409

(26)

Creating Custom Forms and Reports

435

(84)

Creating Data Access Pages

519

(48)

Creating Charts and PivotTables

567

(40)

PART III. DATABASE TUNING AND ADMINISTRATION

607

(88)

Personalizing Access

609

(26)

Speeding Up Your Database

635

(10)

Administering Your Database

645

(20)

Networking and Security

665

(30)

PART IV. BUILDING A CUSTOM APPLICATION

695

(124)

Creating a Custom Application

697

(14)

Using Macros to Create Custom Actions

711

(32)

Creating Custom Switchboards

743

(24)

Creating Custom Dialog Boxes

767

(22)

Creating Custom Toolbars

789

(18)

Creating Custom Menus

807

(12)

PART V. REFINING A CUSTOM APPLICATION

819

(68)

Introducing Visual Basic

821

(14)

Creating Custom Error Messages

835

(14)

Interacting with Other Programs

849

(10)

Pulling It All Together

859

(12)

Working with Projects

871

(16)

PART VI. MACRO PROGRAMMING FROM INDUSTRY EXPERT SUSANN NOVALIS

887

(200)

Macro Basics

889

(58)

Dealing with Errors in Macros

947

(22)

Navigation with Macros

969

(38)

Data Maintenance with Macros

1007

(34)

Working with Groups of Records Using Macros

1041

(46)

PART VII. APPENDICES

1087

(52)

A Checking Your Hardware

1090

(7)

B About the CD-ROM

1097

(8)

C Installing and Using Fulfill 2002

1105

(34)

Index

1139

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.