From the course: Access 2007: Shortcuts
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Using subdatasheets - Microsoft Access Tutorial
From the course: Access 2007: Shortcuts
Using subdatasheets
One of the bonuses of creating Relationships is that you can see sub datasheets within your Tables, without having to run a Report. Open up your SalesReps table. Notice these Plus signs to the left of my data, click on the Plus sign next to Jordon Hinton and you'll see all of his customers, then click on the Plus sign next to one of his customers and you'll see all of that customer's orders. It would be handy to get some statistics on those orders. Go up to the Ribbon, to the right of center, and find the Totals button. Click on it and you'll see a total row. Now, I can click at the bottom of each of these cells to see statistics for that field, for example, I can find the largest order that was placed by that customer. This Totals row is covered in detail in the Totals Video in this course. I'll turn the Totals off and click the Minus sign next to Avulon to close it. Now here's a slick trick, this gray box in the corner of the Sub Datasheet allows you to expand or collapse all of the…
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.