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