Register your product to gain access to bonus material or receive a coupon.
Special Edition Using Microsoft Access 2002
- By Roger Jennings
- Published Jun 21, 2001 by Que.
eBook (Adobe DRM)
- Sorry, this book is no longer in print.
- About Adobe DRM eBooks
- Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
- Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.
This eBook requires the free Adobe® Digital Editions software.
Before downloading this DRM-encrypted PDF, be sure to:
Description
- Copyright 2001
- Pages: 1488
- Edition: 1st
- eBook (Adobe DRM)
- ISBN-10: 0-7686-5612-5
- ISBN-13: 978-0-7686-5612-1
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.
1. Access 2002 for Access 97 and 2000 Users: What's New.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.
2. Exploring Relational Database Theory and Practice.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?
3. Building a Simple Desktop and Web Application.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.
4. Navigating the Access User Interface.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.
5. Working with Jet Databases and Tables.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.
6. Entering, Editing, and Validating Jet Table Data.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.
7. Sorting, Finding, and Filtering Data.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.