From the course: Access 2019 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Find records
- [Instructor] On our check-in form, we have a situation where it's difficult to find a specific guest. Right now I can page forward and backward through our different records, but imagine trying to locate the correct page for someone that's looking to book a room. We can alleviate this by adding a search box to the top of our form right up here. This will allow us to find a record for a specific guest, based off of their last name. To do this, I'm gonna switch our view into Design view. I'll click on the bottom portion of the view button, and then switch to Design view there. First, I'm gonna make my form a little bit wider. So I'll come over here to the far right, and when I get this double-headed arrow, I'll just click and drag it open a little bit. Then, on the Design tab of our ribbon, I'm gonna grab a control called a combo box which is represented by this icon here. A combo box is essentially a dropdown menu and we've seen these several places throughout Access. I'll go ahead…
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.