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

Leverage split forms

From the course: Access 2016: Advanced Tips and Tricks

Start my 1-month free trial

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…

Contents