LOGIN
No products in the basket.

Access 365 Beginner

Stop wasting valuable time and maximise your productivity in the workplace, with this complete Procrastination Solution training course. It’s all …

(0 Rating)

Students Enrolled

GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49 PER YEAR. FIND OUT MORE

Course Description

Learning Objectives

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

Pre-Requisites

Basic computer skills. Knowledge of basic database concepts is helpful but not required.

Description

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.

8 Sections 51 lectures 4 hours 33 mins in total

Module 1: Getting Started with Access

7 lectures • 41 m: 0 s

What is a Database

00:03:00
Database Terminology

00:05:00
The Access Interface

00:08:00
What is a Flat File Database

00:03:00
What is a Relational Database

00:10:00
Relating Tables

00:10:00
Reviewing The Access Ribbon

00:02:00

Module 2: Working with Data

5 lectures • 23 m: 0 s

Working with Tables

00:07:00
Navigating Tables

00:04:00
Editing Data

00:03:00
Adding New Records

00:05:00
Using Subdatasheets

00:04:00

Module 3: Creating Databases and Objects

10 lectures • 57 m: 0 s

Understanding Database and Table Design Principles

00:08:00
Using Table Data Sheet View

00:03:00
Working with Field Data Types

00:07:00
Using Table Design View

00:04:00
Calculating Numbers

00:05:00
Calculating Dates

00:02:00
Calculating Strings

00:03:00
Using The Lookup Wizard

00:12:00
Lookup Wizard Linking Tables

00:09:00
Using Indexes

00:04:00

Module 4: Working with Queries

9 lectures • 45 m: 0 s

What are Queries?

00:08:00
Creating Simple Queries

00:05:00
Entering Criteria-Exact Match and Range Operators

00:05:00
Understanding And Versus Or

00:06:00
Using Wildcards

00:05:00
Using Key Words

00:04:00
Sorting and Hiding Fields

00:03:00
Creating Multi-Table Queries

00:03:00
Additional Tips C4

00:06:00

Module 5: Working with Reports

9 lectures • 59 m: 0 s

What are Reports

00:05:00
Understanding Report Types

00:03:00
Building Good Reports

00:02:00
Using AutoReport

00:08:00
Understanding The Report Wizard

00:11:00
Using the Report Design View

00:08:00
Printing Reports

00:04:00
Creating labels

00:08:00
Additional Tips C5

00:10:00

Module 6: Working with Forms

10 lectures • 48 m: 0 s

What are Forms

00:04:00
Understanding Form Types

00:03:00
Creating Forms

00:03:00
Navigating Forms

00:03:00
Editing Data in Forms

00:05:00
Understanding the Form Wizard

00:05:00
Using Form Design View

00:04:00
Working with Controls

00:10:00
Using Form Layout View

00:04:00
Additional Tips C6

00:07:00

Resource

1 lecture • 0 m: 0 s

Resource – Access 365 Beginner

Final Exam

0 lectures • 0 m: 0 s

Final Exam – Access 365 Beginner

Course Reviews

N.A

0 ratings

5 stars0
4 stars0
3 stars0
2 stars0
1 stars0

No Reviews found for this course.

After successfully completing the course, you will be able to get the and internationally accepted certificate to share your achievement with potential employers or include it in your CV.