Microsoft Access 2000

Unit 1: advanced form techniques; controlling data entry with functions (Dlookup and IIF); creating grouped controls; creating subforms. Unit 2: working with macros in forms; creating and running macros; attaching macros to command buttons in forms; attaching macros to events in forms. Unit 3: advanced macro techniques; creating data entry macros; creating decision-making macros; creating AutoKey and AutoExec macros. Unit 4: exploring Access SQL; SQL overview; writing SQL statements; assigning SQL statements to objects. Unit 5: working with modules; exploring the module window; using the debug window; working with Visual Basic code; creating user-defined functions; creating loops and case statements.