Microsoft Access 2010 Tutorials
Relationships / Relationship Reports
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com�s entire library of video tutorials.
Learn More
Subtitles of the Movie (Microsoft Access 2010 / Relationships / Relationship Reports)
Now let's talk about relationship reports. Now this is going to be a very short video but it is going to be one real cool piece of functionality that is going to be vital that you take advantage of, and I want you to know it's there, and so I wanted to put it in a separate movie, so you would be sure and see it. And that is the idea of relationship reports, and I want to show you how to generate one of these. If you go to Database Tools, anytime, click on Relationships, and that takes you kind of into this Relationship Design Ribbon here. And notice it's going to show you all your relationships. Now if, if you move these around, once you get them positioned the way you want, very simple, just come over here, click on Relationship Report. Now notice what that has done for you alright? It has generated this sheet, and I can zoom out, and there is all of my tables. Now I will close this out, and I will not save it, I want to go back out and show you something. However I position these things, and then go click on this Relationship Report, that is it what it's going to generate OK? Notice what it's giving me, it's showing me the name of the table, all of the columns in there, here the name of the table, and it's showing me that I have a one to many relationship. It's giving me the date of when I created it, the relationships for lesson city, that's the name of the database, lesson city, and here is the really cool thing. When I close this out, it's going to yell at me, and say do you want to save changes and I say yes, and it's showing me the relationships for lesson city, and I just say OK. That is on here as a report. Now I can close it. At any point in the future, when we start to think about, adding a new field OK? The boss comes and says hey listen, we need to be collecting this data, I just found out today, they want to see reporting on this data. I come in here, I double click, and I can look, and I can say, OK, wait a minute. I can even print this out, take it to a meeting, better yet, open this up with a projector, and let everybody see it at once, and, and between me and the other database nerds, if there are other database nerds, figure without too violent of a fight, where to put more information. Do we want to now split the instrument out into it's own table? Because we have instructors doing multiple instruments. Whatever needs to happen, you have a documented structure of the relationships of your database. This will be worth quite a bit on certain days when you're trying to make changes, or adjustments, or determine better ways, more efficient ways to store your data. So I just wanted you to see this functionality, and I will close this out. And again, if you go to Database Tools, Relationships, it's kind of hidden right here, Relationship Report, will make that happen for you.
Tutorial Information
| Course: | Microsoft Access 2010 |
| Author: | Mark Long |
| SKU: | 34224 |
| ISBN: | 1-936334-91-7 |
| Release Date: | 2011-05-12 |
| Duration: | 9 hrs / 121 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
