Access 2016 - Primary Key - How To Set a Field as a Primary Key in Microsoft MS Office Database 365

[@afk.anxrchy]

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 ❤

[@shaziashujat]

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

[@simranpreetkaur1087]

I am obsessed with the way you say primary key😊😊

[@theresapage4339]

Thank you. Cramming my mind This weekend for a new job position. This really helped.

[@ProfessorAdamMorgan]

Glad it helped!

[@shahjahan1752]

Thank you so much for this, I really needed this, this was really helpful. Keep up the good work!!

[@ProfessorAdamMorgan]

Glad it was helpful! Thank you for watching, Shahjahan!

[@astridsilane5957]

Thank you so much I got a full mark on my assignment I’m a subscriber from Saudi Arabia 🇸🇦 🥰

[@ZsuzsaKarolySmith]

I'm trying to help my son with his A-levels and this was driving me crazy! Thanks a bunch!

[@arifasadat]

Thank you so much

[@tripulse9710]

Thanks a lot mate.This really helps me with my assignment

[@ProfessorAdamMorgan]

Glad to hear that! Thanks for watching!

[@Rosannasfriend]

Your mention of JOb Search Skills made me have to sub! Good job!

[@ProfessorAdamMorgan]

Hey I'm glad this video worked for you. Thanks so much for watching and for subscribing! Have a nice day.

[@lucid004]

Thank you mate I forgot how to do it lol hopefully I get high in my assignment.

[@rashadbennett4103]

Did u??

[@shivamtiwaryslp8422]

Wow nyc explanation👍👍

[@ProfessorAdamMorgan]

Thanks a lot 😊

[@ronalw.3953]

Explanation is Dope. The cap is Dope 🤜🤛🤘💪

[@kimiondzagha4267]

Very helpful

[@ponceprecy]

Thank you I apply it to my projects.

[@smoky6038]

Thanks a lot bro I'm indian i like your english once again thank u🥰

[@zansalamun945]

ur a legend my guy

[@The_Last_Outlaw]

Bro but how u got primary key in the datasheet view??

[@fcoronita2264]

Thank you!! This helped me so much!

[@ProfessorAdamMorgan]

I'm glad this was helpful for you F Coronita, thank you for watching.

[@jmarz2889]

Thank you 🙏

[@thegodofwater75]

So, a primary key is used to prevent duplicate information in a table?

[@ProfessorAdamMorgan]

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.

[@thegodofwater75]

Professor Adam Morgan okay, thank you. I just wanted to make sure i was understanding it correctly.

[@ProfessorAdamMorgan]

Yep, you got it. Let me know if you have any other questions. Have a nice day.

[@avuzwantshongwana4990]

@@ProfessorAdamMorgan When will Access store data which is ordered by the primary key field?

[@cynthiabangura8622]

@@avuzwantshongwana4990 zd zip 4

[@akramjamil2534]

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

[@maxbr712]

thank you bro. you saved me

[@shanebuckham7029]

What's the benefit of using a Primary key over just setting the field to unique in table properties?

[@IShowU]

You are the best Thank you

[@ProfessorAdamMorgan]

Thanks, let me know if you need help with anything else.

[@Cheddarswiss21]

awkward but i think this is the same exact assignment im working on at the moment

[@ProfessorAdamMorgan]

Nice, your teacher is using the same book. Hope this was helpful for you.

[@tonyclarke24]

Thank you such this helped me 🤗🤗🤗

[@ProfessorAdamMorgan]

I'm happy this helped you out, Tony. Thank you for watching!

[@carolynmeggs9431]

Very helpful! Thank you!

[@mikewright3026]

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.

[@coltonostermeyer3126]

You saved me from breaking my $1700 laptop. Thank you.

[@ProfessorAdamMorgan]

Glad to hear it Colton, let me know if you have any questions. Don't break anything, have a nice day!

[@LetsTalkAboutIt808]

Great video! I need to know how to correct an Invalid arguement error. Thanks

[@trishnadoshi5988]

Thank you for sharing this video. Can you help in identifying the duplicate records and how to delete it from the database?

[@ProfessorAdamMorgan]

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

[@m7mdabohashem]

Thank you maaan you helped me a lot 🤗🤗🤗

[@samtumminello3552]

Thanks so much!

[@choosebest3709]

Nice Video sir! Who to edit the primary key?

[@alicepobudova4613]

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!

[@ProfessorAdamMorgan]

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: kzbin.info/www/bejne/roG0lZmQl9Z2h80

[@APSABKAKITCHEN]

which recorder do you use

[@robinzatulovski4098]

thank you so much

[@ProfessorAdamMorgan]

No problem Robin, thanks for watching.

[@ardalinaa]

thanks man!

[@HL1334]

I am getting the same error, but when i goes into the design view, there is no primary key defined

[@ThinkWhatYouSee]

hello sir thanks

[@gresaavdyli593]

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?

[@ayeshaakhter7127]

I want create two primary key in database table.is it possible to create more primary key in database table???

[@kshitizsharma4461]

can you explain all the keys and how to use them?

[@ProfessorAdamMorgan]

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.

[@leonmaina5269]

is it necessary for a table to have a primary key

[@ProfessorAdamMorgan]

Hi Leon, Not necessarily, you can create a table without one.

[@Leicarcain]

1nkU really much

[@-o-itscharli]

I was wondering how to make the primary key an autonumber when data is already input into it.

[@ProfessorAdamMorgan]

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.

[@rk9515]

What If my table doesn't have a state's table?.

[@ProfessorAdamMorgan]

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!

[@sadafkhan1679]

prof. pllz tell me how to make relations in access

[@ProfessorAdamMorgan]

Hi Sadaf, Sure, I have a video on that right here. Have a look and I hope it helps you out! kzbin.info/www/bejne/hKW1cqyJZbF_os0

[@coltonostermeyer3126]

Actually I do have another question. What the hell is the point of Access anyways? What can it do easier that excel can’t?

[@ProfessorAdamMorgan]

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.

[@coltonostermeyer3126]

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.

[@ProfessorAdamMorgan]

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.

[@pertuniamakosha9012]

👏❤