types of forms in ms access

Video instructions - Types Of Forms In Ms Access

Instructions and Help about types of forms in ms access

Hello again in this section we're going to look at the various approaches to creating forms and the various types of form that we can create in the last section we use the form wizard in this we're going to look at two or three other very popular approaches first let's choose the student table first in the navigation pane and then the create tab on the ribbon and then the forms group here contains a number of different options let's start with the one that just says a form and click on that now although that happened very quickly if you've got a complex table it may take a few moments but you can see straight away what's happened a form has been created in a default layout and I can already see the first student on the form and the buttons at the bottom that let me step through it's done a similar job really to the job that the form wizard does the difference being that with this approach it takes all of the fields in the table and lays a form out accordingly perhaps the most important thing to realize with this approach is that once you've created a form in this way you can then go into design view of the form or layout view of the form and change it around pretty much at will and that's the sort of approach we're going to be taking later on one other important difference between this approach and the approach of using the form wizard is that the form is not automatically saved and in order to save that form when I come to close it access says do you want to save the changes I say yes and it invites me to enter a name for the form click on OK and the form is saved looking at the navigation pane on the Left I can now see my new form is there and if I wanted to work on it I could right click on either design view or layout view let's go for design view the form is now there and I can work on it to make whatever changes I want to one other related and very important approach to creating a form is to create a blank form I'm going to select students again and now on the create tab in the forms group I'm going to click on blank form what happens in this case is that a completely blank form is presented to me and it doesn't even specifically relate to the students table in that on the right I'm given a task pane with a field list and the field list contains all of my tables and I can in fact select any field from any table and put it onto my form now this may seem like rather hard work particularly if you've got tables with many fields in them but people who have used access.