Free online courseMicrosoft Access by GCFLearnFree

4

(1)

1h25m of online video course

Quality content and selected for your learning.

Certificate

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.

Teacher

GCFLearnFree
3 Courses / 2259 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

There are no comments yet for this course.

Watch the 1st video of the course

Sign in or Register to access the online course.

Do not worry, it is free!

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!

0h03m

Access: Multi-Table Queries (Part 2)

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!

0h02m

Access: Modifying Queries

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

This video includes information on:
• Modifying and sorting queries
• Hiding fields within queries

We hope you enjoy!

0h02m

Access: Creating a Totals Query

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

This video includes information on:
• Creating a totals query
• Other query-building resources

We hope you enjoy!

0h02m

Access: Creating Reports

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

This video includes information on:
• Creating reports
• Deleting fields
• Deleting fields in a report

We hope you enjoy!

0h02m

Access: Printing Reports

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

This video includes information on:
• Printing reports
• Saving reports in Print Preview
• Exporting reports

We hope you enjoy!

0h03m

Access: Using the Report Wizard

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

This video includes information on:
• Selecting fields to include in a report
• Organizing a report
• Sorting report data
• Selecting the layout and title for a report

We hope you enjoy!

0h04m

Access: Formatting Reports

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

This video includes information on:
• Modifying the page header and footer
• Adding a logo
• Using themes and fonts
• Changing themes and fonts

We hope you enjoy!

0h04m

Access: Modifying Tables

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

This video includes information on:
• Moving fields
• Changing the data type for existing fields
• Setting character limits for a field
• Creating validation rules

We hope you enjoy!

0h04m

Access: Creating Forms

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

This video includes information on:
• Adding additional fields to a form
• Adding design controls
• Creating a combo box
• Using subforms

We hope you enjoy!

0h03m

Access: Customizing Form Settings

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

This video includes information on:
• Modifying form settings
• Hiding fields
• Setting a field to autofill with the current date
• Using the Property Sheet

We hope you enjoy!