Microsoft Access 2010 Tutorials
Access 2010 Basics / Getting Around in Access
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 / Access 2010 Basics / Getting Around in Access)
Now let's take a little tour of the Access environment, and I want to talk to you about getting around in Access because it's a little different than what you may have seen before. And you will notice, right off the bat, that I have a database open here and this is almost exactly what we are going to build in this course here, it's called Lesson City. It's what this one's called. Ours will probably be called something slightly different. But basically I've got the Students Table in here and, if I double-click the Students Table, it will pop up. And these are some students, and these people take music lessons, and we're going to talk about a very simple little app to manage some of that so that I can show you some of the features and cool things you can do in Access 2010. Now, you can see over here in this little Object Explorer that if I click on the drop-down here that I can see All Access Objects or I can just see them Filtered by just the Tables, and that's just the tables that I have, just the Queries that I have, and that's All Objects, and so that's kind of cool. And I can click on these things, just single-click on them and close them up, and as you work in a real world environment you'll have a lot more tables, a lot more queries, a lot more forms and reports, and so forth that will show up out here. And so, by being able to housekeep out here by clicking and expanding and collapsing it makes things a lot better. So, this is really the Navigation Pane and I can move that to the left, and you'll notice it gets out of the way and stays out of the way, and I can just come back and click it again and get that back. But this is great when I want the whole screen to work on out here on my tables, queries or whatever. Now let's shift our attention to the top. Right up here is the Quick Access Toolbar and one of the cool things in Access 2010 are more Options on the Quick Access Toolbar and the ability to customize these Ribbon items up here. But, first of all, on the Quick Access Toolbar you need to make friends with this guy right away because this is a one-click access to things. Now notice, all we've got right now is the Undo and we have this little guy right here, and this is just telling us that we have our application open. Notice the little separator there. Well, if I click the little drop-down right here, for example, let's say that I want to get to the Open so I can open other databases really quickly. Then I'll just click this and notice it put the little Open icon up here. Well, now, instead of having to go out to File and go to Open to get this, what I can do now is from within my database at any point just come up here and click on Open, one click, and boom, there I am. Now, right quick let me show you, if I click on this drop-down, and right here at the top it says Customize. If I come down to More Commands now notice what I can do. I can take any Command I want, notice that's the Popular Command, so let's look at All Commands, alright? And so, anything that I like to do quite a bit I can drop up to the top up there and then get it anytime I want to. And let's take a look at something that would be kind of easy - let me scroll down here - and, let's say Find, OK? I click on Find, I move it over to Add, there it is. I can move it up or down if I would like. I'll do it right there. That'll put it on the far right side. And notice there is Find. And so if I have something open and I can find, like a Table, I can just click on that and then Find will happen in that document. So, that's one to get used to and play with. And then you will notice that we have first the Backstage View on the File Tab, then Home, this is all your general stuff - Create, this is really cool, if you need to create anything new working in Access. Tables, SharePoint Lists here, Queries, Forms, Reports, Macros. Anything we need to create, any of our objects, are right here on the Create Menu. External Data - if we want to import data into Access or export data from Access somewhere this is where we're going to do it. And notice it's telling me here this is for importing or bringing it in; these are for exporting or pushing it out; and then we can collect data from various places. Then we have our Database Tools, and you can tell here if we're going to create relationships on our Tables, if I click this I can see Relationships in my tables. I can hide certain tables, I can do all kind of cool things. Now, will we be in here quite a bit doing things? Yes. Is there a rhyme or reason for these Tabs? I haven't seen it, OK? You'll just have to get used to it. That's bad instruction, I know, but that's the best that I can tell you about these things. There is one cool shortcut, though. If you press the Alt key it will show you the keyboard shortcuts for these things, alright? And so, notice if I go to the Create Tab and press the Alt key it is telling me that if I click C right here it will take me to Table Design, OK, and so I can click Alt-C and then T D and notice there I am in Table Design. I didn't do anything with a mouse. So Alt-C T D, notice how quick I can do it. Alt-C T D, and there I am on Table Design. So, if you want to learn those things they're really cool if you like that kind of deal, and you don't have to take your hand off the keyboard and you can memorize those things. It's great for that kind of stuff, alright? So, as you can tell, there's a lot going on in this interface. We're going to see it a lot. You'll use it a lot as you go through this course with me building these tables, making these changes, looking at features, and you will get confident with them. And you'll get used to where they are, and without even thinking you'll find yourself jumping to these various functionalities, trust me. But you will spend a fair amount of time early on kind of going, wait a minute, I know I've seen that somewhere. Where was it? And, somehow it just kind of starts to flow naturally, OK? So, that's how you're going to get around in Access 2010, and that will kind of start to become more natural to you as we go through the course.
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
