HomeВидеоигрыRelated VideosMore From: Design and Deploy

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

3448 ratings | 899427 views
Audio vastly improves beginning with Part 3. However, here is an updated version: https://www.youtube.com/watch?v=pjQdzlVqKOk 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 : https://www.youtube.com/watch?v=3ljoKaS6M9Q
Category: Видеоигры
Html code for embedding videos on your blog
Text Comments (154)
Nadine McLaren (2 days ago)
Excellent tutorial. You spoke at a good pace making it easy to follow step-by-step using Access. Thank you.
Stacia Campbell (7 days ago)
Watching this video before i do this exam. Hope this video help me .
De Mus (15 days ago)
It would be way better if you prepare your video before you start shooting it. Just as with designing a database in your head first before you start typing the codes.
Alejandro Gallardo (1 month ago)
Hi! nice video. I wilñl watch the entire tutorial for sure. May I ask you, is there any reason to use hyphens between words in the titles? I know it is somewhat the estandar buit I want to know if there is any particular reason to do that. Thanks!
Design and Deploy (1 month ago)
Yes, it is considered a best practice. Leaving spaces can cause issues if you are writing scripts in visual basic or SQL.
Daniel Hahn (2 months ago)
Nice Resie reference, bro
Ben (2 months ago)
At 1.5 speed, he sounds like Dwight K Schrute :D
Ol Dirty Gamer (1 month ago)
Watch on .5 speed he sounds stoned.
Aayshah Rudder (2 months ago)
Had to get this fully for my exams....It's a great help.
Sanat Bansal (2 months ago)
thanks
Marc Holmes (2 months ago)
Thank you Sir!
Andre M (2 months ago)
Thumbs up if making a database for a DnD world
Dijon Psalm (2 months ago)
Resident Evil Reference hahaha
QueenKaito (2 months ago)
Was watching this for class and had to keep it together while this man was typing in resident evil characters
Mr Happy Face (3 months ago)
I still have no idea whether you mean a speeding ticket or a ticket to some event
Nhân Lê Khánh (3 months ago)
Resident Evil fan spotted
Tiyon Dye (3 months ago)
it show me alot
Emily Mast (3 months ago)
Very helpful video, thanks, I've always wondered what I can use Access for.
ASHAFA DAHIRU (3 months ago)
Thanks
Ruben Davila (3 months ago)
Amazing tutorial, thanks!!!
Karina Rodriguez (4 months ago)
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?
Design and Deploy (4 months ago)
Not sure as I never received that error while making this video. Can you check what data type you set the field to? Also, which field are you having an issue with?
Aries Castillo (4 months ago)
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
Pasta Pasty Pastu (4 months ago)
I'm simple love to see Claire, Leon and hopefully Chris on this series soon.
Charlene Does Stuff (4 months ago)
I have no idea what Resident Evil is...but this video was extremely helpful!
thank you, i try edit Access on YouTube
Antony Palmer (5 months ago)
Thank you very useful I need to make a database and I have not made a database for many years great memory jogger.
Blue Print (5 months ago)
love that
ATM Boss (5 months ago)
scooby got waves
MM (5 months ago)
very helpful
Modhumita mondal (5 months ago)
very helpful
Araceli Dreitzler (5 months ago)
Thank for the tutorial. Very helpful
iah se (6 months ago)
thanks
getimed (6 months ago)
Good video, but your typing speed makes me think you're typing with an X-box controller :^)
Design and Deploy (6 months ago)
I prefer a Guitar Hero controller when performing data entry.
David Gootyeriz (6 months ago)
I knew I was watching the right tutorial when I saw you enter the first name.
Nick Debattista (7 months ago)
Have a test tommorow,hopefully I do well from these videos.Thanks so much!
Jayydol (7 months ago)
1:25-1:28 how to create table.
Known2God (8 months ago)
Great tutorial, very informative. Instead of dragging the column width, you can also double-click when you see the double arrow... this will also set the width to the longest entry.
Don't forget to highlight so you don't need to do it one by one.
Kanav Jain (8 months ago)
V good for commerce students like me!!
Mia Francis (8 months ago)
thank you so much you are amazing i would have failed w/o thisss
Bradshaw (8 months ago)
What, no love for Albert Wesker?
King Savage (9 months ago)
people may think i'm dumb but what is a ticket tracker
Design and Deploy (9 months ago)
Case Tracker. Incident tracker.
it wingryk (9 months ago)
very nice language pattern , waiting for new video
Design and Deploy (9 months ago)
Not sure why the rest of the series did not play as it is part of a playlist. Here is part 2 : https://www.youtube.com/watch?v=Lge4WO_bpcI&t=1s  . Also I have a few other stand alone short Access series that deal with specialized functions such as emailing based on table values etc.
Ethan F (9 months ago)
This gave me the mega OOOOOOOF
Norton Gartino (10 months ago)
i love the fact that you're also a gamer lol
Tiarah Keye (11 months ago)
Thank you so much!
Reubina Penn (11 months ago)
Thank you so much for these videos. However I cannot find 10 and 11. : (
DianaMarie (11 months ago)
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!!!!!!!
AMAN RAJ (1 year ago)
Why there is a star sign showing on the column? what does this mean ?
BOSS20 xd (1 year ago)
oh my gos you guys are my heros thank you so much i love you guys without you i would be noyhing yeeessssssss
Midnightlawn Films (1 year ago)
is that a boston accent?
SAI LINN AUNG (1 year ago)
Please guide to me how to download it
Melissa Dominique (1 year ago)
Thank for you help
R2O Nyc09 (1 year ago)
Thanks for taking your time to show us how to get this done.
UTC7513 UTR7513 (1 year ago)
Love the resident evil references!!!!!!!!!!!!!!! Great material, thanks.
Deb Reaney (1 year ago)
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
W Lin (1 year ago)
This was really helping me mike
W Lin (1 year ago)
it helped me get all right in the tech Exam a+
W Lin (1 year ago)
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
Wyatt Provencher (1 year ago)
wow cool im in love with accsess
SHOCKSTAR gaming inc. (1 year ago)
leon Kennedy Resident evil 4 boyz
currysteph (1 year ago)
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
Shafrul Izzuddin (1 year ago)
Thanks for the tutorial. It's really useful and help me to refresh back what i have learnt before
Geeeorge Tac (1 year ago)
Wow its true please show me how to create an one to many relationship access
Mahantzu (1 year ago)
But how do you create a noisegate to eliminate white noise?
Design and Deploy (1 year ago)
You buy a better headset/microphone, which I did and I mention in the description. Starting in part 3 the audio is much better. Also, I started a whole new series with better audio. Search for Lessons for Students on my channel, I start from scratch.
Rosela Deline (1 year ago)
i have a test on this tomorrow im so doomed
prakash raj (1 year ago)
Please update more new software video
X21 (1 year ago)
Wow a Database for the Umbrella corporation and S.T.A.R.S agents, love it.
Mark Loudermilk (1 year ago)
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!
Marius Peens (1 year ago)
Very well done - thank you
Ravi Luna (1 year ago)
I love this, everything consistent! And this was very helpfull for my schoolproject, thanks a lot!
Diego Marino (1 year ago)
good tutorial
Farhad Hoseinpour (1 year ago)
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.
John Doe (1 year ago)
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.
Joseph Stratton (1 year ago)
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.
Wessah (1 year ago)
I could do that: https://www.fiverr.com/carterwes92/create-a-custom-database-management-system-for-you
Kris_outlaw007 (1 year ago)
I love the resident evil references 😆
Mukesh Kumar (1 year ago)
Nicely illustrated..
C Sharpen Adpet (1 year ago)
great work MS Access Love
Barry! Where's Barry?
trav v (6 months ago)
Snake? SNAAAAAAKKKEE?
C Sharpen Adpet (1 year ago)
barry?
delphi7696 (1 year ago)
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.
Design and Deploy (1 year ago)
I believe what you are looking for is an Append type query. Records from one table will be added to another based on the criteria that the transaction is completed. Been a while since I made it but this tutorial covers Append type queries; https://www.youtube.com/watch?v=QxmwEccRYNY&index=16&list=PL4UezTfGBADBmCOYtQ8QohflQNY1y3oE7
Mohamed Gheewala (1 year ago)
Great video....liking the ref to Resident Evil   ;-)
bixbybixby (1 year ago)
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.
Mohammed Al-Bashiri (1 year ago)
Thank you for the amazing video
mohamed adel (1 year ago)
kindly need v important issue it is ok to pay for it my problem is i need to calculate the cost of one item by making a relation between the master item table & the Bell of material table (product tree) till now there is no problem but the problem arise when the tree contain one or two intermediate items ( other item have its separate component which should be calculated separately at first then add the result to the main item which include that item For example we calculate the rice cost which has sauce added on the recipe her we cannot make the calculation unless we make the calculations to have the sauce cost ) if you have a way to solve this programming issue i will be v grateful to you - need a way to run the sub item calculations to be added in the same time. Am i clarify what i need ???
Design and Deploy (1 year ago)
I noticed you placed this comment on the first video. Have you watched more of the series? I do cover pricing functions later in the series.
J. Hunter (1 year ago)
Thank you so much for this video. Access has never been easier.
Sokunthea Pheach (1 year ago)
this help me, thanks.
Nemesi (1 year ago)
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_<example_name> Is this true? Or a preference that the tutor is attempting to hand over?
DigitalCatalog (1 year ago)
Hi Nemesi, tbl is preferred for tables, frm is for forms. But its just a naming convention that is being used. Later on, once you go to advanced level where you need to refer to a table or form, then it will facilitate you to recognize which one is table and which one is form. For example, you create a table and a form for students record, then you can name them as tbl_student and frm_student. Suffix is same but you can distinguish with tbl and frm.
Marvin Rabot (1 year ago)
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
DigitalCatalog (1 year ago)
have a look at https://www.youtube.com/watch?v=8pMSkNGlF54
Siddhanta Mondal (1 year ago)
good video for learing :-]
Clyde Mansfield (1 year ago)
good tutorial, helped a lot
BRIAN QUINTONFLYER (1 year ago)
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)
Charles Sotis (1 year ago)
Thank you for your great tutorials - I am learning so much - and that's not that easy for an old coot like me - I'm 83 years old. I noticed a template for students/school offered by M/S. Can I copy this to my hard disk and use it? I took a peek at it and it tells about a Welcome misspelling and messing up macros. I'm a volunteer at a Veterans Support Group here in town and wonder if this can be modified to accommodate our vets. Do you offer any technical assistance and for a fee? I might need some help as I go along. Thank you for the great work you do for all of us. Chuck Sotis
Design and Deploy (1 year ago)
Glad the vids are helping. Since I work full time I typically don't offer tech support as it tends to be an open ended commitment. However, if there is something in particular you would like to see I certainly can make a custom video. So if there is some function you would like to see I can make a video that demonstrates that.
Thanks for the great tutorial and I love the short video too, somehow the long drawn out videos bore me.
hamze mahamed (1 year ago)
nice video # it help me thnkz
F0rbidden Novak (2 years ago)
Weel I've done my revision for my test. Ty
Bryce Saiger (2 years ago)
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.
Valorous - MTG (2 years ago)
Can I Connect The data to a JavaScript client?
Valorous - MTG (2 years ago)
okay, thanks for the response
Design and Deploy (2 years ago)
Not sure. I have only used Access as a stand alone application as opposed to a data source for something else.
Mia Blažeković (2 years ago)
Hey man, thank you so much for this tutorial!! It really helped me a lot!
Design and Deploy (2 years ago)
Glad to hear it. Let me know if there is something specific you would like to see.
Khalidtawfik (2 years ago)
thank you this video is helping a group of people bring back a game we all loved
Sahil Narawade (2 years ago)
superb guidence . helped me a lot. feels like a person is teaching yo
massive jeffery (2 years ago)
solid video m8
Babar Sohail (2 years ago)
thanx a lot for this video
idania Bender (2 years ago)
Hi.... Thank you for your videos... I was wondering if you can explain to me how to do a user table that depending on the user security they could either add info / change info . or just simply look the info. Don't know if I am explaining my self correctly. But your help will be really appreciated.
idania Bender (2 years ago)
Yes, I have watched a lot of your access videos. Like the way you explain things. One of the best out there.
Design and Deploy (2 years ago)
I can post something in a day or two. But in short, the fields on a form (I presume you are not letting people directly edit a table) can be locked/unlocked using VB code. So you would simply check the current login value and set the locked attribute to yes or no. Also, I notice this is on #1. Have you watched any of the subsequent videos?

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.