 So now if I look at the patient table, I've got a few things already kind of lined up But you know if we look at it who has a fax these days really And county notes, you know, there are some things I don't need So what I actually want to do is one of the things that we had when we kind of downloaded all of our files was a patient dot txt file Now that patient dot txt file if you look at it, it looks like this and this looks confusing and weird and scary Now the idea is well all of this data is Actually what I'm going to want to put in to this database and if you see I've got sort of a Patient ID if we can kind of sync these up title. I don't need a title. I do need my last name That's actually kind of what Darcy and Mendez is referring to Edward and Andres That's my first name. Then we get a date of birth. Okay makes sense Everyone apparently is born at midnight. Believe it or not Then we got our phone number good But then we start dealing with our address not our phone number phone numbers actually kind of far away and again I don't have fax county or notes So I do need to make a few changes the first is I need to get rid of fax county in notes To do that all I have to do is mouse over you notice I get a little kind of black arrow pointing downward If I click on that that highlights an individual field what that allows for me to do is right click and I can select to Delete the field And that gets rid of it if I want to do more than one field this time County hold drag notes Right-click delete field that allows me to do two at a time I'm going to keep on going with this but this time I'm going to actually click on email The reason why is I don't want to delete email, but if we look at that patient table again I need to include Sort of the street address the city the state and a zip code So I got a few things I need to add it to do that. I'm going to head over to my fields tab Now my fields tab this allows me to insert these things and you can see I can actually add my fields and delete my Fields from here as well, but I don't want to just select a generic type You know because we're dealing with an address again Street address city state zip code. I've already got you know those Four things kind of they're always going to be the same no matter what and what's lovely about that is Access kind of already has that in place. You notice we have that more fields button And if I click on that I get a few different options that I can select from down here at the bottom You should see that I have a quick start section and if I select that You're going to notice that what happens is right after phone right before email I get address city state province zip postal and country region Well, we're just going to assume that you know, nobody from the UK is going to come to this urgent care in America So we're going to go ahead and get rid of at least that Country region delete now. I am going to do a few other things. I'm going to go ahead and change state and province I don't like the fact that it's Well state province I want to just say state Notice I have the property section here as well Just like when we were dealing with the table design. I have it here as well I have name and caption if I click on this I can actually change what its name is I'm going to change it from state province to just state and I'm going to get rid of province again I'm going to hit okay Now the other thing is if we're looking at states if we're thinking about a database The reason why we have something like field size is to limit how big it is How much data can go in there? if we take a look every single one of these states Well, they're all going to be CT, but the main focus is they're all going to be two characters So it actually it seems very wasteful for me to have 255 Spaces allocated for what will always be two letters in C SC NY CT somebody I just changed my field size from 255 to 2 Now again, I'm going to come over here to my zip postal. I'm going to do the same thing I'm going to go ahead and change it from zip postal to just zip zip Just to clean it up a little bit more So now that I've got this kind of lined up again, I don't need my title Because if I look at my patient table again, I've got ID Last name first name date of birth so ID not last name last name first name date of birth I'm going to go ahead and select delete title All right, double-check it again date of birth Check phone number check address check city check state check zip check email check. All right So now I need to import my data in to do this We head back to our external data section and You see we get a number of different options now one of the things to kind of take note of with that Patient file Notice how everything is sort of with quotes and it has commas everywhere This is known as a comma separated value file and it's exactly that it's just a bunch of text It's a bunch of data separated by commas We're going to go ahead and actually import that now. It's a txt file, which means it's a text file Which means we would select this text file option, which is going to bring me a dialogue box menu from here I'm just going to go to browse. I'm going to look for my patient txt file and when I select open the first thing I need to do is I need to pause and Look at what I'm doing. What am I saying import the source data to a new table? No, I don't want a new table I just designed this table. I just designed patient So I want to append a copy of the records to the patient table. I then hit okay The table you are currently trying to append is currently open and must be closed before proceeding Do you want to save the change today and close the table? Yes, I do because I want to import my data That closes out a patient you see again Because we're dealing with a comma separated file What we introduce is something known as the delimiter the delimiter basically is what is separating my data from my other data That's actually what this comma is and if I go ahead and hit next you can see it will let me Specify what it is if I said it was tab. All right. Well, nothing happens If I say it was a semicolon nothing happens if I change to a space I get a weird little hodgepodge where it's basically wherever I saw a space if I Specified it as my quotations. I get a weird set as well Or when I do comma it separates everything out into individual rows. I click next That's all I have to do for my Wizard so as soon as I hit finish Do you want to save your steps? No, we don't need to save our steps But as soon as we open up import errors. Oh, our phone was not the same So we do need to change that. All right, so let's close out of this that is If we come back over here notice what phone is let's actually click on the fields tab The fields tab right now says that my data type for phone is a number a number So I got a lot of stuff. I gotta do the first thing is I actually have to delete everything which sucks I know We select everything Delete record you're about to delete 49 records. Are you sure you want to do this? Yes, I am I Need to change my phone number from a number because if we looked at it again Where are you those dashes right there? Those dashes are not something you do with numbers Those are again. I'm not trying to do subtraction. I'm just trying to have dashes in my number So I need to change this from number to short text Now when we go to import our data text file select Patient open append to patient Okay Everything looks in order when we hit finished this time Notice we don't get any more errors to pop up. This doesn't matter anymore, but take a look at my Patient data now. You're saying to yourself. Okay. Well, how do I get rid of this guy? Well, I can just right click on him And you see I get a number of options I can delete him you can't delete it because it's open Again, Excel is our access is always very very difficult doesn't want you to be able to do a lot of things all the time delete Bo