Microsoft Access 2010 Tutorials
Access 2010 Basics / Creating a Database
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 / Creating a Database)
Creating a database in Access 2010 is very straightforward. Not a whole lot of things have to happen. The only thing that's confusing about it is, is that creating a database off of this File Tab, or the Backstage View, if you will, notice I've chosen New, so I obviously want a new database, but that is referring to the Templates right here. Notice I can choose Recent up here, and look at my recent databases and open those, but if I want a new database I actually have to jump all the way over to the right side of the screen, and I don't know why it is, but our eye just doesn't naturally fall over there, but that's where it is. Now, what I want to do is give it a Name, and I will call this VTCTest, for the name of the database, and then I just click on Create and so there is the beginning of my new database. Now, notice I didn't have to allocate any disk space or log files. We don't get into all that in Access, if you're familiar with SQL or any of the other database products out there. And this has done one thing. It knows that I want to create a database and so my database is going to have to have tables to hold the data, and so it has automatically set me up a table in what's called Datasheet View. We'll talk a lot more about that a little bit later on. But what I do want you to see is that the Backstage File View is always here even though I can move through my various Tabs, and we'll talk about this later on, about getting around in Access, but when I go back to the File, now I can go to Options and these things will not be grayed out like they were before, OK? You can see that in Current Database I can put a lot of information in and I can look at a lot of things that are going on and make some changes. Now, I can OK out of those and they will be there. Now, sometimes it will tell me that I need to turn on certain parts of the database, I need to close down things, restart, sometimes I have to close down the entire database and reopen it based on the settings that I did, so you will just see some things as you go through here. Notice we are in VTCTest now, and we can come out here and now start to create tables, and so forth. But that's how we open a database and get started is to come out here and Create it, and then you'll notice now that my VTCTest is showing up right here, and if I go to Recent Databases here's the VTCTest. Now let me show you one more thing that really helps a lot. Notice these Pins out here. If I keep creating more and more databases this will eventually fill up, OK, and notice I can tell it down here, Access this number of Recent Databases, well I can run this number on up and keep that number out here, but eventually they will fall off of here and get replaced. If I come out here and pin it right here then it won't go away, it'll always be there available for me. And then, I can right-click on this one and say Remove this from the list or, and this is the good one, Clear all unpinned items, and if I clear that it will take all the unpinned items away. So, the databases that I can create I can also get back to very easily out here in Recent Databases, OK? So, that's some of the basics on creating a database, and so, in the next few videos we'll actually start to get in there and move around, work with Access, and start to build our own database tables.
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
