From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Manage records in tables
From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)
Manage records in tables
- [Tutor] Now that you are familiar with how to manage your tables, let's talk about how to manage the records in a table. In this video, I'll demonstrate how to use find and replace which I know is a very basic concept of all of the Microsoft Office Suite programs. But it is something that you may encounter on the MOS exam so I want to go ahead and just revisit it quickly. We'll also talk about how to sort records, filter records, and find records. I'm going to show you a really quick way to find a specific record in your database table. Let's take a look at our 03_02 Manage_Records database and we're going to focus on the 2016 sales table. We received an email from our sales department telling us that we have misspelled Asa Byrd's last name. Let's see if we can find Asa Byrd who is a salesperson in one of the records in our table. I'm going to go down to the navigation bar and click in the search field. I'm going to type in Asa and notice how Access took us directly to the first…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.