Upsizing from Access to SQL Server
- Using the Upsizing Wizard
- Upsizing to an Access Project (ADP)
- Using DTS to Upsize Your Database
Introduction to Access Projects (ADPs)
- Overview of Access Projects
- Working with Tables
- Using Database Designs
- Creating Views
- Creating Stored Procedures
- Creating Triggers
- Managing Security
- Managing Replication
Introduction to ADO
- What is ADO?
- The ADO Object Model
- The Connection Object
- The Recordset Object
Creating Access Project Applications
- How Access Projects Talk to SQL Server
- Overview of New Properties
- Properties for Retrieving Data
- Properties for Working with Data
- Strategies for Filling Combo and List Boxes
Working with Linked Tables
- Bound Application Concepts
- Linking SQL Server Tables
- Using Local Lookup Tables
- Creating Efficient Forms
- Making the Most of Pass-Through Queries
- Performance Tips
Using ADO with Stored Procedures
- Why Use Stored Procedures?
- The Command Object
- Stored Procedures and ADO
- Using Parameters
- Returning Recordsets
Creating Unbound Applications
- Access and Scalable Applications
- Building an Unbound Access Application
- Retrieving and Displaying Data
- Data Manipulation
- The Next Step - A Middle Tier
Publishing Data with Data Access Pages and Reports
- Overview of Data Access Pages
- Publish Data with Data Access Pages
- Reports in Access Projects
- Reports in Access Databases
- Distributing Access Reports
Finishing Touches
- Finishing Touches
- Security
- Compiling the MDE
- Compiling as an ADE
- Distributing a Run-Time Application
- Run Time and the MSDE
