• Enroll Today! 1-250-861-5808
  • Email: info@focuscollege.com

Microsoft Access – Focus College (Continuous Intake) | Focus College

Microsoft Access


The Microsoft Access course introduces students to Microsoft Access. Students will learn how to create simple databases, create and modify database objects including tables, forms, reports and queries.

Students will learn to:

  • identify parts of the Access screen
  • define fields, data types and tables
  • create a database using templates, create a blank database, open, save and close databases
  • create a table using Data sheet View or Design View
  • insert, delete and modify data in a table
  • add, modify and remove primary key fields
  • insert, modify and delete a field
  • add a total row to a table
  • format, rename and delete tables
  • save database items in a variety of file formats
  • import or export data from or to other applications
  • find and replace data using exact or partial matches, case sensitive and wildcard searches
  • sort and filter data
  • create, save, close, or run a query using the wizard or in Design View
  • create query criteria using comparison, wildcard, AND, OR operators, or calculated fields
  • change queries field properties and apply aliases
  • Students must purchase Microsoft Access
  • Students must be 18 years of age or older
  • Students must have taken Introduction to Windows
  • Must demonstrate to Instructor that concepts are understood
  • Must obtain 70% or higher on reviews and quizzes

This course is based on continuous intake and students are able to start as soon as they are ready.

For more information please call 250-861-5808 or email info@focuscollege.com

Download the College Catalogue

Looking for more information on all of our courses? Complete this form you will receive the catalogue instantly to your email.