ICT 421 - Microsoft Access Level 2

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