Microsoft Access Level-1 (Introductory)

CAD 360.00

Intensive, hands-on, one-day Microsoft Access Level-1 course delivered online by a Live Trainer and not recorded Videos. Please read prerequisites and other details in the description below.

We have distinct course dates for Pacific and Eastern Time zones. You can explore both options below.

Clear
SKU: N/A Category:

Microsoft Access 2013/2016/2019/O365
Level-1 (Introductory)

Microsoft Access is a desktop database application used all over the world in commercial and industrial applications where creation and maintenance of desktop databases are involved. It is a relational database and stores data tables that could be related. It also has a powerful query tool that allows the users to extract complex information from the database for reporting purposes.

Our Access Level-1 course is designed for office users or those planning to work in an office. It is a foundation course that teaches you the basics of creating a desktop database and other features like Query, Form and Reports. Please refer to the detailed course outline below to learn what is covered in the course.

Prerequisites: At least six months of experience working in Windows environment with mouse. Some keyboard skills also required. Some experience of working with Excel is desirable but not necessary.
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (Toronto)
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive
Course Delivery Format: OnLine and In-Person
(In-Person training is currently not available due to the COVID-19 pandemic)
Course Outline Download: Access_Level_1
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Course Outline
Lesson 1: Exploring the Access Interface

  • Database Basics
  • Running Microsoft Access
  • The Opening Screen
  • The Initial Access Screen
  • Working with Help

Lesson 2: Creating a New Database

  • Database Design Basics
  • Creating a Database

Lesson 3: Creating a Table

  • Designing a Table
  • Redesigning a Table
  • Renaming a Database Object

Lesson 4: Working with a Table

  • Viewing a Table
  • Editing a Table
  • Modifying a Table
  • Sorting Table Records
  • Filtering Table Records
  • Printing a Table
  • Print Previewing
  • Page Setup

Lesson 5: Setting up Table Relationship

  • Creating Relationship
  • Viewing Subdatasheets
  • Enforcing Referential Integrity
  • Printing Database Relationships

Lesson 6: Creating a Query

  • Querying Tables
  • Saving/Opening a Query
  • Using Wildcards in Queries
  • Compound Queries
  • Miscellaneous Operators
  • Creating Calculated Fields
  • Using Summary Operators
  • Querying Multiple Tables

Lesson 7: Creating a Form

  • Form Overview
  • Creating Forms
  • Customizing the Form
  • Saving/Opening a Form
  • Using the Form Filter

Lesson 8: Creating a Report

  • Creating Reports
  • Saving/Closing a Report

 

Class Start Time

9:00 AM Pacific Time, 9:00 AM Eastern Time

Course Date

03-Dec-2021, 10-Feb-2022, 07-Apr-2022, 02-Jun-2022, 28-Jul-2022, 22-Sep-2022, 17-Nov-2022, 31-Dec-2021, 24-Feb-2022, 21-Apr-2022, 16-Jun-2022, 11-Aug-2022, 06-Oct-2022, 01-Dec-2022