HomeВидеоигрыRelated VideosMore From: Game Design HQX

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

2822 ratings | 764822 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 (137)
ASHAFA DAHIRU (2 days ago)
Thanks
Ruben Davila (2 days ago)
Amazing tutorial, thanks!!!
Karina Rodriguez (13 days 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?
Game Design HQX (13 days 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 (13 days 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 (17 days ago)
I'm simple love to see Claire, Leon and hopefully Chris on this series soon.
Charlene Carmon (21 days 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 (1 month 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 (1 month ago)
love that
ATM Boss (1 month ago)
scooby got waves
MM (1 month ago)
very helpful
Modhumita mondal (1 month ago)
very helpful
Araceli Dreitzler (2 months ago)
Thank for the tutorial. Very helpful
iah se (2 months ago)
thanks
getimed (2 months ago)
Good video, but your typing speed makes me think you're typing with an X-box controller :^)
Game Design HQX (2 months ago)
I prefer a Guitar Hero controller when performing data entry.
David Gootyeriz (3 months ago)
I knew I was watching the right tutorial when I saw you enter the first name.
Cringe Master (3 months ago)
Have a test tommorow,hopefully I do well from these videos.Thanks so much!
Lavy J (3 months ago)
1:25-1:28 how to create table.
Known2God (4 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.
South Of Heaven (3 days ago)
Don't forget to highlight so you don't need to do it one by one.
Kanav Jain (4 months ago)
V good for commerce students like me!!
Mia Francis (4 months ago)
thank you so much you are amazing i would have failed w/o thisss
Bradshaw (5 months ago)
What, no love for Albert Wesker?
King Savage (5 months ago)
people may think i'm dumb but what is a ticket tracker
Game Design HQX (5 months ago)
Case Tracker. Incident tracker.
it wingryk (5 months ago)
very nice language pattern , waiting for new video
Game Design HQX (5 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.
Issei Hyoudou (6 months ago)
This gave me the mega OOOOOOOF
Norton Gartino (6 months ago)
i love the fact that you're also a gamer lol
Tiarah Keye (7 months ago)
Thank you so much!
Reubina Penn (7 months ago)
Thank you so much for these videos. However I cannot find 10 and 11. : (
DianaMarie (8 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 (8 months ago)
Why there is a star sign showing on the column? what does this mean ?
BOSS20 xd (9 months 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 (9 months ago)
is that a boston accent?
SAI LINN AUNG (9 months ago)
Please guide to me how to download it
Melissa Dominique (10 months ago)
Thank for you help
R2O Nyc09 (10 months ago)
Thanks for taking your time to show us how to get this done.
UTC7513 UTR7513 (10 months ago)
Love the resident evil references!!!!!!!!!!!!!!! Great material, thanks.
Deb Reaney (10 months 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 (10 months ago)
This was really helping me mike
W Lin (10 months ago)
it helped me get all right in the tech Exam a+
W Lin (10 months 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 (11 months ago)
wow cool im in love with accsess
SHOCKSTAR gaming inc. (11 months ago)
leon Kennedy Resident evil 4 boyz
currysteph (11 months 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?
Game Design HQX (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
Crystal Esteves (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 (2 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.
Game Design HQX (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 ???
Game Design HQX (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
Game Design HQX (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 (1 year ago)
Weel I've done my revision for my test. Ty
Bryce Saiger (1 year 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 (1 year ago)
Can I Connect The data to a JavaScript client?
Valorous - MTG (1 year ago)
okay, thanks for the response
Game Design HQX (1 year 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ć (1 year ago)
Hey man, thank you so much for this tutorial!! It really helped me a lot!
Game Design HQX (1 year ago)
Glad to hear it. Let me know if there is something specific you would like to see.
Khalidtawfik (1 year ago)
thank you this video is helping a group of people bring back a game we all loved
Sahil Narawade (1 year ago)
superb guidence . helped me a lot. feels like a person is teaching yo
massive jeffery (1 year ago)
solid video m8
Babar Sohail (1 year ago)
thanx a lot for this video
idania Bender (1 year 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 (1 year ago)
Yes, I have watched a lot of your access videos. Like the way you explain things. One of the best out there.
Game Design HQX (1 year 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?
Dan Jia (1 year ago)
Very clear instructions. Thanks.
Rick Sanchez (1 year ago)
watch on 1.25 speed
Raven Corleone (4 months ago)
Great advice.
David Sanders (4 months ago)
Rick Sanchez 2x
demondoguk (9 months ago)
Lol brilliant. Nice call.
khaled adam (9 months ago)
watch on 0.25 speed
caspar harte (1 year ago)
I wish there was a 1.25 button IRL sometimes.
John Mathew (1 year ago)
very helpful video. :)
Tom Bozza (1 year ago)
Wow, I can actually view a tutorial with a narrator who actually speaks English.
stickman47487 (2 years ago)
Hello, When I add more names to the employee directory tab, how come the drop down menu is not updating on the ticket tracker tab?
moe john (2 years ago)
Thank You! I learned so much by watching your video.
DLZ (2 years ago)
Why are you using underscores...
playhooky (1 year ago)
+Game Design HQX Are you Professor Leff? If not, you sound just like a prof I had, and he practiced underscores also.
Game Design HQX (2 years ago)
Great question! Simple answer. It is considered a "best practice" to not use spaces (spaces cause problem if you write any VB or SQL coding). But names without any breaks are more difficult to read. So, use underscores.
Kevin Bejar (2 years ago)
Basically, I am trying to revolve my IA around making a database on Access. The database has to contain 10 students let's say and the database has to contain slots where they can put in the classes they have taken, the credits they've earned, and the database has to somehow let them know if they are on track to graduate and if they have the right amount of credits in the right classes. Let me know how I could execute this plan.
Kevin Bejar (2 years ago)
Game Design HQX thank you so much for your reply I'll take this into consideration!
Game Design HQX (2 years ago)
Bunch of ways this can be done. One way would be to have a table that contains those requirements the students need and you would run a query that compares what they have taken (those values would be in a student table)versus the values in that requirement table. The query results could be displayed in a report. One column shows the requirements, the other table shows what the student has taken.
Jorge Rodriguez (2 years ago)
hahahahah, the caracters from Resident Evil
mirrr velll (4 months ago)
Just wanted to write that hahah ;D damn
Peter Laurence (2 years ago)
I knew it! This guy is a Resident Evil fan. Thanks for this great tutorial mate :)
rakshak gupta (2 years ago)
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
rakshak gupta (2 years ago)
I want a video on how to use Dreamweaver to make a web page.
James Richmond (2 years ago)
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.
Lohansa Abayasingha (2 years ago)
Thanks this helped for my exam
Melissa Dominique (10 months ago)
Bayfers edpm
Bayfers (10 months ago)
What exam was that
Nabil Nasser (2 years ago)
THAT IS VERY GOOD BUT CAN I FIND IT IN LANGUAGE ARABIC !!!!!!!!!!!
Jhoms Tanabe (2 years ago)
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 ^_^ .
Game Design HQX (2 years ago)
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.

Would you like to comment?

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