Microsoft Access for Office 365: Part 1

Description

In this course, you will create and manage an Access database.

 

You will:

  • Navigate within the Access application environment, create a simple database, and customize Access configuration options.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

Lesson 1: Working with an Access Database

Topic A: Launch Access and Open a Database

Topic B: Use Tables to Store Data

Topic C: Use Queries to Combine, Find, Filter, and Sort Data

Topic D: Use Forms to View, Add, and Update Data

Topic E: Use Reports to Present Data

Topic F: Get Help and Configure Options in Access

 

Lesson 2: Creating Tables

Topic A: Plan an Access Database

Topic B: Start a New Access Database

Topic C: Create a New Table

Topic D: Establish Table Relationships

 

Lesson 3: Creating Queries

Topic A: Create Basic Queries

Topic B: Add Calculated Columns in a Query

Topic C: Sort and Filter Data in a Query

 

Lesson 4: Creating Forms

Topic A: Start a New Form

Topic B: Enhance a Form

 

Lesson 5: Creating Reports

Topic A: Start a New Report

Topic B: Enhance Report Layout

Similar courses

This is a mixed version class, appropriate for anyone using Excel 2016/2019/2021/2023, as well as Office 365 subscribers with automatic updates from Microsoft. Attention will be given to nuances between the program versions as applicable for the students in each class. For those using 2013 and earlier, please contact your Learning Consultant before enrolling in class.

More Information

This is a mixed version class, appropriate for anyone using Excel 2016/2019/2021/2023, as well as Office 365 subscribers with automatic updates from Microsoft. Attention will be given to nuances between the program versions as applicable for the students in each class. For those using 2013 and earlier, please contact your Learning Consultant before enrolling in class.

More Information

This is a mixed version class, appropriate for anyone using Excel 2016/2019/2021/2023, as well as Office 365 subscribers with automatic updates from Microsoft. Attention will be given to nuances between the program versions as applicable for the students in each class. For those using 2013 and earlier, please contact your Learning Consultant before enrolling in class.

More Information

This is a mixed version class, appropriate for anyone using Excel 2016/2019/2021/2023, as well as Office 365 subscribers with automatic updates from Microsoft. Attention will be given to nuances between the program versions as applicable for the students in each class. For those using 2013 and earlier, please contact your Learning Consultant before enrolling in class.

More Information