Free online courseMicrosoft Access by GCFLearnFree

4.5

(4)

1h25m of online video course

Quality content and selected for your learning.

Certificate of course completion

Download your digital certificate of course completion after watching all course videos.

Exercises to train your knowledge

Many of the courses available have exercises to help with learning.

Free lifetime access

This course is free today and always will be, from start to finish you will pay nothing.

Online course in English

Office productivity

Office suite courses are here, have several classes on Excel, Microsoft Word, PowerPoint and MS Access that are free for you to grow in the market

Teacher

GCFLearnFree
3 Courses / 2647 students

For more than a decade, the GCFLearnFree.org program has helped millions around the world learn the essential skills they need to live and work in the 21st century. From Microsoft Office and email to reading, math, and more, GCFLearnFree.org offers tutorials in more than 190 topics, including more than 2.300 lessons as well as videos and interactives, completely free.

Course comments

Discussion Forum

There are no comments yet for this course.

Watch the 1st video of the course

Share

Evaluate course

Go to certificates

Report a problem

Course content

0h03m

Access: Introduction to Databases

In this video, you’ll get an introduction to Access databases and how they work. Visit https://edu.gcfglobal.org/en/access/introduction-to-databases/1/ for our text-based lesson.

This video includes information on:
• Why you'd use a database

We hope you enjoy!

0h04m

Access: Introduction to Objects

In this video, you’ll learn the basics of working with objects in Microsoft Access. Visit https://edu.gcfglobal.org/en/access/introduction-to-objects/1/ for our text-based lesson.

This video includes information on:
• Forms
• Queries
• Reports
• Putting it all together

We hope you enjoy!

0h04m

Access: Getting Started

In this video, you’ll learn the basics of getting started in Access 2019, Access 2016, and Office 365. Visit https://edu.gcfglobal.org/en/access/getting-started-in-access/1/ for our text-based lesson.

This video includes information on:
• Getting to know Access 2016
• Using the Ribbon and Tell Me features
• Using the Quick Access Toolbar
• Using Backstage view and the Navigation pan

We hope you enjoy!

0h02m

Access: Working with Databases

In this video, you’ll learn the basics of managing databases and objects in Access 2019, Access 2016, and Office 365. Visit https://edu.gcfglobal.org/en/access/managing-databases-and-objects/1/ for our text-based lesson.

This video includes information on:
• Closing a database
• Opening, saving, closing, and renaming objects

We hope you enjoy!

0h04m

Access: Working with Tables

In this video, you’ll learn the basics of working with tables in Access 2019, Access 2016, and Office 365. Visit https://edu.gcfglobal.org/en/access/working-with-tables/1/ for our text-based lesson.

This video includes information on:
• Opening an existing table
• Adding records and entering data
• Editing records
• Modifying table appearance

We hope you enjoy!

0h02m

Access: Customizing Tables

In this video, you’ll learn the basics of customizing tables in Access 2019, Access 2016, and Office 365. Visit https://edu.gcfglobal.org/en/access/working-with-tables/1/ for our text-based lesson.

This video includes information on:
• Resizing fields and rows
• Changing alternate row color
• Customizing which gridlines appear
• Hiding fields

We hope you enjoy!

0h04m

Access: Working with Forms

In this video, you’ll learn the basics of working with forms in Access 2019, Access 2016, and Office 365. Visit https://edu.gcfglobal.org/en/access/working-with-forms/1/ for our text-based lesson.

This video includes information on:
• Opening an existing form
• Entering and modifying data
• Adding new records and finding existing records
• Saving and deleting records

We hope you enjoy!

0h04m

Access: Sorting and Filtering Records

In this video, you’ll learn the basics of sorting and filtering records in Access 2019, Access 2016, and Office 365. Visit https://edu.gcfglobal.org/en/access/sorting-and-filtering-records/1/ for our text-based lesson.

This video includes information on:
• Creating filters from a selection
• Creating filters from a search term
• Sorting and filtering records

We hope you enjoy!

0h05m

Access: Designing a Simple Query

In this video, you’ll learn the basics of designing a simple query in Access 2019, Access 2016, and Office 365. Visit https://edu.gcfglobal.org/en/access/designing-a-simple-query/1/ for our text-based lesson.

This video includes information on:
• How queries are used
• Creating a simple one-table query

We hope you enjoy!

0h05m

Access: Multi-table Queries (Part 1)

In this video, you’ll learn the basics of using multi-table queries in Access 2019, Access 2016, and Office 365. Visit https://edu.gcfglobal.org/en/access/designing-a-multitable-query/1/ for our text-based lesson.

This video includes information on:
• Planning a query
• Identifying the question to ask and the information needed
• Locating the tables containing the necessary information
• Determining criteria the query should search for
• Joining tables in queries
• Creating multi-table queries

We hope you enjoy!