Loading...

Course Description

Microsoft Access Level 2 teaches students how to use advanced commands to work with forms, reports, designing tables, and manipulating queries.

Students will learn a variety of commands, functions, and database capabilities.

Course Details

Registration

Registrations within 24 hours of course start time must be made by phone (403-220-2866).

Course Content

Course Level Learning Outcomes

Upon successful completion of this course, you will be able to:

  • Create reports
  • Utilize calculated fields and grouping within a query
  • Build advanced select queries
  • Use controls in reports and forms
  • Advanced tables and queries
  • Set tab order in forms
  • Modify form controls
  • Move and delete form controls
  • Edit forms

Topics of Instruction

  • Create Reports
  • Utilize calculated fields and grouping within a query
  • Build advanced select queries
  • Use Controls in Reports and Forms
  • Advanced Tables and Queries
  • Set tab order in forms
  • Modify form controls
  • Move and delete form controls
  • Edit forms

Proficiencies

  • Students must be familiar with the personal computer, keyboard and mouse.
  • Students must have Microsoft Windows skills and knowledge, and be able to perform the following tasks:
    • start and run Windows
    • use the taskbar, Start button and Help feature
    • use Minimize, Maximize, Restore Down/Up and Close
    • use the left and right mouse buttons appropriately
    • understand file management techniques
    • navigate between files, folders, or drives

Applies Towards the Following Certificate(s)

Loading...

Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrolment. Please complete a course inquiry so that we may promptly notify you when enrolment opens.

Required fields are indicated by .