Microsoft Access 2010 Tutorials
More Cool Access Stuff / Access Analyzer Tools
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 / More Cool Access Stuff / Access Analyzer Tools)
Access 2010 has some really cool Analyzer Tools built into it that you can use to kind of check up on yourself, to see if you can design your tables anymore efficiently, see if you can get a better normalization model, and you can also just look at general performance. And the way you get to these, if you open Access, and go to the Database Tools Tab, I'll show you those, they're right here under the Analyze Section. Now we took a look at database document very early in the course, and now I want to look at Analyze Performance, and Analyze Table. Now if I click on Analyze performance, I can choose as many tables or queries as I would like, and forms, reports, you can see everything. I can get all my objects, or get the entire current database, relationships and so forth. I'm just going to take the students table, say OK, and notice it just comes back and says it has no suggestions to improve the object. Well, that's pretty good OK? Well, I could go back and say Analyze Performance, let's look at these relationships, and hit OK, and notice it is telling me that, here's an idea for me, of the tables students copy, relate this to something else in the database. In other words, what it's saying is, what are these things doing out there? You're not doing anything with them, it appears like, and I'm not, these were used throughout the course here, to show you certain things, or to play with Cut and Paste, and all that. But anyway, this is pointing out some things that notice, it'll give me a red recommendation, a suggestion, an idea, or something that it fixed. Always backup your database, before you work with any of this stuff OK? Now the next thing is, this Analyze Table. This can be really, really cool, but I got to show you something here, and this will scare you the first time that you see this. If I go into Analyze Table, I'm going to use the students copy table OK? And notice if I open it up, this is something I just did the Copy and Paste on with the tables. But if you haven't seen that video, go watch Copying Tables alright? But with this one, I'm going to analyze this table, and notice it's going to look at the table and see where it sees repeating information, and suggest normalization, or suggest splitting that out into a different table. And so if I look at the students copy table, and hit Next, I will tell it, I want to decide what to do here, OK? And I hit Next, and I can look at the table and I could let Wizard look at this for me, but I can just do it manually here, and say you know what? I'm storing City over and over and over, let's put it in a separate table, so I just left click, drag it, drop it, and notice it is going to automatically create some tables for me alright? And I will call this new city, just for the purposes of demonstration here, so we can find it, and then this, is notice, is table one alright? Now if I hit Next, it'll say create the query or don't create the query, alright? Well if I hit Finish here, you will notice that it has taken my Students copy old, and I now have a new City table that just has my Cities in it alright? And then I will have a table one here that is the old table without the City in there alright? So, this is kind of the look up field, notice to new City, let me make this where you can see it. Let's the look up field to new City right here, and we've just added those. Now did it really help me here? No, it didn't really, but it does show you what you can do this, and then if I don't like it, then I can just come out here, and start to pull these out OK? So I don't want to save that, I can close all these out, and undo these. But again, backup your database before you do this, because it can confuse you, and it can cause you to trip up and do some other things wrong, but I wanted you to see these Tools. You can analyze performance and you can analyze your tables, and get some really cool ideas on some other ways to improve your database.
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
