Using subdatasheets


show more Using subdatasheets provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Using subdatasheets

One of the bonuses of creating relationships is that you can then see sub data sheets within your tables, without to having run a report. Open up your SalesReps table, notice the Plus sign to the left of my data, click on the Plus sign, next to Jordan Hinton and you'll see all of his customers, then click on the plus next one of his customers and you can see all of that customer's orders. It would be handy to get some statistics on these orders, click on the Totals button up in the ribbon near the center.

Now a new Total row opens and you can click at the bottom of each cell to get a dropdown that has a number of different statistics that you can see for each order, this totals rows is covered in detail and the totals video in the course, click on the Minus sign to close Avulon. Now here's a slick trick, this gray box in the corner of the sub datasheet allows me to expand or collapse all of the sub datasheets at that level, let me show you how it works, click on the gray box ...

Using subdatasheets
Video duration: 1m 27s 3h 43m Intermediate

Viewers:

Using subdatasheets provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...