 One of the things that you're going to notice as soon as you turn on Microsoft Access is this is a little interesting. We don't actually start off with anything. What actually happens is because of the complexity of a database, Microsoft Access isn't just going to magically make a blank one for you. You actually have to specify it. Instead of Microsoft Word, which opens up with a blank document in Microsoft Excel, which opens up to a blank spreadsheet, we do not explicitly open up to a blank database. We actually have to make one. And like always, you can see we have all of these different styles that we can work from. So I can make a project management one. I can deal with inventory if I'm a small mom and pop shop or bigger mom and pop shop. But as you can see, we have tons of these that we can build from. Look at that desktop home inventory if you want to maybe keep track of your own inventory. But the one we want to focus in on is that blank desktop database. Now, the first thing it's going to do is it's going to ask you, what do you want to name this? Well, we're going to at least kind of follow suit with the textbook. And I'm going to call this Chatham. Chatham. What we're doing is we're going to deal with building a nice little emergency care place. And so we're going to hit create. Now, again, if we look at this, notice we don't see much at all. So what do we want to go ahead and do? Well, the first thing you see is we do now that we've created our blank database. It starts off with a blank table for us. So we need to go ahead and start to add in our data. Now notice you see it says click to add. Basically, we need to specify what the next thing is going to be inside of my database. Right now, I only have my ID for all my records. I need to go ahead and say, let's add in something. So if we click on this, you see we get a dropdown menu with a few different options. We're going to go ahead and start with short text. Again, just like I had mentioned, short text allows me to store texts, numbers, symbols, basically anything that you can find on your keyboard. So we're going to go ahead and call this one patient ID. Now here's a lovely thing. If I go ahead and type enter or hit the inner key, it's actually going to move to the next one. It's going to go ahead and do that click to add again because it understands what's next. So this time we're going to go ahead and say, well, since we're dealing with the emergency care and we're dealing with our patient, when did they show up? When? Well, that's a kind of date and time little concept. So I want to go ahead and select date and time. And we're going to actually call this one visit. Now here's the interesting thing. I'm not going to put a space. I'm going to say visit date, capital D for the date. But notice if you can, I did not actually put a space. Now the reason behind this is it actually goes back way back in the day when we were designing out databases years, decades ago. Spaces were actually kind of not something you did for your field names because the computer back in the day couldn't handle that. They actually kind of reserved that for, oh, if you hit a space, that means you're doing something else. So we kind of still follow that same mentality. We do this just because there are systems out there that still deal with databases that might not be able to handle spaces. So we don't put spaces, at least to keep in the back of your head when you're doing your SAM assignments as well. Don't put spaces. You're going to get points taken off if you do spaces. So let's keep on hitting enter. So the next one I'm going to go ahead and say is we're going to do a long text. Actually, let's, yeah, why not? Long text. Now this is obviously if we're going to the urgent care, we probably have a reason for it. Now that reason, whatever reason it is, it's probably going to be a long laundry list. So we wanted to have a little bit more information. Now the last thing I want to do is we're going to also deal with something known as a Boolean data type. Now a Boolean data type basically means that it only has two potential answers. Yes or no? True or false? Boolean, it comes from George Bull. He was the kind of guy who built this logic. But again, that yes, no. Now you notice all of a sudden that yes, no, instead of just being blank like everybody else, it was a check box. All right, that's interesting. But it's something to kind of be aware of. And we'll say we're looking at whether or not they were a walk in or not. Now a walk in meaning they just walked in, they didn't call for a reservation or not. Now, okay, now we want to go ahead and start to flesh this out a little bit more. Except I do want to make one final change. You see that ID all the way over there where it says new. Well, what that means is I can't change this. I can't notice how I can't change that number. Well, that's not good for me. So I want to adjust that. Now notice when I clicked on it over here in the formatting section, that became active all of a sudden. And at that data type section, you see how it says auto number. Auto number means that it's going to automatically increment. For our sake for this example for the textbook, I don't want it to automatically increment numbers. I actually want to kind of control that on my end. So what I'm going to actually do is I'm going to drop, click the drop down menu for that. And I'm going to select short text, short text. That allows me now to type in my data. The last thing I'm going to do is I'm actually going to adjust what it's called. Instead of it being called ID, I'm actually going to right click, which allows me to now go through a song and dance of options. But I'm going to go with rename field. And so I'm going to go ahead and rename this visit ID. Because if we think about it, any one patient can visit multiple times. So I want to record every single time they do. Now, before I start typing, the last thing I want to do is I want to save this table. Because if you notice right now it still says table one. We'll get into typing in just a bit. So how I want to do this is I'm going to just select that little floppy disk. As you see, we get it up here or I can do control S. Or I can actually hit the close table option. You notice it's all the way over here on the right. Do you want to save changes to this? Yes, I do. And we're going to go ahead and call this table visit.