From the course: Access 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Searching and replacing values
From the course: Access 2019 Essential Training
Searching and replacing 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 the 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 in Data Sheet View, and I want to locate specific records quickly and easily using the search box at the very bottom of the screen. I'm gonna type in Dixon, and it's gonna go through and find all the instances of the word Dixon in the database. If I want to find others, just press the enter button and it'll skim through the database and find every occurrence. An alternate option is to go up to the ribbon and press the find icon, the one with the big magnifying glass or use the Control+F shortcut. Once again, we have the Find tab here, and we can type in the text that we want to search for inside of our data table. We have some additional options going this route. We can choose to look in…
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.