I have my computer theory exam tomorrow and really didn't understand primary key... But after watching this video i understood the settings as well thx mate
Hi Trishna, You can remove duplicates with a Query. I don't have a video on that, but this link should help you out. Thank you for watching: support.microsoft.com/en-us/office/delete-duplicate-records-with-a-query-4e6c3183-689c-439d-9062-326c85d80a83
Do the primary keys have to be the same? I’m trying to develop a training database where I can track which employee has training on what document. Couldn’t create the sub form from the two tables. Not sure what I’m doing wrong. I need to be able to input that more than 1 employee could have trained on the same document. Any pointers? Any help is appreciated!
Hi Alice, No they do not have to be the same. In fact, most tables won't contain the same primary key. Here is a video I created a while back on subforms, I hope it helps you out: th-cam.com/video/xPQdfZbqCQk/w-d-xo.html
hey, wanna ask, why when I input the primary key, I can't insert the same value or any information in one field, it ask me to change the info or remove the primary key
When I go to save anything it says "could not find field ID" do you know why this is and what might be a step to get past it? Very frustrating assignment.
Hi Charli, This is a good question. I'd recommend creating a new field, using the autonumber field style. Then go to the design tab, and switch that field to your primary key. From there, it won't peg the initial field as the primary field key any longer. I hope this makes sense.
Hi Kshitiz, Absolutely, I am working on developing an Access 2019 playlist. I'll be sure to cover each key in that playlist. Thank you for watching and for the suggestion.
Hi. I keep getting the duplicate error message bc I made another table and I am trying to make another field the primary key in that table. How do I fix this?
Hi Rk9, The tables in my example are from a database I created. You will need to create your own tables in order to create primary keys within them. Thank you for watching!
Sure, I explain this to my students every semester. Excel is more of a visual program than Access and it's designed primary for calculations and analysis. Although you can store large amounts of data on Excel, it is not really designed for maintaining the data between multiple spreadsheets. Access is better at maintaining the integrity between multiple sheets, where Excel is better at analyzing complex numerical data. For example, if I had a database of 30,000 students who attend my school, and I needed multiple tables to organize student data, well Access would be a better program for that because I can easily run powerful queries to return only the data that I need. Sure, I could do this in Excel, but I'd have to create multiple references between sheets, and I'd have to spend much more time filtering and unfiltering specific results. In short, Access is primarily designed to analyze massive amounts of text data, while Excel is best for numerical functions and analysis.
Well thank you. Sometimes I just like to know why I have these assignments and after using access I was having trouble finding a meaningful use for it but now I know.
Searched all day about primary key, never understood, watched a 4 minute video, understood a damn lot. Thank you so much, you really helped me ❤
Thank you. Cramming my mind This weekend for a new job position. This really helped.
Glad it helped!
I have my computer theory exam tomorrow and really didn't understand primary key... But after watching this video i understood the settings as well thx mate
Thank you so much for this, I really needed this, this was really helpful. Keep up the good work!!
Glad it was helpful! Thank you for watching, Shahjahan!
I am obsessed with the way you say primary key😊😊
I'm trying to help my son with his A-levels and this was driving me crazy! Thanks a bunch!
Thanks a lot mate.This really helps me with my assignment
Glad to hear that! Thanks for watching!
Thank you so much I got a full mark on my assignment I’m a subscriber from Saudi Arabia 🇸🇦 🥰
Explanation is Dope. The cap is Dope 🤜🤛🤘💪
Thank you so much
Wow nyc explanation👍👍
Thanks a lot 😊
Thank you mate I forgot how to do it lol hopefully I get high in my assignment.
Did u??
Your mention of JOb Search Skills made me have to sub! Good job!
Hey I'm glad this video worked for you. Thanks so much for watching and for subscribing! Have a nice day.
thank you bro. you saved me
ur a legend my guy
Nice Video sir!
Who to edit the primary key?
Thank you I apply it to my projects.
Thank you for sharing this video. Can you help in identifying the duplicate records and how to delete it from the database?
Hi Trishna,
You can remove duplicates with a Query. I don't have a video on that, but this link should help you out. Thank you for watching:
support.microsoft.com/en-us/office/delete-duplicate-records-with-a-query-4e6c3183-689c-439d-9062-326c85d80a83
Do the primary keys have to be the same? I’m trying to develop a training database where I can track which employee has training on what document. Couldn’t create the sub form from the two tables. Not sure what I’m doing wrong. I need to be able to input that more than 1 employee could have trained on the same document. Any pointers? Any help is appreciated!
Hi Alice,
No they do not have to be the same. In fact, most tables won't contain the same primary key. Here is a video I created a while back on subforms, I hope it helps you out:
th-cam.com/video/xPQdfZbqCQk/w-d-xo.html
Very helpful
hey, wanna ask, why when I input the primary key, I can't insert the same value or any information in one field, it ask me to change the info or remove the primary key
Great video! I need to know how to correct an Invalid arguement error. Thanks
So, a primary key is used to prevent duplicate information in a table?
Hey Cameron,
Exactly, if you try to enter a duplicate value in the primary key field, it will not allow you to add that record.
Professor Adam Morgan okay, thank you. I just wanted to make sure i was understanding it correctly.
Yep, you got it. Let me know if you have any other questions. Have a nice day.
@@ProfessorAdamMorgan When will Access store data which is ordered by the primary key field?
@@avuzwantshongwana4990 zd zip 4
Thanks a lot bro I'm indian i like your english once again thank u🥰
Bro but how u got primary key in the datasheet view??
Thank you such this helped me 🤗🤗🤗
I'm happy this helped you out, Tony. Thank you for watching!
Thank you 🙏
I want create two primary key in database table.is it possible to create more primary key in database table???
Thank you!! This helped me so much!
I'm glad this was helpful for you F Coronita, thank you for watching.
You are the best
Thank you
Thanks, let me know if you need help with anything else.
which recorder do you use
Thanks so much!
Very helpful! Thank you!
When I go to save anything it says "could not find field ID" do you know why this is and what might be a step to get past it? Very frustrating assignment.
thanks man!
Thank you maaan you helped me a lot 🤗🤗🤗
awkward but i think this is the same exact assignment im working on at the moment
Nice, your teacher is using the same book. Hope this was helpful for you.
I was wondering how to make the primary key an autonumber when data is already input into it.
Hi Charli,
This is a good question. I'd recommend creating a new field, using the autonumber field style. Then go to the design tab, and switch that field to your primary key. From there, it won't peg the initial field as the primary field key any longer. I hope this makes sense.
can you explain all the keys and how to use them?
Hi Kshitiz,
Absolutely, I am working on developing an Access 2019 playlist. I'll be sure to cover each key in that playlist. Thank you for watching and for the suggestion.
Hi. I keep getting the duplicate error message bc I made another table and I am trying to make another field the primary key in that table. How do I fix this?
You saved me from breaking my $1700 laptop. Thank you.
Glad to hear it Colton, let me know if you have any questions. Don't break anything, have a nice day!
I am getting the same error, but when i goes into the design view, there is no primary key defined
is it necessary for a table to have a primary key
Hi Leon,
Not necessarily, you can create a table without one.
hello sir thanks
prof. pllz tell me how to make relations in access
Hi Sadaf,
Sure, I have a video on that right here. Have a look and I hope it helps you out!
th-cam.com/video/NtRAyS0LLlk/w-d-xo.html
What If my table doesn't have a state's table?.
Hi Rk9,
The tables in my example are from a database I created. You will need to create your own tables in order to create primary keys within them. Thank you for watching!
What's the benefit of using a Primary key over just setting the field to unique in table properties?
1nkU really much
Actually I do have another question. What the hell is the point of Access anyways? What can it do easier that excel can’t?
Sure, I explain this to my students every semester. Excel is more of a visual program than Access and it's designed primary for calculations and analysis. Although you can store large amounts of data on Excel, it is not really designed for maintaining the data between multiple spreadsheets. Access is better at maintaining the integrity between multiple sheets, where Excel is better at analyzing complex numerical data.
For example, if I had a database of 30,000 students who attend my school, and I needed multiple tables to organize student data, well Access would be a better program for that because I can easily run powerful queries to return only the data that I need. Sure, I could do this in Excel, but I'd have to create multiple references between sheets, and I'd have to spend much more time filtering and unfiltering specific results. In short, Access is primarily designed to analyze massive amounts of text data, while Excel is best for numerical functions and analysis.
Well thank you. Sometimes I just like to know why I have these assignments and after using access I was having trouble finding a meaningful use for it but now I know.
I am glad you want to know why. Just think to use Access if you have a large amount of data that is mostly text, not too many calculation.
👏❤
thank you so much
No problem Robin, thanks for watching.