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

Using subdatasheets - Microsoft Access Tutorial

From the course: Access 2007: Shortcuts

Start my 1-month free trial

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…

Contents