Microsoft Access Intermediate

Module 1: Table Design

• Setting advanced field properties in tables
• Input masks
• Validation rules
• Default values
• Lookup fields
• Creating Calculated Fields on Tables
• Relating Tables and the different types of Relationships

Module 2: Creating Relationships between Tables

• Creating Relationships
• Different Relationship types
• Viewing subdatasheets
• Setting referential integrity
• Cascade options

Module 3: Select Queries

• Select queries explained
• Creating select queries
• Working with query views
• Adding and deleting fields
• Sorting records in the Design View
• Using query criteria
• Adding calculated fields

Module 4: Designing Advanced Queries

• Setting join types between tables and queries
• Setting top values in a query
• Creating Calculated fields
• Creating Summary queries
• Grouping queries
• Creating Parameter queries

Module 5: Action Queries

• Update Query
• Make Table Query
• Delete Query
• Append Query
• Union Query

Module 6: Working in Form Design View

• Manipulating controls in form design view
• Changing form and control properties
• Adding controls to a form
• List boxes, Check boxes and Option buttons etc.
• Using calculations on forms

Module 7: Working in Report Design View

• Manipulating controls in a report
• Changing report control properties
• Managing sorting and grouping in reports
• Adding calculations to a report
• Controlling pagination

Module 8: Using Sub forms and Sub reports

• Creating Sub forms
• Creating Sub reports