Get a FREE Microsoft Access 2019 Introductory Course here ►https://theskillstream.com/access-2019-intro-course

In this video tutorial, learn how to design your database using tables in Access 2013.

Get the full course on Access 2013 course here: https://www.simonsezit.com/courses/microsoft/learn-microsoft-access-2013-training-tutorials/

View the entire Access 2013 video playlist: https://www.youtube.comhttp://www.youtube.com/playlist?list=PLzj7TwUeMQ3hFA4R_5Z1Fc2HZX8C2O1YV

Stay in touch:

SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)

Hello again and welcome back to our course on Access 2013. It’s time now to get started on design and build of a database in detail, and we’re going to start with tables. The main sample database we’re going to use is a movies database. We won’t get terribly far in the design and build of a movies database in the time of this course, but we should make a pretty good start and I hope you’ll get plenty of ideas to be able to carry it on later on and after the course is finished.

Now in terms of exercises for you to do, I will be setting these and there is absolutely no reason why you shouldn’t work on a completely different database yourself as we go along, maybe something associated with your work, the job that you do, maybe something associated with an interest you have at home. And it’s entirely up to you. The examples I’m using will mainly be around the movies database, although there will be one or two others from time to time. If you follow along with what I’m doing, then you will find that you cover all of the main things that you need to know. One thing I should warn you about though before I start is that in the early stages, this movies database is going to be pretty badly designed as you’ll see. I’m deliberately going to do a bad job for a while in order to illustrate what a good job is.

So let’s get started.
Okay, I’ve been working on a database here. I’m going to close it in the usual way. No changes. And I’m going to go for a new database. Now in this case, I’m not going to use any of the existing templates. I’m going to go for Blank desktop database. I’m going to give it a name and I’m going to number these versions of this database as we go along and that will tie in with some of the exercises that there are to do. So this is Movies 1.accdb and I’m going to create it in that sample folder that I’ve used from time to time so far. So I’m going to put it in that folder with the contacts ones, and then I just click on Create and my database is created. Now note that when it’s created, the number of objects is very small. In fact, it opens a dummy table. One thing’s for sure in an Access database, you’re going to need a table.

Now let’s suppose that I just want to start getting some data into this table. Supposing I type in here the name of a movie, here’s a new movie, press the Tab key, and now let me put in the year of release and let’s suppose at the moment all I want to record is the name of the movie and the year of release. Now you may recall from earlier on that in order to save a record to this database or specifically into this table, I just need to go to the next one, the next record, the one that says New, and I’ve got a record in my database table. It says Identity Thief and it says 2013. But that’s a pretty messy job to be honest with you because I haven’t really looked at the structure, I haven’t really looked at what Identity Thief and 2013 are and so on. Now you may recall that earlier on we talked about the different views of a table and we’re currently in Datasheet View. So we’re looking at the data. What I want to do is to switch to Design View.

Now there are various ways of doing this. If you look at the buttons at the bottom right hand corner of the screen on the status bar, there are two buttons. The one on the left currently selected is Datasheet View. I can click on the one on the right, Design View. There’s also a button on the left of the Ribbon to switch views as well. But when I’m in Design View, I get a little bit more idea of the structure of my new table, although I can’t see the data anymore at all in Design View. And what Access 2013 has done is to give me three fields.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.