Access 2016 - How to Make a Database - Part 1 - Tables 

You taught me more in 15 min and 52 secs than my prof for Database Fundamentals did. In a whole year!

Long time ago I learned Access 2000. And THAT had a lot of stuff in it. Took me a few years to learn about 3/4 of the things it could do (self-taught), so I imagine 2016 has a ton more. I actually loved learning how to create a database. It also showed me all about forms and how to design them, and how to create drop-down menus, dialog boxes, links, shape and move objects around, hover tips, create parameters in form fields....amazing stuff.

Thank you!!! Excellent instruction. I followed along with Access open, and it worked perfectly. You did a good deed for the day and didn't even realize it!

I knew it! This guy is a Resident Evil fan. Thanks for this great tutorial mate :)

Great teacher for a platform that can be sometimes made so confusing to understand- refreshing my memory again since years of touching Access!

Excellent tutorial. You spoke at a good pace making it easy to follow step-by-step using Access. Thank you.

Thank you so much! I am learning Access to help make sense out of my chaos and the books I have don't seem to get down to basics! I was so frustrated thinking, "HOW DO I ADD ACTUAL INFORMATION to the database???!!!" You gave me just what I needed. I've taken notes (because I know I'll forget) on my ipad as you're instructing and getting ready to head to your second video. Again, thank you!!!!!!!

Thanks for making this. I especially appreciate your concern for consistency and use of precise language, critical for technical instruction. Well done and thanks again.

One of the best Tutorial on RU-vid. Simple to Complex. 👍👍

I enjoyed watching this video and recommend to others Host seem to be an expert in Access Database Teacher tone is also good Please keep post some more videos Thanks for educating the community and appreciate your volunteership. Than a bunch

Thank you so much for this video. Access has never been easier.

thank you this video is helping a group of people bring back a game we all loved

A nice one. I had missed an introductory class on this but now am ahead of others already. Thanks to you.

Was watching this for class and had to keep it together while this man was typing in resident evil characters

Had to get this fully for my exams....It's a great help.

Thanks for taking your time to show us how to get this done.

Have a test tommorow,hopefully I do well from these videos.Thanks so much!

Thank You! I learned so much by watching your video.

Thanks so much for the way you did this i am a total dinosaur and have never done anything like this i have watched a few vids and it all just goes over my head , i loved the way how slowly you spoke and made every so clear . So thank you sooo much

Wow i have to say this is way better and easier than trying to work with relationship links. thank you for your tutorial.👍👍

Really informative. LOVED the nod to Resident Evil there :)

I have no idea what Resident Evil is...but this video was extremely helpful!

I'm simple love to see Claire, Leon and hopefully Chris on this series soon.

Very helpful video, thanks, I've always wondered what I can use Access for.

WOW!!! You helped me learn all my things from Access and I never used access before and I got a A+ in digital tech thank you I am 9 years old year five New zealand

this is the first time I have used and seen it explained this and its great I am splitting a 200.000 row database in to separated tables and this method suits best (thankyou)

Thank you for the great effort you have put. Because of you, I now know it.

Clarity in your explanation. Good work

Exactly what I needed as a beginner.

I am trying to make a Database for partnumbers. And right now I have a form for each table. And I was wondering if I could use one form for all tables? The part numbers have a format of 88-XXXX to 106-XXXX and I want to have the first two-three digit number assign where the part number goes in the tables.

Quick question. When linking a another table to another. And then you change the values example delete an associate, would a ticket which you made before delete the associate’s name that created the ticket?

Amazing tutorial, thanks!!!

this video is amazing .thanks for making it.it is very helpful and it helped me for my internal assessment and even the part 2 of this video has helped me a lot

Thank you very useful I need to make a database and I have not made a database for many years great memory jogger.

Love the resident evil references!!!!!!!!!!!!!!! Great material, thanks.

Just got done with a session of RE2 Remake and decided to learn Access. I like how you think sir.

I love this, everything consistent! And this was very helpfull for my schoolproject, thanks a lot!

Thank for the tutorial. Very helpful

Thank you very....much! I was really looking for this! 👍🏻...

Informative tutorial. Thanks for sharing.

Wow a Database for the Umbrella corporation and S.T.A.R.S agents, love it.

Watching this video before i do this exam. Hope this video help me .

superb guidence . helped me a lot. feels like a person is teaching yo

Hey man, thank you so much for this tutorial!! It really helped me a lot!

Very clear instructions. Thanks.

This was really helping me mike

When changing the Case_Status Field name from Short Text to Lookup using the Lookup Wizard. I do as the video does but when I go to save the Database I get a "Type Mismatch" Error in the default Value. Cant figure out a way around it and thus the Case_Staus field remains Short Text

To re-size all field names at once, first select the entire table by clicking the very top left cell. Then double click in between any of the field name cells and the table will re-size all fields to fit the names. No need to manually drag the cells.

oh my gos you guys are my heros thank you so much i love you guys without you i would be noyhing yeeessssssss

