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
- Copyright
- About the Author
- Acknowledgments
- Introduction
-
Learning Access Fundamentals
- Access 97 for Access 95 and 2.0 Users: What's New
- Building Your First Access Application
- Navigating Within Acces
-
Working with Access Databases and Tables
- Defining the Elements of Access Databases
- Understanding Relational Databases
- Using Access Database Files and Tables
- Creating a New Database
- Understanding the Properties of Tables and Fields
- Choosing Field Data Types, Sizes, and Formats
- Using the Northwind Traders Sample Database
- Setting Default Values of Fields
- Working with Relations, Key Fields, and Indexes
- Altering Fields and Relationships
- Copying and Pasting Tables
- Entering, Editing, and Validating Data in Tables
- Sorting, Finding, and Filtering Data in Tables
- Linking, Importing, and Exporting Tables
-
Designing Queries
- Using Query by Example
- Understanding Operators and Expressions in Access
-
Creating Multitable and Crosstab Queries
- Joining Tables to Create Multitable Queries
- Using Lookup Fields in Tables
- Outer, Self, and Theta Joins
- Updating Table Data with Queries
- Making All Fields of Tables Accessible
- Making Calculations on Multiple Records
- Designing Parameter Queries
- Creating Crosstab Queries
- Creating Queries from Tables in Other Databases
- Using Action Queries
-
Creating Forms and Reports
-
Creating and Using Forms
- Identifying Types of Forms
- Creating a Transaction-Processing Form with the Form Wizard
- Using the Form Design Window
- Selecting, Editing, and Moving Form Elements and Controls
- Rearranging the Personnel Actions Form
- Using Transaction-Processing Forms
- Modifying the Properties of a Form or Control After Testing
- Designing Custom Multitable Forms
-
Printing Basic Reports and Mailing Labels
- Differences and Similarities Between Forms and Reports
- Types of Access Reports
- Creating a Grouping Report with the Report Wizard
- Using Access's Report Windows
- Using AutoFormat and Customizing Report Styles
- Modifying a Basic Report Wizard Report
- Adjusting Margins and Printing Conventional Reports
- Preventing Widowed Records with the Group Keep Together Property
- Printing Multicolumn Reports as Mailing Labels
- Preparing Advanced Reports
-
Creating and Using Forms
- Publishing Data on Intranets and the Internet
- Integrating Access with Other Office 97 Applications
-
Using Advanced Access Techniques
- Exploring Relational Database Design and Implementation
- Working with Structured Query Language
-
Securing Multiuser Network Applications
- Networking Access Applications
- Installing Access in a Networked Environment
- Sharing Your Access Database Files with Other Users
- Using Command-Line Options to Open a Shared Database
- Maintaining Database Security
- Understanding Database Object Ownership
- Granting and Revoking Permissions for Database Objects
- Sharing Databases on the Network
- Administering Databases and Applications
-
Connecting to Client/Server Databases
- Creating Scalable Access Applications
- Defining the Client/Server Environment
- Defining Open Database Connectivity
- Understanding ODBC Drivers
- Installing the Microsoft ODBC Driver for SQL Server
- Adding and Removing SQL Server Data Sources
- Using Databases Connected by ODBC
- Using Access 97's SQL Pass-Through Queries
- Exporting Access Tables to a Client/Server Database
-
Programming and Converting Access Applicationys
- Writing Visual Basic for Applications Code
- Understanding the Data Access Object Class
- Responding to Events with VBA 5.0
- Programming Combo and List Boxes
- Working with Recordsets and Native Controls
- Exchanging Data with Automation and ActiveX Controls
- Migrating Access 2.0 and Access 95 Applications to Access 97
- Appendixes
Product information
- Title: Special Edition Using Access 97, Second Edition
- Author(s):
- Release date: October 1997
- Publisher(s): Que
- ISBN: 0789714523
You might also like
book
Special Edition Using Microsoft® Access 2000
Special Edition Using Access 2000 is your authoritative guide to mastering the essentials of this powerful …
book
Special Edition Using Microsoft Windows Vista, Second Edition
SPECIAL EDITION Microsoft® Windows Vista® Second Edition The only Windows Vista book you need We crafted …
book
Special Edition Using Microsoft® Office Access 2003
Special Edition Using Microsoft Office Access 2003 is a comprehensive reference for all the features of …
book
Special Edition Using Microsoft® Office XP
With this edition of Special Edition Using Office XP there is a continual emphasis on realistic …