From the course: Access 2019: Queries
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Obtain parameters from forms
- [Narrator] I want to start this video by passing on a fundamental concept that might change the way that you think about access. Every object, every form, every button, every checkbox or label or textbox, everything, has a name and a value associated with it inside of Access. And every name or value can be used as an input somewhere else in your database. Really understanding this concept will set you on the path of becoming a true Access master, and here's why: Access objects, that's the tables, forms, queries, reports, etc, they're all presented by the interface as individual components of your database. But in reality, it's the interaction and the interconnections between objects that allow your databases to do some pretty amazing things. In a previous video, we looked at how we can provide our end users with a pop-up dialogue box to define some query parameters. Let's take that a step further and see how we can define those same parameters using form controls instead. Now for…
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.