Intermediate Microsoft Access

This course not only reviews and builds on the introductory course, but goes into further detail about the workings of relational databases and joining tables. It is designed to help anyone working with Access databases who needs to know about multiple query. Course Outline: Unit 1: Using Advanced Query Features Joining Tables in Queries Creating Calculated Fields Using Action Queries Unit 2: Creating Advanced Queries Summarising and Grouping Values Creating Crosstab Queries Using Parameter Queries Using Indexes Unit 3: Enhancing Forms Adding Graphics to a Form Adding Calculations to a Form Adding Combo Boxes to a Form Adding Unbound Controls Unit 4: Working with fields and records Creating Customised Headers and Footers Combining Values from Multiple Fields Adding Calculated Values Working with Subreports Unit 5: Creating Charts Creating Charts in Forms Creating Charts in Reports Unit 6: Advanced Forms Building a form based on joined tables Automatic data entry Using grouped controls Enhancing the user interface Subforms Advanced Microsoft Access