This trainer-friendly learning guide aims to provide the perfect solution for a one-day training course in Microsoft Access 2000. Designed for quick scanning in the classroom, it includes interactive exercises, and is part of a series of open, modular guides covering various aspects of computing.
Reihe
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Maße
ISBN-13
978-0-619-01401-8 (9780619014018)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
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.
