Programming Microsoft Access 2000 (Microsoft Programming Series)
Programming Microsoft Access 2000 (Microsoft Programming Series)
ISBN: 0735605009
EAN: 2147483647
EAN: 2147483647
Year: 1998
Pages: 97
Pages: 97
Authors: Rick Dobson
- 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
Programming Microsoft Access 2000 (Microsoft Programming Series)
ISBN: 0735605009
EAN: 2147483647
EAN: 2147483647
Year: 1998
Pages: 97
Pages: 97
Authors: Rick Dobson