You are previewing Special Edition Using Access 97, Second Edition.
O'Reilly logo
Special Edition Using Access 97, Second Edition

Book Description

Special Edition Using Access 97, Second Edition, is your authoritative guide to mastering every facet of this powerful 32-bit database development platform. Get started quickly by using the Database Wizard to create a working Access 97 application in less than 30 minutes. Detailed, step-by-step instructions guide you through the process of designing and using Access tables, queries, forms, and reports. Newly added chapters on advanced VBA 5.0 techniques pave your way to Access programming expertise. Plus, you get full coverage of the latest updates to Access 97, including report Snapshot technology from Office Service Release 1 and the Upsizing Wizard for SQL Server 6.5+.

Table of Contents

  1. Copyright
  2. About the Author
  3. Acknowledgments
  4. Introduction
  5. Learning Access Fundamentals
    1. Access 97 for Access 95 and 2.0 Users: What's New
      1. Analyzing Access 97's Enhancements and Changes
      2. Summarizing Access 95's Improvements to Access 2.0
      3. Installing Access 97
      4. Installing ValuPack Components
      5. Installing the Office Developer Edition Components
      6. Updating Access 97 with Office 97 Service Release 1
    2. Building Your First Access Application
      1. Creating an Access Application from a Template File
      2. Touring the Contact Management Application
      3. Using the Switchboard Manager
      4. Exploring Form Design View and VBA Class Modules
      5. Putting What You've Learned in Perspective
    3. Navigating Within Acces
      1. Understanding Access's Functions and Modes
      2. Understanding Access's Table Display
      3. Using the Function Keys
      4. Setting Default Options
      5. Using Access Help
      6. Using the Database Utilities
    4. Working with Access Databases and Tables
      1. Defining the Elements of Access Databases
      2. Understanding Relational Databases
      3. Using Access Database Files and Tables
      4. Creating a New Database
      5. Understanding the Properties of Tables and Fields
      6. Choosing Field Data Types, Sizes, and Formats
      7. Using the Northwind Traders Sample Database
      8. Setting Default Values of Fields
      9. Working with Relations, Key Fields, and Indexes
      10. Altering Fields and Relationships
      11. Copying and Pasting Tables
    5. Entering, Editing, and Validating Data in Tables
      1. Using Keyboard Operations for Entering and Editing Data
      2. Adding Records to a Table
      3. Selecting, Appending, Replacing, and Deleting Table Records
      4. Validating Data Entry
      5. Adding Records to the Personnel Actions Table
      6. Entering Personnel Actions Table Data and Testing Validation Rules
    6. Sorting, Finding, and Filtering Data in Tables
      1. Sorting Table Data
      2. Finding Matching Records in a Table
      3. Replacing Matched Field Values Automatically
      4. Filtering Table Data
      5. Customizing Datasheet View
      6. Copying, Exporting, and Mailing Sorted and Filtered Data
    7. Linking, Importing, and Exporting Tables
      1. Understanding How Access Handles Tables in Other Database File Formats
      2. Importing and Linking Spreadsheet Files
      3. Importing Text Files
      4. Using the Clipboard to Import Data
      5. Modifying Linked and Imported Tables
      6. Exporting Data from Access Tables
  6. Designing Queries
    1. Using Query by Example
      1. Understanding Queries
      2. Creating Your First Real Query
      3. Creating Other Types of Queries
      4. Translating Graphical QBE to Structured Query Language
    2. Understanding Operators and Expressions in Access
      1. Understanding the Elements in Expressions
      2. Creating Access Expressions
    3. Creating Multitable and Crosstab Queries
      1. Joining Tables to Create Multitable Queries
      2. Using Lookup Fields in Tables
      3. Outer, Self, and Theta Joins
      4. Updating Table Data with Queries
      5. Making All Fields of Tables Accessible
      6. Making Calculations on Multiple Records
      7. Designing Parameter Queries
      8. Creating Crosstab Queries
      9. Creating Queries from Tables in Other Databases
    4. Using Action Queries
      1. Creating New Tables with Make-Table Queries
      2. Creating Action Queries to Append Records to a Table
      3. Deleting Records from a Table with an Action Query
      4. Updating Values of Multiple Records in a Table
      5. Testing Cascading Deletion and Updating
  7. Creating Forms and Reports
    1. Creating and Using Forms
      1. Identifying Types of Forms
      2. Creating a Transaction-Processing Form with the Form Wizard
      3. Using the Form Design Window
      4. Selecting, Editing, and Moving Form Elements and Controls
      5. Rearranging the Personnel Actions Form
      6. Using Transaction-Processing Forms
      7. Modifying the Properties of a Form or Control After Testing
    2. Designing Custom Multitable Forms
      1. Understanding the Access Toolbox
      2. Using the Toolbox to Add Controls
      3. Completing the Main Personnel Actions Entry Form
      4. Creating a Subform Using the Subform/Subreport Wizard
      5. Creating and Using Continuous Forms
      6. Overriding the Field Properties of Tables
      7. Adding Page Headers and Footers for Printing Forms
    3. Printing Basic Reports and Mailing Labels
      1. Differences and Similarities Between Forms and Reports
      2. Types of Access Reports
      3. Creating a Grouping Report with the Report Wizard
      4. Using Access's Report Windows
      5. Using AutoFormat and Customizing Report Styles
      6. Modifying a Basic Report Wizard Report
      7. Adjusting Margins and Printing Conventional Reports
      8. Preventing Widowed Records with the Group Keep Together Property
      9. Printing Multicolumn Reports as Mailing Labels
    4. Preparing Advanced Reports
      1. Grouping and Sorting Report Data
      2. Working from a Blank Report
      3. Incorporating Subreports
      4. Adding Other Controls to Reports
      5. Sending Reports by Microsoft Exchange and Outlook
      6. Mailing Reports in Access Snapshot Format
  8. Publishing Data on Intranets and the Internet
    1. Working with Hyperlinks and HTML
      1. Putting Microsoft's Internet Program in Perspective
      2. Navigating with Hyperlinks
      3. Understanding Access 97's Hyperlink Field Data Type
      4. Specifying Internet Uniform Resource Locators
      5. Using Hyperlinks with Access Controls
    2. Exporting Data to World Wide Web Pages
      1. Exporting Table and Query Datasheets to HTML
      2. Using HTML Templates
      3. Exporting Reports to HTML
      4. Using the Publish to the Web Wizard to Create a Static Web Site
      5. Importing Data from HTML Tables
    3. Creating Dynamic Web Pages
      1. Understanding Microsoft's View of Databases and the Web
      2. Using the IDC for Delivering Information
      3. Exporting Datasheets to Dynamic Web Pages
      4. Exporting Tables, Queries, and Forms to Active Server Pages
  9. Integrating Access with Other Office 97 Applications
    1. Adding Graphics to Forms and Reports
      1. Adding a Bound Object Control to a Form or Report
      2. Adding an Unbound Object Frame to a Form or Report
      3. Using the Image Control
      4. Creating Graphs and Charts with Microsoft Graph 97
    2. Using Access with Microsoft Excel
      1. Importing and Reorganizing Worksheet Data
      2. Using Excel as an OLE Server
    3. Using Access with Microsoft Word and Mail Merge
      1. Using the Access Mail Merge Wizard
      2. Using Word 97's Mail Merge Feature with Access Databases
      3. Embedding or Linking Word Documents in Access Tables
  10. Using Advanced Access Techniques
    1. Exploring Relational Database Design and Implementation
      1. Integrating Objects and Relational Databases
      2. Understanding Database Systems
      3. Using Data Modeling Tools to Create Access Databases
      4. Normalizing Data to the Relational Model
      5. Using Access 97's Table Analyzer Wizard
      6. Working with Data Dictionaries
      7. Using Access Indexes
      8. Enforcing Database Integrity
    2. Working with Structured Query Language
      1. Using Access to Learn SQL
      2. Understanding Structured Query Language
      3. Looking at the Development of SQL
      4. Comparing ANSI and Jet SQL
      5. Writing Select Queries in SQL
      6. Adding IN to Use Tables in Another Database
      7. Using SQL Statements in Forms, Reports, and Macros
    3. Securing Multiuser Network Applications
      1. Networking Access Applications
      2. Installing Access in a Networked Environment
      3. Sharing Your Access Database Files with Other Users
      4. Using Command-Line Options to Open a Shared Database
      5. Maintaining Database Security
      6. Understanding Database Object Ownership
      7. Granting and Revoking Permissions for Database Objects
      8. Sharing Databases on the Network
      9. Administering Databases and Applications
    4. Connecting to Client/Server Databases
      1. Creating Scalable Access Applications
      2. Defining the Client/Server Environment
      3. Defining Open Database Connectivity
      4. Understanding ODBC Drivers
      5. Installing the Microsoft ODBC Driver for SQL Server
      6. Adding and Removing SQL Server Data Sources
      7. Using Databases Connected by ODBC
      8. Using Access 97's SQL Pass-Through Queries
      9. Exporting Access Tables to a Client/Server Database
  11. Programming and Converting Access Applicationys
    1. Writing Visual Basic for Applications Code
      1. Introducing Access VBA
      2. Controlling Program Flow
      3. Handling Runtime Errors
      4. Exploring the Module Window
      5. Examining the Utility Functions Module
      6. Writing Your Own Functions and Procedures
    2. Understanding the Data Access Object Class
      1. Understanding Objects and Object Collections
      2. Creating New Data Access Objects
      3. Writing a Function that Uses Database Objects
      4. Using ODBCDirect and the Remote Data Object
    3. Responding to Events with VBA 5.0
      1. Understanding the Role of Class Modules
      2. Understanding Access 97's Event Repertoire
      3. Working with Access 97's DoCmd Methods
      4. Converting Access Macros to VBA Code
      5. Referring to Access Objects with VBA
      6. Responding to Data Events
    4. Programming Combo and List Boxes
      1. Constraining Query Choices with Combo Boxes
      2. Drilling Down from a List Box Selection
      3. Adding New Features to List and Combo Boxes
    5. Working with Recordsets and Native Controls
      1. Navigating Recordsets with VBA
      2. Modifying Rows of Recordsets
      3. Populating a Combo Box from a Recordset
    6. Exchanging Data with Automation and ActiveX Controls
      1. Introducing Microsoft's ActiveX Technology
      2. Understanding Automation
      3. Using Automation Servers with Access 97
      4. Adding ActiveX Controls to Your Application
      5. Using Access 97 as an Automation Server
    7. Migrating Access 2.0 and Access 95 Applications to Access 97
      1. Using Access 2.0 Application .mdb Files with Access 97
      2. Using Access 1.x and 2.0 Data .mdb Files with Access 97
      3. Converting Access 1.x and 2.0 Files to Access 95
      4. Converting Access 95 Databases to Access 97 Format
  12. Appendixes
    1. Glossary
    2. Naming Conventions for Access Objects and Variables
      1. The Leszynski Naming Conventions for Microsoft Access: A Primer
      2. Access Object Types
      3. Structuring Object Names
      4. Creating Database Object Base Names
      5. Naming Conventions for Database Objects
      6. Creating VBA Object Base Names
      7. Creating Your Own Tags
      8. How to Get the Complete Text of the LNC
    3. Data Dictionary for the Personnel Actions Table