Insert Needed Field Form For Free

hi and welcome everyone today I'm going to be doing a video request for Microsoft Access 2016 this request comes in from yiny yiny says could you please do a video on adding existing fields in Microsoft Access and also creating an object using application Parts well I'm going to go ahead and do the first portion of that which is adding existing fields to your forms let's go ahead and get started right now all right so right here we see a table this table has coaching information so coach ID first name last name certification expiration and a couple other fields here all right so first thing I'm going to do is create a form so I'm going to go to the create tab right here and then I'll go right over here to the forms group and I'm going to use the form wizard to show you how to use that so I use the form wizard right here and then I add the fields that I want let's say that I want coach ID first name and last name of the coach I click next I choose whatever option that I want over here I'm going to leave it as call AR click next and then finally I press finish all right so that's going to create this form right here all right so the question was how do you add other fields so we saw here I have Coach ID first name and last name let's say that I wanted to add the certification to this particular form well the way that you're going to do that is in uh the Home tab the views group click the view button and change it from form view which again is for editing the actual uh data itself and change it to layout view so you click on layout View and it's going to open up a different set of options right up here under form layout tools area and so if I click through here onto the design tab right in here I can see that in the form layout tools design tab the tools group I have this option right here for add existing Fields all right so I click that now I can add in the certification so in this case I guess I'll just add the certification level okay now it's right over here if I double click it it's going to add it on now I want you to take a look at how it adds it on so if I double click it it adds it on right on top of everything else that I have over here now it's going to be hard for you to kind of go down here and line it up so it looks good so I don't really like to do it that way what I like to do before I add on any Fields first I select the actual data itself and I go to the uh arrange tab right up here and I select all of the list levels as well as the labels and so I select all of them by holding down shift and clicking on each one and then I go up here to Stacked and I click stacked okay that's going to put them in a stacked format okay that'll give it a uniform look then I'll go right over here and now if I click on certification level notice it adds it right onto my already stacked area Okay so depending on where you were clicked it will add it on to right there and I could always click and drag to move move the field around okay so that's how...