Microsoft Access Intermediate

Course Dates:

Business Benefit :-

With the amount of data being stored in databases these days, solid database design is more important now than it ever has been. By learning about relational databases and the additional benefits they give you, your database will always work in the most efficient way. This course provides underpinning knowledge towards the Microsoft Office Specialist Qualification.

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

IT Qualifications, IT Skills

Related Products