From the course: Access 2016: Advanced Tips and Tricks
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Leverage split forms
From the course: Access 2016: Advanced Tips and Tricks
Leverage split forms
- [Voiceover] Many of your end users would prefer to interact with a tabular view of your data. They may be be accustomed to working with spreadsheets, and find that type of view to be more efficient to navigate and edit. But you as the database developer, have an obligation to protect the data structures of the system and want to keep people out of the underlying tables as much as possible. When attempting to reconcile these opposing goals, you should consider creating split forms for your users to interact with. A split form gives you the best of both worlds. And they're often an overlooked component that can add value to your database's design. Let's create a split form to help our end users navigate the data about our customer's orders. We'll come up here to the create tab, and we'll start a new form in design view. Then, I'll open up the property sheet, and in the data tab, I'm gonna connect this record source to the orders table by using the drop-down menu here. Next, we'll open…
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.