ESTIMATED AVERAGE TIME:

29hrs 06mins

​

PART 1 COURSE OUTLINED:

Microsoft Access is a database management program in the Microsoft Office suite of applications. These lessons cover the skills that students will need to make the most of Microsoft Access. 

Part 1 begins with the basics and progresses through several 12 modules which cover databases, tables and records, forms, reports, queries, and much more.

​

 FREE DOWNLOAD LESSON 1 

​

Lesson 1: Getting Started with Access

Average time 4hrs

In the first lesson, you will learn how to orient yourselves with Microsoft Access 2016, create a simple Access database, and get help in Microsoft Access.

Lesson 2: Working with Table Data

Average time 3hrs: 28mins

Next, you will learn how to modify table data, work with, sort and filter records, and how to create lookups.

Lesson 3: Querying a Database

Average time 3hrs: 55mins

This lesson covers how to join data from different tables in a query, sort and filter data in a query, and perform calculations in a query.

Lesson 4: Creating Advanced Queries

Average time 1hr: 58mins

In this lesson, you will learn how to create parameter queries, action queries, unmatched queries, and duplicate queries. You will also learn how to summarize data with queries.

Lesson 5: Generating Reports

Average time 3hrs: 59mins

Creating reports, adding controls to a report, enhancing the appearance of a report, and preparing a report for print are all covered in this lesson.

Lesson 6: Customizing the Access Environment

Average time 12mins

Next, you will learn about the Access Options dialog box.
 

Lesson 7: Designing a Relational Database

Average time 7hrs: 12mins

This lesson covers relational database design, creating a table, managing table fields, and creating table relationships.

Lesson 8: Joining Tables

Average time 1hr: 55mins

Creating query joins, joining tables that have no common fields, relating data within a table, working with subdatasheets, and creating subqueries will be covered in this lesson.

Lesson 9: Organizing a Database for Efficiency

Average time 1hr:33mins

In this lesson, you will learn about data normalization and how to create a junction table.

Lesson 10: Sharing Data Across Applications

Average time 1hr: 53mins

Next, importing data into Access, exporting Access data to text file formats, exporting Access data to Excel, and creating a mail merge will be covered.

Lesson 11: Advanced Reporting

Average time 2hrs: 40mins

This lesson covers how to organize report information, format reports, include charts in a report, add a calculated field to a report, and add a subreport to an existing report.

Lesson 12: Additional Reporting Options

Average time 54mins

In the final lesson, how to create a mailing label report and how to publish a report as a PDF will be covered