Access 2007 Tutorial 1.2. Tables and Relationships

[Bautonman]

I wish I had more thumbs to up for you.

[kaylasather]

This is waaay too slow. It's best if you speed up then the people that need extra time can pause and rewind. It's painful to watch this.

[MorrisonCTQ]

I am trying to track wellness hours earned for each of my employees. If they do not call out, leave early, or not late more than 2 times, they earn 8 hours of wellness per month.

I am not sure how to give them what they earned and then deduct what is used.

[9578755]

thanx man, its a great guide

[baciMaras]

Fantastic

[KoalaBearWarrior]

dude you type too fast. LOL

[cutewarrior786]

great ,,thankkkkkkkkkkkkkkkkkkkkkkkk­kkkkkkkkkkkkkkkkkkkkkkkks

[francesbebe]

Thanks! You have opened a new avenue for me.

[RoayaPixel]

THANK YOU THANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK YOUTHANK

[fjilfaz]

Thank you very much sir.This helped me a lot.Keep up the good work.You are an excellent teacher!!

[H8131126]

i think if you want to create a relationship with another table...

the foreign key must be the same to the primary key of the other table...

because the foreign key is the unique attributes of an entity and that is the primary key of one relation table....

[bivan1000]

this is good staff...in my thesis am required to create arelational data base schema this schema has various relations of many to many, one to many,many to one. it is being designed for a real estate data base...please give me some counsel on this

[bsbeitler]

A good introduction and simple to follow demonstration of how a 'one-to-many' relationship works.

It's worth pointing out that for consistency, keep the fields names the same when joining them together especially when you could have several tables using a generic field name 'ID'.

I've linked this tutorial to my blog 'AccessDatabaseTutorial' (don't forget to add the dot com bit at the end) Check it out and bookmark it.

[ounous]

Thanks for the help.

[AnotherMasterMind]

I'm trying to create a Report, but it must include both number and text data. How can make a relationship between different types of data? I need to know if there is a data type I can choose so that I can make a relationship between them.

[djdates]

@AnotherMasterMind You will need to have something they have in common so that they can be related. That commonality might be that they are in the same record in the same table. Or it might be that they have a common piece of data in each record that is also in other tables. These common pieces of data are your keys and are what your build your relationships with. Unless you only have a single table, you need to create these keys and relationships before you create any reports.

[AnotherMasterMind]

@djdates Thankyou! My teacher wasn't much help. I was convinced the relationships must be between the data involved in the report.

[MrYocopyperson]

i want to make a table showing the relationship separate so in total i would have three tables except when i try to connect them like you did the computer tells me that i could not lock tables because the separate table i am trying to get the relationship data is in use by another person or process?? can you help me??

[djdates]

@MrYocopyperson Make sure you have closed all of the open tables before trying to create relationships (click on the x in each open table tab). You are getting this message because the tables are still open and locked.

[MrYocopyperson]

@djdates thanx it worked!!!!^_^

[MrWatandoost]

you know what i learnt access in 7:47 minutes. all thanks to you. thanks you

[insanecaine]

Excellent!

[Djibrill1123]

OMG you sir are a life saver ;) thank you very very much..

[Bones139]

These videos are great..saves me buying a textbook :)

[Summerflap]

Thanks for the great help you offered, I had tried this multiple times without the succeeding.

[ms1sign1]

Thank you soo much. I having been ripping my hair out for 7 weeks about this. I had everything backwards! You cleared it all up. Thank you. I can now start to understand the rest of the semester.!

[y2j1980x]

Can I just say an enormous thanks to the maker of this video? I've been formally studying this stuff for a week or so and the place I've been going to has basically described everything around these extremely important facts which have almost magically made some things I was getting quite annoyed about, suddenly make sense - you the man!

[ricardo3326]

thumbs up if you're watching this for your Management Information System Class~

[cybermaniac11]

thank you

[shariq79]

Good

[SnowyHime]

thanks for making these videos. they really help me alot!

[utkarsh12]

VERYY NICE

BORAT LIKE

[Amgeno]

This is great, but your contents states that you cover "Foreign Keys" but I don't see that anywhere in this tut? Can you show us how to create a Foreign/Secondary key and why you would use it?

[djdates]

Thanks for pointing that out. The foreign key is created at roughly time 4:30 and I have added an annotation that refers to this now as a foreign key. Foreign Keys are covered in more detail in the next video in the series. A foreign key identifies a primary key in a different table in order to relate different rows of data in different tables. Secondary keys are columns that could have become the primary key instead. I may discuss such keys in later videos, when time permits.

[marclauren007]

Awesome tutorial!

[yanniz4eva]

Can somebody please help me answer this question? The need for several tables rather than one large table containing all the same information. Thanks

[djdates]

Duplicate data can cause problems when you change the data in your large table. When a name changes, like someone getting married, you have to change their name every place it appears in your one large table. How do you know if you actually have two real people named Marge Smit and Marge Smith or if this is a typo and they are really the same person? By putting this data into a separate table, we reduce the amount of duplicated data and reduce the number of potential problems. Does this help?

[yanniz4eva]

GOD BLESS! You couldn't have explained it any better! Thank you very much buddy. :)

[timcoleman]

Cheers, I've watched quite a few tutorials on access, but now I've found one which actually seems to make sense

[redschizonut]

this is a really great tutorial! very simple and easy to understand. please keep on making these vids as they help me a lot in my studies! - thanks!