Access 2019 Essentials
In this course, you’ll learn the basics of working with Access 2019. You'll explore the Access user interface and begin the process of building working database solutions.
What you'll learn
Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis. In this course, Access 2019 Essentials, you will be will introduced to Access 2019, Microsoft’s application for creating working database solutions. First, you’ll begin with navigation lessons to help you find your way around the Access interface. Next, you will explore the basics of working with databases and tables. From there you’ll move into working with and sorting records, working with filters, forms, queries, and reporting. Finally, you'll explore and understand database objects. When you’re finished with this course, you will have the skills and knowledge of Access 2019 needed to begin development (and begin preparation for the Microsoft Office exams).
Table of contents
- Getting Started 2m
- Database Basics 2m
- Opening Microsoft Access 1m
- The Getting Started Window 1m
- Opening an Existing Database 1m
- Touring the Access Interface 1m
- Working with the Ribbon 2m
- Using the Quick Access Toolbar 3m
- Using the Help Features 2m
- Using Tell Me 1m
- Setting Navigation Options 2m
- Closing Microsoft Access 2m
- Opening an Existing Table 1m
- Exploring Tables 2m
- Navigating in Datasheet View 2m
- Entering Data in a Table 1m
- Finding a Record in a Table 1m
- Editing a Record 1m
- Finding and Replacing Values in Records 2m
- Using Spell Check 1m
- Selecting Records 1m
- Deleting Records from a Table 1m
- Printing Records 1m
- Sorting Your Records 1m
- Sorting Using Multiple Fields 1m
- Removing a Sort 0m
- What Are Filters? 2m
- Filtering Records by Selection 1m
- Filtering Records Using Multiple Values 1m
- Clearing a Filter 1m
- Using the Column Filter Menu 1m
- Toggling a Filter 1m
- Filtering Records Using Forms 1m
- What Are Forms? 1m
- Opening an Existing Form 1m
- Exploring Forms 1m
- Navigating in Forms View 2m
- Entering Data in a Form 1m
- Finding and Replacing Data in Form View 2m
- Sorting and Filtering Records in Forms 1m