Microsoft Access Beginner
O365/2021/2019/2016
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 Microsoft Access Beginner 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 option is available for group training only)
Course Outline Download: Access_Beginner_Level
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