Microsoft Access Intermediate

Duration 1 Day

Who should attend?

This course is valuable for anyone who plans to prototype, build and integrate relational database applications using Access.

Learning Outcomes

  • Understand Relational Database design
  • Create a relational database
  • Assign Primary keys and indexes
  • Create multi-table forms
  • Create multi-table select queries
  • Create advanced queries – Append, Update and Delete

Course Content

  • Designing multi table databases
  • Assigning Primary Keys
  • Assigning an Index
  • Linking tables through relationships view
  • Setting Referential integrity
  • Creating Main / Sub Forms
  • Creating linked forms
  • Creating multi-table queries
  • Creating inner and outer joins in queries
  • Calculations in queries
  • Group & Total queries
  • Parameter Queries
  • Creating Append queries
  • Creating Update queries
  • Creating Delete queries