From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Manage table records
From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Manage table records
- [Instructor] Now that we know how to manage our tables, let's look at some ways that we can easily manage the records in our table. After viewing this video, you'll know how to find and replace data in a table, how to sort records, and how to filter records. Let's jump into our Manage Records: Database and work with our Employee Data table. This information shows us employees, the department they work in, what they currently have for benefits and what that benefit cost is. For our next fiscal year, the benefit cost is increasing to $250 for the dental medical. So what I'm going to do is ask Access to go through the Benefit Costs field, find every instance of $220 and replace it with $250. Now, there's two ways to get into Find & Replace. We can use the keyboard shortcut, Control + F for Find or on our Table Tools Field Ribbon, I can click on Find. In the Find What field, I'll type in $220. Click on the…
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.