Loading...

Course Description

This course covers the basic functions and features of Access 2016 (365). After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports.

Course Outline

Getting Started with Access

  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help and Configure Options in Microsoft Access

Working with Table Data

  • Modify Table Data
  • Sort and Filter Records

Querying a Database

  • Create Basic Queries
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query

Using Forms

  • Create Basic Access Forms
  • Work with Data on Access Forms

Generating Reports

  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
  • Organize Report Information
  • Format Reports

Notes

For more Computer Applications courses click here.
Loading...

Enroll Now - Select a section to enroll in

Section Title
Microsoft Access 2016 (365) Level I
Type
Lab
Days
M, T
Time
8:30AM to 2:30PM
Dates
Apr 20, 2020 to Apr 21, 2020
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Notes
For the Discount, In-House Customized Training and Cancellation Policy related to this course click here.
Section Title
Microsoft Access 2016 (365) Level I
Type
Lab
Days
M, T
Time
8:30AM to 2:30PM
Dates
Sep 14, 2020 to Sep 15, 2020
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Notes
For the Discount, In-House Customized Training and Cancellation Policy related to this course click here.
Section Title
Microsoft Access 2016 (365) Level I
Type
Lab
Days
M, T
Time
8:30AM to 2:30PM
Dates
Jan 18, 2021 to Jan 19, 2021
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Notes
For the Discount, In-House Customized Training and Cancellation Policy related to this course click here.
Section Title
Microsoft Access 2016 (365) Level I
Type
Lab
Days
M, T
Time
8:30AM to 2:30PM
Dates
Apr 19, 2021 to Apr 20, 2021
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Notes
For the Discount, In-House Customized Training and Cancellation Policy related to this course click here.
Required fields are indicated by .