Quickly tap the enhanced power, performance, and extensibility of Microsoft Access 2000 with this in-depth developer's guile. Whether you're extending an existing database or developing a sophisticated custom solution, PROGRAMMING MICROSOFT ACCESS 2000 prcvides the detailed guidance and rich, adaptable code samples you need to get productive quickly.
- Explore Microsoft Access 2000 support for OLE DB and for ActiveX Data Objects (ADO)-the fastest and most productive way to access enterprise data sources
- Learn how to connect to data soures, work with recordsets, build tables, and design queries using ADO-based examples
- Investigate multiuser and transaction issues-including record, page, and table locking, managing Jet-based replication; and programming user-level security
- Integrate Microsoft Access seamlessly with Microsoft SQL Server databases to deliver powerfully scalable solutions through an easy-to-use client interface
- Easily extend your data solutions to the Web with data access pages, scripting, and Microsoft Office 2000 Web components
- Use shared Microsoft Office object models and the shared Visual
Basic for Applications(VBA) programming language to expedite development
Chapter 1 An Introduction to VBA
Chapter 2 Data Access Models
Chapter 3 Designing Tables
Chapter 4 Manipulating Data Using Queries
Chapter 5 Building User Interfaces
Chapter 6 Creating Reports
Chapter 7 Class, Form, and Report Modules
Chapter 8 Microsoft Office Objects
Chapter 9 Integrating Access with Other office Application
Chapter 10 Working with Multi - User Databases
etc.