Microsoft Access 2021
(MSACCESS.AD1) / ISBN : 978-1-64459-390-5
About This Course
Skills You’ll Get
Get the support you need. Enroll in our Instructor-Led Course.
Interactive Lessons
7+ Interactive Lessons | 35+ Exercises | 40+ Quizzes | 44+ Flashcards | 44+ Glossary of terms
Gamified TestPrep
10+ Pre Assessment Questions | 10+ Post Assessment Questions |
Hands-On Labs
25+ LiveLab | 45+ Video tutorials | 01:11+ Hours
About This Course
- Course Description
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
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
Creating Queries
- Topic A: Create Basic Queries
- Topic B: Perform Calculations in a Query
- Topic C: Sort and Filter Data in a Query
Creating Forms
- Topic A: Start a New Form
- Topic B: Enhance a Form
Creating Reports
- Topic A: Start a New Report
- Topic B: Enhance Report Layout
Appendix A: Microsoft® Office Access® 2019 Common Keyboard Shortcuts
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
Creating Tables
- Creating a New Database
- Creating a New Table
- Preparing Keys for Table Relationships
- Establishing Table Relationships
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
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
Creating Reports
- Creating a Simple Report
- Using the Report Wizard
- Enhancing a Report Layout