The database version of picture-in-picture, a subform—a form living inside another form—gives you powerful data insight and lets you see your related tables and records working together.
- [Instructor] Subforms are a great addition…to forms you use for data entry…or to simply look up records in your database.…They're helpful because they typically contain data…from a related table,…meaning you can see the contents of two tables at once…in a single form.…If you build your forms…after setting up your table relationships,…you'll get subforms automatically.…Here we see the Instructor form has a Classes subform…because the Instructors table is related…to the Classes table.…To add a subform when one has not appeared automatically,…open the form in Design View.…
I've opened the Classes form in Design View,…and using the subform button in the Controls group,…I draw a box, which invokes the Subform Wizard.…I choose to base the subform…on an existing Instructors Form.…And next I choose to build the subform…from a list of the fields in the selected form.…After naming the form, I can switch to Form View,…and I see that the classes…to whom an instructor has been assigned now include data…in the subform for that instructor.…
Author
Released
2/27/2019- Planning your database
- Building tables
- Setting field properties
- Creating relationships
- Creating forms for data entry
- Finding data with queries
- Updating records with queries
- Building better reports
Skill Level Intermediate
Duration
Views
Related Courses
-
Access 2019: Queries
with Adam Wilbert3h 56m Intermediate -
Access 2019: Forms and Reports
with Adam Wilbert4h 20m Intermediate -
Access 2019: Macros
with Adam Wilbert1h 9m Intermediate -
Access: VBA
with Curt Frye4h 37m Advanced
-
Introduction
-
1. Planning
-
Storyboarding1m 6s
-
-
2. Building a Table
-
3. Field Properties
-
Using input masks1m 19s
-
-
4. Relationships
-
Editing relationships1m 4s
-
5. Data Entry
-
Fast forms with subforms1m 12s
-
Create combo and list boxes1m 27s
-
Adjusting tab order in forms1m 15s
-
-
6. Queries
-
Finding missing data1m 7s
-
7. Reports
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Fast forms with subforms