Access 365 - Beginner

Duration
4 Hours, 40 Minutes

Delivery Method
Self-Paced

This class is part of a 12‑month Educate 360 Pro Subscription

$395

Request More Information

Course Overview

This course is an introduction to Microsoft Access 365. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 365 Intermediate course.

Course Objectives

Getting Started with Access, Working with Data, Creating Databases and Objects, Working with Queries, Working with Reports, Working with Forms

Course Prerequisites

The recommended pre-requisite for this course is basic computer skills. Knowledge of basic database concepts is helpful but not required.

Agenda

1 - Introduction

Introduction

2 - Getting Started with Access

What is a Database?
Database Terminology
The Access Interface
What is a Flat File Database?
What is a Relational Database?
Relating Tables
Reviewing the Access Ribbon

3 - Working with Data

Working with Tables
Navigating Tables
Editing Data
Adding New Records
Using Subdatasheets

4 - Creating Databases and Objects

Understanding Database and Table Design Principles
Using Table Data Sheet View
Working with Field Data Types
Using Table Design View
Using Calculated Fields
Calculating Numbers
Calculating Dates
Calculating Strings
Using the Lookup Wizard
Lookup Wizard Linking Tables
Using Indexes

5 - Working with Queries

What are Queries?
Creating Simple Queries
Understanding the Dynaset
Criteria-Exact Match and Range Operators
Understanding AND Versus OR
Using Wild Cards
Using Key Words
Sorting and Hiding Fields
Creating Multi-Table Queries
Additional Tips

6 - Working with Reports

What are Reports?
Understanding Report Types
Building Good Reports
Using AutoReport
Understanding the Report Wizard
Using the Report Design View
Printing Reports
Creating Labels
Additional Tips

7 - Working with Forms

What are Forms?
Understanding Form Types
Creating Forms
Navigating Forms
Editing Data in Forms
Understanding the Form Wizard
Using Form Design View
Working with Controls
Using Form Layout View
Additional Tips

8 - Conclusion

Course Recap

What is Educate 360 Pro?

Educate 360 Pro is a 12-month subscription that provides unlimited access to full-day or short-duration live classes, on-demand video courses, class recordings, and quick reference cards. New Horizons offers more learning solutions for Microsoft Office than any other training provider and they are all included in your Educate 360 Pro subscription.

Unlimited enrollments into over 90 full-day and short-duration live training classes
Over 750 hours of on-demand video based content
A full library of digital quick reference cards for your favorite Office applications
Access to class recordings so you never have to worry about missing a scheduled class

Benefits of an Educate 360 Pro Subscription

Our Educate 360 Pro subscription is built to fit in and around your schedule. It will change the way you think about training.

Ask questions and get immediate answers during our full-day and short-duration live classes
Learn how to perform specific tasks instead of wasting time learning things you already know
Collaborate with fellow students and gain insight into new ways to solve problems
View on-demand courses with instructors that never leave your screen
Utilize course assessments to validate new skills
Take full day training classes on your schedule by accessing our class recordings
Revisit a prior class to further enhance your skills

Need more information? Click here to learn more about Educate 360 Pro.