Microsoft Access 2010 Tutorials
Access 2010 Basics / Access Database Objects
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 / Access Database Objects)
Now as we get ready to jump into Access, open the program up, and start to dig around in there and show you some stuff let's talk about what you're going to find inside Access and how it relates to all the documentation that you're going to read out there in the various books, websites, Microsoft's TechNet, and all that sort of thing. Access 2010 has six top-level objects, or these are the objects that you're going to hear referred to most often as objects in the Access universe, OK? So let's go over these. First of all, the first topic that you'll hear probably the most about is the Table and, of course, the table is what holds the data. Now you can have one table, you can have up to somewhere around 2,000 tables. It all depends on how far you want to segregate your data out, how much data you want to put in there, and all sorts of things. A Query is considered a top-level object in Access and a query is an object that we write a little bit of code to or we drag and drop some things and we come up with a query to manipulate the data. Now, manipulating the data could mean retrieving data, updating or editing data, adding new data into a table, or deleting data out of a table. And so all of those are considered queries and it's kind of interesting that a select query that really only pulls data out is the only thing really there that truly seems like a query. Everything else seems like an action, but don't let that throw you. But you might think that as you go through there. Now a Form, this is something that is really kind of unique to Access. A form gives us an interface that we can present to either ourselves or to users that they can use to input and display data, and of course, we're talking about things like text boxes, drop down boxes, combo boxes, radio buttons, check lists, and that sort of thing. Now in most database environments, that form is going to be developed or created by a programmer using something like Microsoft C#, Visual Basic.net, you know, Java, some sort of programming language separately, totally from the database. But one of the cool things about Access is that functionality is built into Access and it is one of the six top-level objects in the Access world. Now the next one is Report, and once again this is one of the powers and conveniences of Access. The Report functionality is built right into the database. Again, you get out there in a SQL-Oracle environment, the reporting is not built in. You'll have to go outside to say a Crystal Reports, Microsoft Reporting Services, there's a bunch of other ones out there, some really cool ones, but for Access, the Report is one of the main database objects and it's very easy to go in there and generate reports that will display the data and give us the opportunity to print the data out. Now, Macros is something else that's kind of unique as a database object in the Access world and this is really cool. The Macro, first of all, automates tasks. Anything that we need to do we can create a macro to take care of that for us. Now here's the cool part. There's no programming required. Now, when I say Macro here I'm not talking about the macros that you're used to seeing say in Excel or Word where you turn on the recorder and do a few things and stop the recorder and it remembers what you did. There is a really cool drag-and-drop environment in Access. We can take care of Events - we can do all kinds of really cool stuff. I'll show you that in a section in the course a little bit later on, but the Macro is one of the six top-level Access database objects. The Module is another Access database object, and this is where we put VBA programming code. When dragging and dropping and so forth with the macro won't give us what we want, or we get ready to turn into a serious control freak and write out the code ourselves to make it do exactly what we want, we can open a Module and start to write VBA or Visual Basic for Applications code, in that Module and then execute all that code whenever we invoke it a number of different ways. There's virtually no limit to the power that you have when you start to use the VBA code out there and you're placing that code in those modules. It really is a little programming environment that you can develop in and write code. So that's your six top-level Access Database Objects. Keep in mind, everything's going to kind of key off of one of these six objects in Access for any kind of functionality you do. If you go to another database product like SQL Server, Oracle, you won't see all of these things listed as objects in their environment. You will see Tables and you will see Queries, but you're not going to see Macros, necessarily Reports, Modules, all that. But anyway, that's the six for Access and that's what we're going to concentrate on in this 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
