Search
To account for the video time in the certificate, wait for the video to shut down automatically. The next video of the course will be triggered next.
Quality content and selected for your learning.
Download your digital certificate of course completion after watching all course videos.
Many of the courses available have exercises to help with learning.
This course is free today and always will be, from start to finish you will pay nothing.
Teacher
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.
0h03m
0h04m
0h04m
0h02m
0h04m
0h02m
0h04m
0h04m
0h05m
0h05m
0h03m
0h02m
0h02m
0h02m
0h02m
0h03m
0h04m
0h04m
0h04m
0h03m
Watch the 1st video of the course
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!
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!
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!
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!
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!
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!
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!
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!
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!
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!
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!
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!
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!
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!
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!
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!
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!
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!
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!
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!
Course comments