Summary
Microsoft Office Access 2019/2021: Part 1
Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Office Access® can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.
Microsoft® Office Access® 2019/2021: Part 1 (this course): focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
Microsoft® Office Access® 2019/2021: Part 2: Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports.
Microsoft® Office Access® 2019/2021: Part 3: Focuses on managing the database and supporting complex database designs , including import and export of data, using action queries to manage data, creating complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database.
This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 363 and Office 2019): Exam MO-500 certification.
Completion of this course will earn 7.5 CPEs.
Introduction
In this course, you will create and manage an Access 2019 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.
Target Student:
This course is designed for students looking to establish a foundational understanding of Microsoft Office Access 2019/2021, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
Outline
-
Lesson 1: Getting Started with Access 2019
- 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
-
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: Perform Calculations 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
-
Appendix A: Mapping Course Content to Access Expert (Office 365 and Office 2019): Exam MO-500
-
Appendix B: Microsoft® Office Access® 2019 Common Keyboard Shortcuts