Microsoft Access 2010 Tutorials
Data Forms / Access 2010 Forms
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 / Data Forms / Access 2010 Forms)
Now let's turn our attention to Access 2010 Forms. Now forms are one of the really cool powerful features of Access 2010, because as we begin to gather a lot of data into our tables in our database, we can use forms to view and edit that data. Now what you're going to get here with your forms is a much cleaner layout, than that Data Sheet View, where you're used to seeing it kind of like an Excel spreadsheet. The forms are completely customizable, we can make them look and feel anyway we want to. What a lot of people do, was make these mimic the style of the paper forms that they might be using in the office, and I can even have multiple forms provide different ways to access the same data. So let's say accounting needs to see the customer account data, in one form, and then shipping needs to see it another form. They're looking at the same data, but they're seeing it in different formats, and this can be really cool. Now there are three methods of form creation in Access, and what I want to do is, jump out to Access here, and let's take a look at these three. Now if I go to the Create Tab, and click on this, you'll notice over here in the Forms section, they're kind of spread out, and we'll play with some of these, as we go through other videos in the course. But the first one right here is the Auto Form, this kicks off the Form Wizard, and then this gives me Form Design. So I wanted you to see where these were on the Toolbar, and let's talk about these in a little more detail. Now the Form, which is also called Auto Form, you just don't see the word Auto in the Interface out there. This let's us create forms via mouse clicks. Now this is by far, the fastest, simplest way to create a form, but it's also going to be one in which Microsoft does your thinking for you, they're going to lay your form out. You have some options there, and, and I'll show you that in a separate video. It's pretty cool, it's for the real quick and dirty stuff, and then you can go change it around if you would like. The Form Wizard gives you a lot more control. It's going to kick off the standard Microsoft style Wizard, it's going to ask you a few questions, you're going to click on a some things, choose what to put on the form, and you're going to click on some navigation stuff, and boom, a form appears, and then you can tweak it from there. So form, a little more involved, it gives you a little more control than the Auto Form function, and then of course the granddaddy of them all, is Form Design. And with Form Design, you're going to start with a blank palette, you're going to create your form totally from scratch. You have absolute total control. So the control freaks love Form Design, and what you're going to do most likely, is more or less, evolve from an Auto Former, up to the Form Wizard, and then you'll know you've reached official nerdom, when you're opening up the Form Design Tool, and you're creating your own forms from scratch, and you're getting into a lot more programming and a lot of other functionalities. But that's the Access 2010 forms. Now there's multiple designs, and multiple layouts, of each one of these, or various version of these. We'll kind of take a look at some of those as we move through the course, but this is where it all starts with Access 2010 forms.
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
