iTrain Scotland IT Training Edinburgh image
 

Microsoft Access Level 2

iTrain Scotland IT Training Edinburgh image

Home > Courses > Microsoft courses > Microsoft Access Level 2

Microsoft Access Level 2

Suitable for versions 2016 / 2013 / 2010

This course will vastly increase your current understanding of Access. Existing users will learn how to get the most out of Access, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our expert Access trainers.

This course is aimed at those who have a good understanding of Access at a Foundation level.

Delegates should already be able to:

  • Design a simple database from scratch
  • Create and understand table relationships
  • Create filters and queries
  • Use expressions in the Query Designer

Delegates will learn advanced query design, automation, forms, switchboards and sharing. Delegates will also learn shortcuts and tips about how to use Access in the most efficient way.

 

Advanced Table Design
  • Field properties
  • Input masks
  • Captions
  • Validation rules
  • Field size
  • Formats
  • Lookups

Advanced Queries
  • Review of basic queries
  • Action Query
  • Parameter Query
  • Crosstab Query
  • Ad hoc Joins
  • Calculated Fields

Develop Relationship concepts
  • Referential Integrity
  • One-to-One
  • One-to-Many
  • Many-to-Many
  • Query Multiple Tables
  • Create Junction Tables

Customising Reports
  • Format Reports
  • Control Report Pagination
  • Summarise Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
Sharing Data Across Applications  
  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge
  • Linking tables

Splitting a Database
  • Creating front end / back end
  • Sharing across a network
  • Multiple users

Advanced Form
  • Sub Forms
  • Lookup Query in a form
  • Creating a welcome screen
  • Switchboards
  • Form navigation
  • Adding macros
  • Command buttons
  • Adding images
  • Using VBA code in buttons
  • Combo boxes
  • Calculated fields
  • Jump-to combo box
  • Event Procedures
  • Control Source

 

Group discount
1 place £ 205 n/a
2 places £ 410 n/a
3 places £ 615 £ 565
4 places £ 820 £ 665
5 places £ 1025 £ 765
6 places £ 1230 £ 865
7 places £ 1435 £ 965
8 places £ 1640 £ 1065