fbpx
Book a campus tour
Apply Now

Corporate Training

Microsoft Office Access

Microsoft Office Access – Level I

This course is designed for students with little or no database experience. Examine basic database concepts,create and modify databases, and perform basic queries. Learn to query a database and generate reports. Students have the opportunity to practice these skills.

  • Duration: 1 - day (8:30am – 4:00pm) Check calendar for availability.
  • Course Cost: $310.00 + applicable taxes

Objectives:

  • Identify the basic components of an Access database
  • Build the structure of a database
  • Manage data in tables
  • Query a database
  • Design forms
  • Generate reports
Check course availability
Download course outline

Microsoft Office Access – Level II

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.

  • Duration: 1 - day (8:30am – 4:00pm) Check calendar for availability.
  • Course Cost: $310.00 + applicable taxes

Objectives:

  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Share data among Access and other applications.
  • Customize reports to organize the displayed information and produce specific print layouts.
Check course availability
Download course outline

Microsoft Office Access – Level III

For advanced Access users. Customize form layout, learn to add user interface features, and use macros to improve the interface. Develop your database security features.

  • Duration: 1 - day (8:30am – 4:00pm) Check calendar for availability.
  • Course Cost: $310.00 + applicable taxes

Objectives:

  • Customize a form layout to improve usability and efficiency of data entry.
  • Add user interface features to validate data entry.
  • Use macros to improve user interface design.
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy.
  • Lock down and prepare a database for distribution to multiple users.
  • Create and modify a database switchboard and set the startup options.
Check course availability
Download course outline

Ready to Register?

If you are ready to register you may do so online by clicking the link the below, downloading the PDF application, or calling 306-244-6340.

Register Online
Download the Corporate Registration Form

Sign up for the sbc newsletter

If you are interested in our Full-Time programs please fill out the form below to join our Newsletter Mailing List.
Facebook Twitter Instagram Linkedin

Copyright © 2023 SBC College Ltd. All rights reserved. | www.sbccollege.ca
221 Third Avenue North Saskatoon, Saskatchewan, S7K 2H7 | 1-306-244-6333 or 1-800-679-7711 (only in Canada)

Powered by Higher Education Marketing