I like your video very much. It's really great. I'll keep an eye on your channel. I am your fan and I will support you.

Nicely illustrated..

Why there is a star sign showing on the column? what does this mean ?

great work MS Access Love

Great series of tutorials. I'm very new to Access. I like the lookup wizard to control the input of fields, however, if you make a form to input data to your table can you make the lookup wizard dropdown appear there? Thanks!

Awesome work, very good way of explaining the things and making them understand. wonderful job. Thanks

Nice One and informative ..

U make my day man... RE fans

Thank you for the amazing video

good tutorial, helped a lot

it helped me get all right in the tech Exam a+

Weel I've done my revision for my test. Ty

In access the formulas or the computations refers to the enter columns, not specific cells(fields). You can only use Col A plus Col B. In excel you can input formula in a single cell in which the components are located in a different row. ex: in cell A1=B1 + B2 or A1 = C2 + B3. If you copy cell A1 and paste it on cell range A1 to A10, this will paste the formula to each cell from A1 to A10 with each cell's related components in the formula. Is this possible in access?

I would like to make Edit form, to change incorrect data. Is there any video about this topic? Thank you

The Host is doing it well

Nice Resie reference, bro

can you teach me how to make t-shirt survey using access,when i enter employee id number,the choices will pop up small to xxxl

thank god you explain so easily than my own teacher.lol

very helpful video. :)

thankyou for the explanation....to good...!!!

great tutorial. thank you

How do i change to invoice logo which is already available in access database.

Great video thank you!

A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control how to fix

Great video....liking the ref to Resident Evil ;-)

hi im hoping you can help me. ive created 2 tables on my database on ms access. one is 'customer details' etc and one is 'completed' sales/deals. what i want to do is keep all records of customers for cars in the main big 'customer details' table and any completed deals from that table automatically added to the 'completed' table. i want to have a button or option like completed on the end of the table maybe like a yes or no column. by which i could click and it would automatically add the relevant fields i want to the completed table. i would like to know how i can go about that.

I love the resident evil references 😆

Thank you Sir!

thank you , this is very helpful. Suddenly I need to make a database for my company , this really help. : ) by the way incase you don't know yet because your too busy at work, Resident Evil Final chapter is coming soon ^_^ .

solid video m8

Thanks for the great tutorial and I love the short video too, somehow the long drawn out videos bore me.

pro explanation to set up table was good....it very clear and understanding...i was able to follow. con was not enough depth or details for example editing . it included 2 lesson set up table and linking....i was not prepared for linking....i wanted to gain more insight into table set up which was not provided in your video

watch on 1.25 speed

Great Job

this help me, thanks.

hello, I am searching to be able to fullfile automatically a field thanks to the previous field. I explain. I got a table named "Customers" with 3 fields ( Id, Name, Sector) and in an other table I use the Customer Name by selecting it thanks to the LookUp Wizard tools. After that I select the customer name that I want and I would like the next field of this table (Customer_Sector) to be automatically fullfiled thanks to the Table "Customers". Any Idea or help ? Thanks in Advance

Nice One just in just a single video what will happen if I enter the data in Capital like u enter first EMP101 then you correct it Emp101 how does it make a difference..

Pls use screen zoom while working... It helps us to watch clearly.. Thanks for your tutorial.

Doing unit 18 (Database Design) within my College in the course BTEC Level 3 90 Credit Diploma in IT. I heard that you need name tables using the name "tbl_ Is this true? Or a preference that the tutor is attempting to hand over?

Thank you, now I won't fail my CA

Thank you so much!

I am new to data base entry system. I need more videos to watch as I can help my personal learning skills. 🖕🖕

thanx a lot for this video

great stuff

I still have no idea whether you mean a speeding ticket or a ticket to some event

Thanks this helped for my exam

Thank you so much for these videos. I am in the Air Force and though they supply us with the whole Office Professional with all of these shiny tools, we are never trained and stuck using excel for everything we do. I started watching your videos and in 4 days I've already created a pretty useful database and am trying to do more with it. I have a question if you would be so nice to answer. I have 3 tables, one of the tables loads from an outside source. I import an excel spreadsheet every time i need to update it basically. The other 2 tables are static and rarely change. I have three queries to give me 3 values. The 3 values are the count of basically 3 count-ifs statements. What I need to be able to do is to use these 3 values at the same time so that i can do math with them. ie % of tasks completed, etc... Do you know a way? Right now, I use these queries to get the data, then use excel to manipulate it, but I feel like I should be able to automate it. This is important because I am the only one in my shop that understands what is going on with the database right now and I need to dumb it down to press and button and it gives you the answer for the rest of my shop. Thanks again.

My Look Up Wizard is not working. I followed all the steps you've shared and this pops up on my end "The Lookup Wizard doesn't apply to this data type" Any recommendations on how to fix this?

Thank you so much for these videos. However I cannot find 10 and 11. : (

Love the RE names! hahaha

Greate Tut thanks alot Sir! >>> :) >3