From the course: Access 2019: Tips, Tricks, and Techniques
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Leverage split forms
From the course: Access 2019: Tips, Tricks, and Techniques
Leverage split forms
- [Instructor] Many of your end users will prefer to interact with a tabular view of your data. They may 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 a split form 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 orders. Just like with any other form, we'll start the process by going to the Create tab and we'll click on Form Design. The first thing that we need to do is connect this form to its underlying data source. And we can do that by opening up the Property Sheet and going…
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.