Join David Rivers for an in-depth discussion in this video Using subdatasheets, part of Access 2007 Essential Training.
Now that you're feeling very comfortable with the term referential integrity and…table relationships, it's time to talk about something that will help you when…it comes to data input, and that's a sub datasheet.…As soon as we create relationships between tables like we have here in our…database, linking the Album ID in the Album table to the Album ID field in the…Songs table, and also linking the Performers table by Performer ID to the…Performer ID field in the Songs table, we now have a relationship.…We've enforced referential integrity so that the way we set it up if we were to…remove an Album, all of the songs with that related Album ID would be removed as well.…
If we were to change information in the Performer ID in the Performers table, we…would see those changes in the related table under Songs here, all the Performer…IDs would be updated.…So with all of that in mind, now we're going to look at a little feature, the…sub datasheet, which is going to help you when it comes to data input.…
Author
Released
10/10/2007Skill Level Beginner
Duration
Views
Related Courses
-
Access 2007: Shortcuts
with Alicia Katz Pollock3h 25m Intermediate -
Access 2007: Queries
with Adam Wilbert2h 8m Intermediate -
Excel 2010: Tips, Tricks, and Shortcuts
with Dennis Taylor3h 43m Intermediate
-
Introduction
-
Welcome47s
-
-
1. Getting Started with Access
-
Starting Access5m 14s
-
The Getting Started window4m 42s
-
The Quick Access toolbar3m 51s
-
The work environment9m 38s
-
2. Creating Databases and Tables
-
Working with fields5m 31s
-
Choosing keys3m 41s
-
Creating tables3m 10s
-
Creating fields6m 30s
-
Working with records5m 5s
-
Working with data7m 15s
-
Checking spelling5m 32s
-
3. Working with Fields and Records
-
Modifying table design6m 8s
-
Finding and editing records3m 39s
-
-
4. Creating Data Entry Rules
-
Setting field properties6m 58s
-
Using input masks5m 36s
-
Setting validation rules8m 26s
-
-
5. Relational Database Techniques
-
Creating key fields4m 56s
-
Creating table relationships5m 58s
-
Using subdatasheets4m 24s
-
-
6. Working with Queries
-
Creating flexible queries7m 27s
-
7. Working with Forms
-
Introduction to forms2m 8s
-
Creating subforms6m 18s
-
-
8. Working with Reports
-
Using the Report wizard6m 9s
-
Formatting reports9m 48s
-
Printing reports4m 34s
-
-
9. Working with Macros
-
Creating macros4m 57s
-
Validating data with macros7m 16s
-
-
10. Sharing Data with Word and Excel
-
Importing data into Access6m 14s
-
Using Package and Sign5m 27s
-
Sharing via email4m 29s
-
Exporting data to Excel4m 37s
-
-
11. Working with Charts
-
Working with charts7m 14s
-
Working with pivot charts5m 21s
-
- 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: Using subdatasheets