Access 2002/2003 Level 2: Programming

Price: $1195

Description:

Level 2 looks at the critical aspects of application development using Microsoft Access. You'll dig deeper into forms, tables, queries, and reports, and explore modules as you learn to use Visual Basic for Applications (VBA). Level 2 teaches you both how to design effective database applications, including database normalization and relationships, rules, and indexes; and how to work with VBA to manipulate objects and data. You?ll learn how to programmatically display and manipulate data on forms and reports, and you?ll begin to work with the Internet features in Microsoft Access as you create and deploy Data Access Pages.

In Level 2 you will learn...

• Start using VBA in Microsoft Access.
• Design efficient table structures to organize your data.
• Create relationships between tables and set up referential integrity.
• Display filtered and sorted data on forms and reports.
• Master tips and tricks that create great reports.
• Publish live Access data on the Web using Data Access Pages.
• Work with forms? recordsets.

Prerequisites:

To get the most out of Programming in Microsoft Access, you should understand how to create and use all the interactive Access objects: Tables, queries, forms, and reports. Programming experience in any language is helpful, but not required.