 So what happens when we want to again create now instead of queries we built a few different queries I want to create now some forms and reports. I want to go ahead and have customized Ways we can view my data. So the first one is I want to go ahead and again come to my create tab But instead of going to that form button that did all the work for us this time. I'm going to come to form wizard Luckily the form wizard kind of goes through the song and dance for us But what I'm going to go ahead and do is I'm going to make a New patient form So that patient option I went ahead and just looked for my patient table And then I will go ahead and just click everything in there again We're dealing with a new patient and I click on next the next thing it asks me is How do you want the data presented? Do you want it in column our tabular data sheet? Those look very similar to what we were just looking at or justified. I'll keep my column nerve just for that you know sake and Pretty much. That's it. No, we're going to call this new patient Form and I'm going to just hit finish. That's going to open it up And you see we get exactly that we now have a way to look at our patient data Now herein lies a little bit of a thing. If you look at it, it looks terrible. It looks pretty bad How do I fix it? Just like we did with our table and our query we could switch between views I can switch between my views and go to layout view Layout view notice. I can't type anything. I can't start to type Anything in but as I mouse to the left you see I can actually Resize these things I can change the layout So that all of my data kind of has a more uniform look to it Now for this because it's a date it's gonna be right aligned How do I change that just like we did in Microsoft Word and Excel? I have my alignment sections all I have to do is say align left done Come down here one more time for my email and boom. That's Everything in a nutshell for just a very simple form Now what happens if I want to make a more complicated form again? Why would I make a new patient? Well, it's probably because you came to visit. So let's actually this time do the same thing form wizard Patient add all that information in but now I actually want to add in more data I want to add in the reason for their visit. So I'm gonna add in everything again But you notice how I have this visit that patient ID and then I have this patient at patient ID Well, I only need one of those. I don't need them both because again, they're supposed to be linked together So I just get rid of one of them again You notice it's gonna get rid of the patient ID because I don't need to Differentiate between the two of them and they click on next and it's gonna ask me How do I want to organize my data? Well again, any one patient can go to many visits can have many visits versus Anyone visit can have many patients doesn't work that way. It's the opposite So I want to organize my data think of this like the group by by my patient How do you want to view your data? We'll just keep it as datasheet. We hit finish What do you want to name this stuff? New patient with visit Visit sub form when we hit finish We get the exact same thing notice again We see all of our data and then we now have a Subform as well again if I want to clean this up I can click on my view and I can now just change this up a little bit This doesn't have any correlation to the first new patient form. We made this is a completely new form So I do have to go through the song and dance again of cleaning this up Just making sure everything stays a little more organized. Let me I'm a stickler for this stuff to be a little perfect. There we go The last thing I'm gonna do is change well not last but I'm gonna also do This notice again. This is data that I can organize. I can Resize this guy to appear on the same line And I'm gonna just bring it out so that we can see all of it as well So now if I ever had a new patient say for example, I come all the way down to the end I'm gonna make a new patient by switching my view heading to my design tab switching my view again I have a new patient so To to to to to to to to to I don't think anyone's got that one. What's their last name? Reynolds Bert When was Bert Reynolds born? I don't know We'll say he was born You know what that's gonna take a lot of clicking. So I'm just gonna say one slash one slash 1965 What's his phone number nine one zero eight six seven five three oh, nah, yeah, yeah, one two three not real street of Hollywood California his zip code is nine oh two one oh his email is Burt at Reynolds calm again because I have this new patient this new patient probably has a new visit Well, guess what? Oh, there you go. I can now insert a new visit ID So I'm just gonna say arbitrarily seven eight nine zero When did he visit? Well, he visited today and what was the reason? Daily Botox shot, I don't I don't know And it was a walk-in so now again that data Comes over to my patient information. I go all the way down to the bottom or what did I name? What number did I give him two two two two two? So he would probably be right there Bert Reynolds. I click on the little drop down You see I have his bow top shot now. There are no invoices for that, but hey, I could make that as well