• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part III: Automate Your Access Database ... > Access Visual Basic Tools, Tips, and...

Chapter 12. Access Visual Basic Tools, Tips, and Techniques

In the last chapter, you learned about how to trap and handle Access errors. In this chapter, you learn about programming with both DAO and ADO object models. The two object models are compared from a number of different standpoints. Specifically, you learn

  • how to use object models to run queries

  • how to determine the best method to manipulate recordsets

  • how to evaluate performance criteria to determine the best object model to use

  • how to use the collections of DAO and ADO

  • examples of using SQL with VBA

  • how to use variables with SQL


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint