From the course: Access Essential Training (Office 365/Microsoft)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Search and replace values
From the course: Access Essential Training (Office 365/Microsoft)
Search and replace values
- [Instructor] No text editing environment would be complete without an easy way to search through the text and make replacements. Access is no exception and we can use these same find and replace tools, that you may be familiar with from other Office programs. Let's go ahead and open up the guest table and we can look at any specific records quickly and easily using the search box down at the very bottom of the screen. So we type in what you're looking for and Access will immediately jump to the first occurrence of that word. For instance, I'll type in Dixon, and we'll see that Access automatically highlights Patricia Dixon's record here. If I wanna find the next occurrence of Dixon, I'll simply press the enter key on my keyboard and we can see that we have Dixon over here in her email address. Press enter again and it jumps down to Todd Dixon on line 21. Another option is to go up here to the ribbon and on the home tablet of the ribbon, over the find section, we have the find button…
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.