2007 Access Intermediate
The skills you will learn in these programs will teach you many ways to make working with Access easier and more efficient through queries, forms, and reports. Take this opportunity and learn to normalize database tables, automate actions, and increase the usefulness of queries, forms, and reports.
Note: Each session can be taken separately or in any combination depending upon your skill level.
Check the Training Schedule for dates, times, and cost.
•Relational database model
•Normalization procedures for relational databases
•Primary key, foreign key, composite primary key
•Setting table relationships (1:1, 1:many, many:many) and joins
•Enforcing referential integrity
Session Two 1.5 hrs.
•Advanced field properties including dropdown lists and data validation
•Enhance form design (calculations, subforms, command buttons)
•Automate actions by building your own macros
Session Three 1.5 hrs.
•Calculate expressions and summary field values in queries
•Create queries - parameter, update, append, delete, find unmatched, crosstab
Session Four 1.5 hrs.
•Specialized report features (expressions, grouping, page breaks)
•Custom input masks
•Enhance forms by using VBA code builder