How to create a database in Microsoft Access, brought to you by AccessLearningZone.com. I am your instructor, Richard Rost. To create a new database in Microsoft Access, start by opening Access up. Now, if you've previously opened databases on this machine before, you'll see them listed down here under Recent.
You'll also notice some templates up here, and these are other databases built by other people. And this is fine if you want to work with someone else's databases. But if you want to...
build your own database click on this blank database right here you will be asked for a file name for your database the default is database one not very descriptive so let's click in here and let's type in customers this file is going to be saved in your documents folder whatever your user documents folder is if you want to change that you can click this button here to browse and put it somewhere else i'm going to click create and a blank new brand new database will be created for me Now, in a Microsoft database, all of the data is stored in one or more tables. You can kind of think of tables like Excel spreadsheets. Access starts you off with your first table called Table 1. We're going to rename it in just a second. But unlike a spreadsheet, you can't just type anything you want wherever. In Access, you want to define your fields or columns and give them good names.
For example, right here where it says click to add, click on that. it wants to know what type of data you want to store in this particular field short text number currency date and time lots of different options for now just pick short text and now it says field one give it a name i'm going to type in first name no spaces take it from me this is just one of my tips is having done this for almost 30 years now don't put spaces in your field names all right so this first field is going to be First name, capital F, capital N, first name. Then press Enter or Tab. That'll move you to the next column. Again, pick short text and type in last name.
No space, capital L, capital N. Press Enter. And that's good for now.
We've got two fields. Actually, we have three fields. Access started us off with an ID field.
What's an ID field? Well, basically, that's a way of giving each record, each row, a unique identifier like a customer id a product id and so on and access will keep track of that for you using something called an auto number for now though let's just click down here and we're going to enter in some data into our table i'll type in my name rick tab rost and at this point it's just like excel tab right notice the id1 went in right next to my name if i tab again i could put in jim kirk He's customer two and so on, right? Jean-Luc Picard. And I can keep typing in customers. If you want to add more fields, you can come over here, pick the data type and type in a name.
If you want to add more records, you come right down here and type in more people. Again, just like a spreadsheet with columns that are called fields and rows that are called records. Now I'm done with this customer table, so I'm going to close it.
And access says, hey, do you want to save changes to the design of table one? We made some changes, right? We added first name and last name. So I'm going to say yes.
And let's give this table a good name. Table one doesn't really tell me what's in that table. So I'm going to type in customer T. Now, again, this is my personal naming convention. I've been using this for many years.
I like to end all of my tables with the letter T, all of my queries with Q, my forms with F, my reports with R, and so on. you don't have to do that if you don't want to a lot of people just call it customers okay don't put spaces in here also all right again very important sometimes in books you'll see tbl customer that's fine too lots of different naming conventions just pick one and try to stay consistent i like customer t now i'll hit ok my customer table is saved right there If I want to open up that customer table again and see the people in it, I can double click on it and that opens up the table. I can close it here.
If you want to create another table, just go to create and then table design. And I've got a whole separate lesson on how to create tables. At this point, I'm going to close my database.
And now the next time I open up Microsoft Access, you should see it right here on the recent list. If not, you can browse to it by clicking on open over here. And then again, here's the recent list or click on browse and browse to wherever you put your database file.
Open it up, and there you go. Now, this security warning is going to appear the first time you open any database. This is just Microsoft's way of keeping your computer safe from viruses. All you have to do since you created this database is click on Enable Content. Don't do this for databases that you got from anybody else, including downloading off the web.
Unless they're mine, of course. I'll click on Enable Content, and that will go away. And you shouldn't see that any other time you open this database in the future.
And that's it. Now you know how to create a basic database in Microsoft Access. Now, of course, we just scratched the surface with Microsoft Access. If you want to learn more about building Microsoft Access databases, tables, queries, forms, reports, that kind of stuff, I have a free Microsoft Access beginner level one course.
It's over four hours long. and it covers everything you need to know to get up and running with a complete Microsoft Access database. You'll find the link down below in the description.
If you don't have time to sit through my 4 hour course, I do have a condensed version on how to use Microsoft Access that covers all the basics in about 30 minutes. I'll put a link to that down below as well. If you enjoyed this video, please give me a thumbs up and post any comments you may have below.
i do try to read and answer all of them as soon as i can make sure you subscribe to my channel which is completely free click the bell icon and select all to receive notifications when new videos are posted want to learn more click the show more link below the video to find additional resources and links youtube does a pretty good job of hiding it it's right down there see this part of the description here right the name the videos up here there's a little show more down there right down the bottom It's kind of hard to find. But once you click on that, you'll see a list of other videos, additional information related to the current topic, free lessons, and lots more. And YouTube no longer sends out email notifications when new videos are posted that they used to do. But if you'd like to get an email every time I post in a video, click on the link to join my mailing list.
And you can pick how frequently to get emails from me, either as they happen, daily, weekly, or monthly. Now, if you'd like to become a paid member of my channel and receive all kinds of awesome perks, click on the join button. You'll see a list of all the different membership levels that are available, each with its own special perks, including my extended cut videos, access to my code vault, lots of VBA source code in there, template downloads, and lots more.
I'll talk more about these perks at the end of the video. Even if you don't want to commit to becoming a paid member. and you'd like to help support my work, please feel free to click on the tip jar link.
Your patronage is greatly appreciated and will help keep these free videos coming. I got some puppies to feed. But don't worry, no matter what, these free tech help videos are going to keep coming. As long as you keep watching them, I'll keep making more. And they'll always be free.
Now, if you really want to learn Access and you haven't tried my free Access Level 1 course, check it out now. It covers... all the basics of Microsoft Access, including building forms, queries, reports, and more.
It's over four hours long. You can find it on my website or on my YouTube channel. I'll put a link down below you can click on. And did I mention it's completely free?
The whole thing, free, four hours. Go watch it. And okay, okay, a lot of you have told me that you don't have time to sit through a four-hour course. So I do now have a quicker Microsoft Access for beginners video. That covers all the basics faster in about 30 minutes.
And no, I didn't just put the video on fast forward. But I'll put a link to this down below as well. Now, if you like level one, level two is just a dollar.
That's it, one dollar. And that's another whole like 90 minute course. Level two is also free for paid members of any level, including supporters. So if you're a member, go watch level two. It's free.
Okay. Want to get your question answered in a video just like this one? Visit my tech help page and send me your question there. Members get priority, of course.
While I do try to read and respond to all of the comments posted below in the comments section, I only have time to go through them briefly a couple of times a month, and sometimes I get thousands of them. So send me your question here on the tech help page, and you'll have a better chance of getting it answered. And while you're on my website, be sure to stop by my access forum.
We've got lots of lively conversations about Microsoft Access and other topics. I have a fantastic group of moderators who help me answer questions. Shout out to Alex, Kevin, Scott, Adam, John, Dan, Juan, and everybody else who helps out on the site. I appreciate everything you do.
I couldn't do it without you. Be sure to follow my blog. Find me on Twitter and, of course, on YouTube.
Yeah, I'm on Facebook too, but I don't like Facebook. Don't get me started. Now, let's talk more about those member perks.
If you do decide to join as a paid member. there are different levels silver gold platinum and diamond silver members and up get access to all of my extended cut tech help videos one free beginner class every month and some other perks gold members get all the previous perks plus access to download the sample databases that i build in my tech help videos plus access to my code vault where i keep tons of different functions that i use the code that i build in most of the videos You'll also get higher priority if you do submit any tech help questions. Now, answers are never guaranteed, but you do go higher in the list for me to read them.
And if I like your question, you got a good chance of it being answered. You'll also get one free expert level class each month after you've finished the beginner series. Platinum members get all the previous perks plus even higher priority for tech help questions.
You get access to all of my full beginner level courses for... every subject. And I cover lots of different subjects like Word, Excel, VBA, ASP, lots of different stuff, not just Access.
These are the full-length courses found on my website. You get all the beginner ones. In addition, once you finish the expert classes, you get one free developer class per month.
So lots of training. And finally, you can also become a Diamond Sponsor. You'll have your name or your company name listed on a Sponsors page. that will be shown on each video as long as you're a sponsor you'll get a shout out in the video and a link to your website or product in the text below the video and on my website so that's it once again my name is richard rost thank you for watching this video brought to you by accesslearningzone.com i hope you enjoyed i hope you learned something today live long and prosper my friends i'll see you again soon