Loading...

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

Instructional Delivery

  • Face-to-face in a lab

Registration

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

Top of Page


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

Top of Page


Notes

Required Tools

  • Online and in class students need access to Microsoft Access 2016 outside of lab/class time to work on assignments, projects, or other course work. This software may be downloaded from Microsoft.

Textbooks

Attendance

It is strongly recommended that students attend every class. It is the responsibility of the student to communicate potential absenteeism to the instructor.

Top of Page


 

Prerequisites

  • This course does not have prerequisites, students must however meet the recommendations and requirements in the Notes section along with any proficiencies identified below.

Top of Page


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

Top of Page


 

Applies Towards the Following Certificate(s)

Loading...

Enrol Now - Select a section to enrol in

Type
Class
Days
F
Time
8:30AM to 4:30PM
Dates
Jan 24, 2020 to Jan 31, 2020
Schedule and Location
Hours
14.0
Delivery Options
Course Fees
Flat Fee non-credit $575.00
Reading List / Textbook

Title: Microsoft Access 2016 Certification Guide
Edition: 2016
Publisher: CCI Learning
ISBN: 978-1-55332-479-9

For print copy:  Visit the UCalgary Bookstore at www.calgarybookstore.ca.

For e-book: Visit CCI Learning 

Section Notes

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Required fields are indicated by .