Learn your way! Get started

Microsoft Access 365, Part 1 of 5: Get Started with Access

with expert Kari Hoien

Watch trailer

Course at a glance

	Release date	8/1/2022
	Level	Beginner
	Runtime	1h 34m
	Closed captioning	Included
	Transcript	Included
	eBooks / courseware	N/A
	Hands-on labs	N/A
	Sample code	N/A
	Exams	Included

Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

Microsoft Access is a database management system (DBMS) used to store and manage data allowing a user to create forms, query information and create reports. This course will get you started with Access, getting comfortable with the interface, the Access object overview and how to create a database.

Prerequisites

Knowledge of data types, database structure and use of other Microsoft tools and interface ribbons is very useful, but not required.

Meet the expert

I’m Kari Hoien. I have a Bachelors degree in Business and Accounting from Concordia College in Moorhead, I was a CPA and went on to get my Masters in Education Technology from Pepperdine in Malibu, California. I have been working as a trainer and consultant for Microsoft Office products for more than 20 years and I’ve helped clients in almost every industry in a wide range of different capacities and applications. I have taught thousands of people how to use Microsoft Office apps (Excel, Access, Outlook, PowerPoint etc). I have done stand-up classroom style training, virtual training, on-demand training, self-paced training, executive training, one-on-one training – you name it – I've probably done it. I LOVE teaching people how to use these everyday programs better, ways to save time so you can work SMARTER and have more time for the things that you love. Thanks so much for allowing me to help you learn.

Course outline

Module 1

Getting Started (32:20)

Introduction (00:37)
Get Started (00:39)
Overview of the Database (07:26)
Access Navigation (00:20)
Toolbars and Ribbons (15:19)
Access Options (07:27)
Summary (00:28)

Access Object Overview (50:14)

Introduction (00:17)
Access Object Overview (14:05)
Query Design View (06:03)
Select Queries (00:28)
Union Query (00:22)
Forms (02:52)
Form Contextual Tabs (00:56)
Switch Form View (01:05)
Property sheet (04:30)
Reports (03:42)
Layout View (06:19)
Macros (02:32)
Modules Overview (06:33)
Summary (00:23)

Create a Database (11:41)

Introduction (00:18)
Creating a Database (00:57)
Database Creation Demo (10:09)
Summary (00:15)