ICT 420 - Microsoft Access Level 1

Course Description

Microsoft Access Level 1 has been designed to re-enforce workforce skills. Students learn to create and manage a database, and build tables and forms. Students will work on real-world problems like the ones they will encounter in the workforce ensuring they are ready for real professional challenges.

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 completion of this course, you will be able to:

• Understand database essentials
• Create and modify database table
• Print and export a database
• Work with tables and database records
• Import and link tables
• Identify primary and foreign keys
• Establish and configure table relationships
• Set and configure advanced field properties to control data entry
• Create basic queries
• Create and modify forms
• Display and organize form data

Topics of Instruction

• Database Essentials
• Create and Modify Database Table
• Print and export a database
• Work with Tables and Database Records

• Import and link tables
• Identify primary and foreign keys
• Establish and configure table relationships
• Set and configure advanced field properties to control data entry

• Create and modify Forms
• Display and organize form data

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