---

Programming Microsoft Access 2000 (Microsoft Programming Series)

ISBN: 0735605009
EAN: 2147483647

Year: 1998
Pages: 97

Authors: Rick Dobson

BUY ON AMAZON

• Cover
• LOC Page
• Dedication
• Acknowledgments
• Introduction
• What s New with Access 2000?
• Chapter 1 -- An Introduction to VBA
• Collections, Objects, Properties, Methods, and Events
• Procedures and Modules
• The VBE Interface
• Jet, Data Types, and Declarations
• Conditional Logic and Looping Constructs
• Built-In Functions
• Debugging and Error Trapping
• Macros
• Chapter 2 -- Data Access Models
• DAO Overview
• ADO Overview
• Chapter 3 -- Designing Tables
• Relational Databases and Tables
• Creating Tables with Wizards
• Creating Tables Manually
• Creating and Managing Tables Programmatically
• Chapter 4 -- Manipulating Data Using Queries
• A Review of Query Types
• Designing Queries Manually
• Special Select Queries
• Action Queries
• Programming Queries with SQL and ADO
• Querying Remote Data Sources
• Chapter 5 -- Building User Interfaces with Forms
• Splash Screen Forms
• Switchboard Forms
• Linking Forms to Data
• Looking Up and Displaying Data
• Manipulating Forms with VBA
• Using Form Classes
• Chapter 6 -- Creating Reports
• How to Create a Report
• Case Study: A FrontPage Guestbook
• Sorting, Grouping, and Calculating
• Creating Multicolumn Reports
• Distributing Reports Using Snapshots
• Making a Report Dynamic
• Dynamically Updating a Report
• Manipulating Reports and Report Controls Programmatically
• Chapter 7 -- Class, Form, and Report Modules
• Module Types
• Class Modules
• Custom Properties and Methods
• Case Study: Coding a Login Interface
• Programming Events into Custom Classes
• Using the All Collections
• Programmatically Editing Modules
• Chapter 8 -- Microsoft Office Objects
• Using the Shared Office Objects
• The FileSearch Object
• The Assistant Object
• The CommandBar Object
• Chapter 9 -- Integrating Access with Other Office Applications
• Linking Access to Other Office Applications
• Working with Excel from Access
• Working with Outlook from Access
• Working with Word from Access
• Chapter 10 -- Working with Multi-User Databases
• Sharing Files
• Sharing Forms
• Sharing Recordsets
• Security
• Transactions
• Chapter 11 -- Replicating Databases
• How Replication Works
• What s New in Access 2000 Replication
• JRO Development Techniques
• Chapter 12 -- Building Solutions with MSDE and Access Projects
• The Microsoft Data Engine
• Access Projects
• Database Diagrams and Tables
• Views and Stored Procedures
• Reports and Forms
• Programmatic Issues
• Chapter 13 -- Access 2000 Does the Web
• Traditional Approaches
• Using Hyperlinks
• Creating and Using Data Access Pages
• Chapter 14 -- The Office 2000 Developer Edition
• ODE Overview
• The Code Librarian
• Packaging and Deploying Solutions
• Data Access in Non-Access Applications
• Digitally Signing VBA Projects
• Appendix -- Third-Party Sample Applications and Demos
• Database Creations
• FMS
• Visio
• About the Author