Microsoft Access for HR & Admin Professionals
O365/2021/2019/2016
Microsoft Access is a widely-used desktop database application for business, commercial, and industrial purposes. As a relational database, it organizes data into tables that can be interconnected. Additionally, it features a robust query tool, enabling users to retrieve information from the database for reporting and decision-making purposes.
The Access for HR & Admin Professional course is an introductory program tailored for HR and Admin personnel eager to discover how MS Access can significantly benefit a Human Resources department. The practical exercises are HR-centric, providing a solid foundation in desktop database creation. Participants will learn to construct a new Access database with employee data, establish Table Relationships, and develop Queries, Forms, and Reports. Additionally, the course enhances confidence in managing existing databases, given that databases form the core of all HRIS software. For a comprehensive understanding of the course content, please consult the detailed outline provided below.
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 (Los Angeles, Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (New York, Toronto)
Course Pace and Style: Medium-to-Fast; Instructor-led, Hands-on, Intensive, Interactive
Course Delivery Format: Live Online Instructor-led. We do not train by recorded videos.
Course Outline Download: Microsoft_Access_for_HR
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking Online Courses: OnLine Tech Requirements
This course is pre-approved for:
– 6.5 PCD by SHRM, USA for SHRM-CP® or SHRM-SCP® recertification activities.
– 6.5 CPD hours by CPHR-BC & Yukon.
– 6.5 CPD hours by CPHR-Manitoba.
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 HR Database
- Database Design Basics
- Creating a New Database
Lesson 3: Creating a Data Table
- Designing a Table
- Creating an Employee Info Table
- Creating Tables for Departments, Employment Type, Job Titles, Courses, Employee Training
- 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
Lesson 5: Setting up Table Relationship
- Understanding Table Relationship
- Creating Relationship between Tables
- Viewing Subdatasheets
- Enforcing Referential Integrity
- Printing Table Relationships
Lesson 6: Working with Queries
- Learning the Concepts of a Query
- Creating Queries with Logical Operators
- Creating Queries with a Wildcard
- Creating a Calculated Field Query
- Using Summary Operators
- Querying Multiple Tables
Lesson 7: Some Sample Queries
- Calculating Length of Service
- Monthly-Annual Hiring Pattern
- Tracking Employee Training
- Tracking Training Dollars
- Departmental Summaries
- Performing Numerical Calculations
Lesson 8: Creating a Form
- Form Overview
- Creating A Form for Data Entry
- Customizing the Form
- Making Changes in the Design and Layout Views
- Adding a Logo to a Form
- Testing the Form
Lesson 9: Creating a Report
- Report Overview
- Creating a Report for Printing
- Customizing the Reports
- Making Changes in the Design and Layout Views
- Adding a Logo to a Report