List of Try It Outs

Introduction

Try It Out

Chapter 2: The Basics of Writing and Testing VBA Code

Try it Out-Create a Database to Use with Examples in the Chapter
Try It Out-Creating the VerifyCreditAvail Procedure
Try It Out-Calling VerifyCreditAvail from Another Procedure
Try It Out-Create New Procedure for frmTest Using Code Builder
Try It Out-Creating the CalculateSalesTax Function
Try It Out-Declaring a Public Variable
Try It Out-Creating TestIfStatement Procedure
Try It Out-Create the TestCaseStatement Procedure
Try It Out-Creating a For … Next Loop
Try It Out-Setting and Using Breakpoints
Try It Out-Using the Locals Window
Try It Out-Adding a Watch
Try It Out-Creating an Error Handler
Try It Out-Creating a Generic Error Handler

Chapter 3: Programming Applications Using Objects

Try It Out-Using Properties, Methods, and Events
Try It Out-Using the Forms Collection and Form Object
Try It Out-Using the Screen Object
Try It Out-Using the Printers Collection and Printer Object

Chapter 4: Creating Your Own Objects

Try It Out-Creating the Properties for the Car Class
Try It Out-Creating the Methods for the Car Class
Try It Out-Creating an Event for the Car Class
Try It Out-Using the Properties, Methods, and Events of the Car Class
Try It Out-Adding New Property for frmCarDetails Form
Try It Out-Adding New Method for the frmCarDetails Form

Chapter 5: Interacting with Data Using ADO and SQL

Try It Out-Building a Contacts Form Bound to a Recordset
Try It Out-Building an Unbound Contacts Form Using a Disconnected Recordset
Try It Out-Sorting Records for the Unbound Contacts Form
Try It Out-Modify the Unbound Contacts Form to Use SQL

Chapter 6: Building Interactive Forms

Try It Out-Building a Switchboard Form
Try It Out-Populating Combo and List Boxes
Try It Out-Adding Data Validation to the frmPayments Form

Chapter 7: Importing, Linking, and Exporting Using External Data Sources

Try It Out-Importing Data from the Sample Northwind Database
Try It Out-Importing Data from a Text File

Chapter 8: Using Access with Web Services and SharePoint Lists

Try It Out-Adding a Reference to a Web Service
Try It Out-Consuming the GetPlaceFacts Method
Try It Out-Importing Lists Using the Wizard
Try It Out-Programmatically Linking a List Using DoCmd Object
Try It Out-Programmatically Linking a List Using a TableDef Object

Chapter 9: Creating Reports and Web-Enabled Output

Try It Out-Creating a Report Programmatically
Try It Out-Exporting the tblComplaints Table to HTML

Chapter 10: Building SQL Server Applications with Access Projects

Try It Out-Creating an Access Project Using a New SQL Server Database
Try It Out-Creating a New SQL Server Table
Try It Out-Creating a New SQL Server Stored Procedure
Try It Out-Creating a New View

Chapter 11: Advanced Access Programming

Try It Out-Using the Microsoft Office Object Library to Create a Custom Command Bar
Try It Out-Using an External DLL to Get System Information
Try It Out-Controlling an Excel Spreadsheet from Access
Try It Out-Creating Word Letters from Access
Try It Out-Sending an Outlook E-mail from Access
Try It Out-Creating and Using a Code Library

Chapter 12: Finishing the Application

Try It Out-Using the Database Splitter Wizard to Separate Database Tables from the User Interface
Try It Out-Using the Performance Analyzer

Chapter 13: Case Study 1-Project Tracker Application

Try It Out-Building the ProjectTrackerDb Database
Try It Out-Building the frmProjects and frmContacts Forms
Try It Out-Building the clsProjects Class
Try It Out-Building the clsContacts Class
Try It Out-Building the modBusinessLogic and modDatabaseLogic Modules
Try It Out-Writing Code for the frmProjects Form
Try It Out-Writing Code for the frmContacts Form

Chapter 14: Case Study 2-Customer Service Application

Try It Out-Building the CustomerServiceSQL Database
Try It Out-Building the frmSearch and frmCustomers Forms
Try It Out-Building the clsCustomer Class
Try It Out-Building the modBusinessLogic and modDatabaseLogic Modules
Try It Out-Writing Code for the frmSearch
Try It Out-Writing Code for the frmCustomers