Microsoft Access 2021

(MSACCESS.AD1) / ISBN : 978-1-64459-390-5
This course includes
Interactive Lessons
Gamified TestPrep
Hands-On Labs
Instructor Led (Add-on)
AI Tutor (Add-on)
Get A Free Trial

About This Course

Skills You’ll Get

Get the support you need. Enroll in our Instructor-Led Course.

1

About This Course

  • Course Description
2

Getting Started with Access 2021

  • 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 Microsoft Access 
3

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
4

Creating Queries

  • Topic A: Create Basic Queries
  • Topic B: Perform Calculations in a Query
  • Topic C: Sort and Filter Data in a Query
5

Creating Forms

  • Topic A: Start a New Form
  • Topic B: Enhance a Form
6

Creating Reports

  • Topic A: Start a New Report
  • Topic B: Enhance Report Layout
A

Appendix A: Microsoft® Office Access® 2019 Common Keyboard Shortcuts

1

Getting Started with Access 2021

  • Revising and Entering Table Data
  • Preventing AutoCorrect Corrections
  • Using the Find and Replace Feature
  • Adding a Total Row to a Datasheet
  • Sorting and Filtering Records
  • Using Queries
  • Using Reports
2

Creating Tables

  • Creating a New Database
  • Creating a New Table
  • Preparing Keys for Table Relationships
  • Establishing Table Relationships
3

Creating Queries

  • Creating a Query Using the Query Wizard
  • Creating a Query Using Query Design
  • Performing Calculations in a Query
  • Sorting a Query and Reordering Fields
  • Filtering a Query Using a Comparison Operator
  • Filtering a Query Using Dates
  • Prompting a User for Query Parameters
4

Creating Forms

  • Creating a Form by Using the Form Wizard
  • Creating and Testing a Form Based on a Selected Table
  • Filtering and Sorting Data in a Form
  • Configuring a Form Lookup Field
5

Creating Reports

  • Creating a Simple Report
  • Using the Report Wizard
  • Enhancing a Report Layout

Microsoft Access 2021

$ 359.51

Buy Now

Related Courses

All Course
scroll to top