Special Edition Using Microsoft Access 2002

Description

Special Edition Using Access 2002 is a reader's authoritative guide to mastering the essential facets of this powerful database development platform. Detailed, step-by-step instructions guide the reader through the process of designing and using Access tables, queries, forms and reports.

Special Edition Using Access 2002 will include comprehensive coverage of the transition to MSDE/SQL Server for all multi-user applications, expanded coverage of Web Applications, and expanded coverage of XML.

This book contains elements such as Tips, Notes, cautions, cross-references and Troubleshooting information, giving the text a "Layered" quality that meets the needs of readers with different learning styles.

Sample Content

Table of Contents

Introduction.

I. GETTING ACQUAINTED WITH ACCESS 2002.

Welcome to Another Access Upgrade. Changes to Basic Access 2000 Features. PivotTable and PivotChart Views. Access Data Projects and SQL Server 2000. Using XML Static Data Import and Export. Data Access Pages Revisited. Programmability Enhancements. Access 2002 Installation. SQL Server 2000 Desktop Engine Setup. Troubleshooting. In the Real World-The Road to Access.NET.

Moving from Spreadsheets to Databases. Reliving Database History. Defining the Structure of Relational Databases. Conforming to Table Design Rules. Choosing Primary Key Codes. Maintaining Data Integrity and Accuracy. Displaying Data with Queries and Views. Partitioning Databases. In the Real World-When and Why Learn Relational Theory?

Understanding Access's Approach to Application Design. Creating an Access Application from a Template File. Touring the Contact Management Application. Using the Switchboard Manager. Exploring Form Design View and VBA Class Modules. Downloading Templates from the Microsoft Office Update Site. Saving a Form As a Data Access Page. In the Real World-Putting What You've Learned in Perspective.

Understanding Access Functions and Modes. Opening the Northwind.mdb Sample Database. Understanding Access's Table Display. Using the Function Keys. Setting Default Options. Using Access Help. Using the Database Utilities. Troubleshooting. In the Real World-HTML Help or Hindrance.

II. LEARNING THE FUNDAMENTALS OF JET DATABASES.

Understanding Jet Database Files. Creating a New Jet Database. Exploring the Properties of Tables and Fields. Choosing Field Data Types, Sizes, and Formats. Working with the Northwind Traders Sample Database. Preparing to Add a Table Related to the Employees Table. Designing the HRActions Table. Setting Default Values of Fields. Working with Relations, Key Fields, and Indexes. Altering Fields and Relationships. Copying and Pasting Tables. Using the Table Analyzer Wizard. Generating a Data Dictionary with the Database Documenter. Troubleshooting. In the Real World-Database Strategy and Table Tactics.

Entering Data in Access Tables. Using Keyboard Operations for Entering and Editing Data. Adding Records to a Table. Selecting, Appending, Replacing, and Deleting Table Records. Validating Data Entry. Adding Records to the HRActions Table. Testing Field and Table Validation Rules. Troubleshooting. In the Real World-Heads-Down Data Entry.

Understanding the Role of Sorting and Filtering. Sorting Table Data. Finding Matching Records in a Table. Replacing Matched Field Values Automatically. Filtering Table Data. Applying Advanced Filters and Sort Orders. Customizing Table Datasheet View. Copying, Exporting, and Mailing Sorted and Filtered Data. Troubleshooting. In the Real World-Computer-Based Sorting and Searching. 

Updates

Submit Errata