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

Audio vastly improves beginning with Part 3. However, here is an updated version: • Access 2016 - Database...
Creating and linking tables.
I have added some one-off videos for features that can be added whenever. Here is one for a City/State selector : • Microsoft Access - Sta...

[@NinjaB0y88]

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

[@GumbySmashed]

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!

[@peterlaurence10]

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

[@bixbybixby6752]

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.

[@nadinemclaren3869]

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

[@foxptnetwork898]

One of the best Tutorial on KZbin. Simple to Complex. 👍👍

[@mishi1067]

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

[@ThePapaPalpatine]

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.

[@aayshahrudder7975]

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

[@DIANAMARIEGARNER]

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!!!!!!!

[@Khalidtawfik]

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

[@Zer0es]

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

[@krismaly6300]

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

[@joycekimani9812]

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

[@r2onyc092]

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

[@QueenKaitio]

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

[@ang3lx_xdvst]

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

[@moejohn2893]

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

[@VarongTangkitphithakphon]

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

[@antonebaja]

Then Wesker, and Barry.

[@debreaney1]

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

[@nsytr06]

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

[@wlin3891]

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

[@user-uq1fq6gs3i]

W Lin // Wow, I wasn’t making data baces in year 5, I got to that in year 11 😂

[@Charlenedoesstuff]

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

[@MadireddySriBharat]

Clarity in your explanation. Good work

[@eddiecolon7184]

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

[@kevinchen3230]

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

[@quintoflyer]

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)

[@lorigladden3791]

Exactly what I needed as a beginner.

[@mpgoyo]

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

[@mkdesmond4863]

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

[@jakef1519]

watch on 1.25 speed

[@JecIsBec]

thank you :o

[@casparharte]

I wish there was a 1.25 button IRL sometimes.

[@aboteeka]

watch on 0.25 speed

[@demondoguk]

Lol brilliant. Nice call.

[@davidsanders7530]

Rick Sanchez 2x

[@rubendavila9076]

Amazing tutorial, thanks!!!

[@rakshakgupta9012]

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

[@staciacampbell5654]

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

[@lisannee101]

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

[@JohnDoe-el7gm]

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.

[@aracelidreitzler7220]

Thank for the tutorial. Very helpful

[@UTCUTR]

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

[@antonypalmer2815]

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

[@miablazekovic1125]

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

[@designanddeploy5991]

Glad to hear it. Let me know if there is something specific you would like to see.

[@australiangetaways]

Informative tutorial. Thanks for sharing.

[@X-MEN21]

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

[@danjia]

Very clear instructions. Thanks.

[@sahilnarawade8524]

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

[@yosefaregahegn1682]

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

[@HiroyukiMori]

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?

[@MaackTheman]

Nicely illustrated..

[@markloudermilk522]

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!

[@csharpenadept7145]

great work MS Access Love

[@brycesaiger4224]

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.

[@wlin3891]

This was really helping me mike

[@danielhahn7329]

Nice Resie reference, bro

[@wlin3891]

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

[@nicholasbartley8141]

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

[@taimuranjum]

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

[@HaloCraft865]

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

[@ytcsabiq]

U make my day man... RE fans

[@pronounceword]

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.

[@MrAlbashiri]

Thank you for the amazing video

[@datascientistoflife8550]

Nice One and informative ..

[@clydemansfield3183]

good tutorial, helped a lot

[@nashonokumu6613]

The Host is doing it well

[@simoiyahector-morales9521]

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

[@zeeshanpatel2170]

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

[@cgrovesnorartcollector6699]

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

[@mathejoh]

very helpful video. :)

[@DHRUVI-nr9nt]

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

[@amanraj1749]

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

[@cofiguy]

great tutorial. thank you

[@Praveenbklingayat]

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

[@currysteph]

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

[@jhomstanabe4934]

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 ^_^ .

[@designanddeploy5991]

Glad it helped. Let me know if there anything specific you'd like to see. I just added a video for how to make a City/State selector. Although its a common functionality it's a bit tricky. Looking forward to RE: Final Chapter.

[@marcholmes9437]

Thank you Sir!

[@abhricosuave]

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?

[@CrystalEsteves]

I love the resident evil references 😆

[@nobleinexile4296]

Great video thank you!

[@reubinapenn961]

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

[@mgbutterman]

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

[@davidkoo1542]

Thank you, now I won't fail my CA

[@Lohansa]

Thanks this helped for my exam

[@Bayfers]

What exam was that

[@melissadominique2832]

Bayfers edpm

[@violinplayer3518]

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

[@sokuntheapheach2767]

this help me, thanks.

[@knowledgeeducationCambodia]

thank you, i try edit Access on KZbin

[@benkadel2614]

At 1.5 speed, he sounds like Dwight K Schrute :D

[@oldirtygamer]

Watch on .5 speed he sounds stoned.

[@farhadhoseinpour2943]

Very good, Thanks for this excellent tutorial. By the way the quality of video and voice was poor and not clear. Please repeat it with higher quality. Thank you.

[@tommaassss]

solid video m8

[@BlackMagickMike]

I really appreciate your video. I wish you have verbalized what you were doing more precisely for those of us trying to follow along in the application. I had to pause and 'rewind' more than I would have liked to to see exactly WHAT you were doing...

[@designanddeploy5991]

At the time, I posted this video on a whim. Back then the channel was mostly Unity game design. Had no idea this would become the most popular video on the channel. For what its worth I did go back and do a new database tutorial from scratch. It might be better: kzbin.info/www/bejne/ppu0la2ii9Z-hc0

[@EricWilson-mz7ft]

I like the RE reference

[@munkeyjoe]

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.

[@wessah9859]

I could do that: www.fiverr.com/carterwes92/create-a-custom-database-management-system-for-you

[@hadeelelshiekh6112]

Great Job

[@TiarahAdams]

Thank you so much!

[@iggyboyTV]

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

[@samangausilabe7597]

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

[@datascientistoflife8550]

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..

[@juschase7251]

great stuff

[@Foodmakingtechniques]

thanx a lot for this video

[@KJ_20]

V good for commerce students like me!!

[@imranmohammadusman]

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

[@Mr_Happy_Face]

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

[@diegomarino25]

good tutorial