Access 2007 définir les relations entre tables

Comment définir les relations entre les tables sous Access en moins de 10 min.


Version Dailymotion :


Une relation est un lien entre deux tables, associant des données de la première avec celles de la deuxième. Par exemple, une table peut accueillir les noms et les adresses des clients, alors qu’une autre table contient les événements gérés pour ces clients. Une fois la relation définie entre deux tables, vous pouvez créer une requête par le biais de laquelle Access affichera les noms des clients et leurs commandes en cours.


Access 2007 définir les relations entre tables


Access 2007 définir les relations entre tables

Pour établir une relation, vous identifiez les champs en correspondance dans les deux tables. Il n’est pas nécessaire qu’ils aient les mêmes noms, mais ils doivent contenir le même type de données et d’informations.

Trois situations sont possibles:

  • les relations peuvent s’établir d’un enregistrement à un seul autre (1 à 1);
  • d’un enregistrement à plusieurs autres (1 à Valeur infinie );
  • de plusieurs enregistrements à plusieurs autres (de Infini à  Infini ).

On met généralement en relation la clé primaire d’une table avec le champ correspondant dans l’autre table.

Version Dailymotion :



Access 2007 définir les relations entre tables


Recevoir la newsletter

Inscrivez-vous maintenant et recevez un e-mail les fois où je publie du contenu.

I agree to have my personal information transfered to AWeber ( more information )

Je hais les spams. Vous pouvez vous désinscrire à tout moment.


  1. find here 30/09/2014 20:14

    I just want to tell you that I am very new to blogs and really savored this web-site. Very likely I’m planning to bookmark your blog . You definitely come with tremendous stories. Bless you for sharing with us your web site.

  2. Pingback: Sprei Katun
  3. Pingback: URL
  4. rumah baju 07/10/2014 17:12

    Hi there, I found your site by way of Google even as looking for a comparable subject, your site came up, it seems good. I’ve bookmarked it in my google bookmarks.

  5. Zella Puentes 08/10/2014 13:40

    you’re actually a just right webmaster. The web site loading speed is incredible. It seems that you are doing any distinctive trick. In addition, The contents are masterwork. you have performed a fantastic process in this subject!

  6. mario perez-tano 09/10/2014 19:10

    Appreciate it for helping out, fantastic information. « It does not do to dwell on dreams and forget to live. » by J. K. Rowling.

  7. health focus 11/10/2014 20:00

    I really like your writing style, wonderful information, thanks for putting up :D. « All words are pegs to hang ideas on. » by Henry Ward Beecher.

  8. situs judi online 13/10/2014 08:27

    Wow! This can be one particular of the most useful blogs We have ever arrive across on this subject. Basically Magnificent. I am also an expert in this topic therefore I can understand your effort.

  9. Santi (Jakarta) 13/10/2014 21:52

    you are truly a just right webmaster. The website loading pace is incredible. It kind of feels that you are doing any distinctive trick. In addition, The contents are masterpiece. you’ve done a magnificent job in this matter!

  10. Pingback: ar15 lowers
  11. rajajudi 14/10/2014 09:09

    Nice blog here! Also your web site loads up fast! What web host are you using? Can I get your affiliate link to your host? I wish my site loaded up as fast as yours lol

  12. Theda Jakiela 14/10/2014 09:48

    I’m still learning from you, but I’m making my way to the top as well. I certainly love reading all that is posted on your website.Keep the information coming. I enjoyed it!

  13. Pingback: Pomodoro
  14. judi bola 14/10/2014 17:04

    I take pleasure in, lead to I discovered exactly what I used to be looking for. You’ve ended my four day lengthy hunt! God Bless you man. Have a great day. Bye

  15. cara daftar sbobet 14/10/2014 19:46

    Thanks for sharing excellent informations. Your web site is very cool. I’m impressed by the details that you have on this website. It reveals how nicely you perceive this subject. Bookmarked this web page, will come back for more articles. You, my friend, ROCK! I found just the information I already searched everywhere and just couldn’t come across. What a great website.

  16. tiens 14/10/2014 21:37

    I’m just writing to make you be aware of what a impressive experience my girl developed reading your web site. She figured out many details, most notably what it’s like to have an awesome coaching spirit to get most people quite simply thoroughly grasp various multifaceted subject matter. You truly surpassed my expectations. Thanks for coming up with these practical, trustworthy, revealing not to mention easy guidance on the topic to Emily.

  17. Steward 15/10/2014 04:57

    I’m very satisfied with all your writing skillsets as logically like with the structure for the blog site. Is this fact the paid out subject matter or would you personalize it oneself? Anyhow continue being up the fantastic high-quality writing, it really is unusual to look an incredible web site just like it at present.

  18. Pingback: Income opportunity
  19. Pingback: Cheapest Vaporizer
  20. Pingback: Video Game Guide
  21. What’s Taking place i’m new to this, I stumbled upon this I’ve discovered It absolutely useful and it has helped me out loads. I’m hoping to contribute & assist different users like its helped me. Good job.

  22. advance auto parts deals 17/10/2014 19:11

    We absolutely love your blog and find almost all of your post’s to be exactly I’m looking for. Does one offer guest writers to write content to suit your needs? I wouldn’t mind publishing a post or elaborating on many of the subjects you write with regards to here. Again, awesome web log!

  23. Pingback: bandar bola
  24. Pingback: Recommended Site
  25. Irma Harshberger 21/10/2014 11:59

    Ones post is really useful. Greater than which, it?? s interesting, compelling and also well-written. I’d desire to discover a lot more connected with these kinds of good writing.

  26. Pingback: goji vita
  27. Bosch Stabmixer 22/10/2014 18:36

    An informative blog site posting right there close friend ! Cheers for it !

  28. alat cleaning 22/10/2014 20:12

    It¡¦s really a great and useful piece of info. I¡¦m satisfied that you shared this helpful information with us. Please stay us up to date like this. Thanks for sharing.

  29. Apryl Kenndy 22/10/2014 22:11

    Hi there would you mind sharing which blog platform you’re working with? I’m going to start my own blog in the near future but I’m having a hard time making a decision between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design seems different then most blogs and I’m looking for something unique. P.S My apologies for getting off-topic but I had to ask!

  30. Pingback: free gold maps
  31. Effexor Lawsuit 23/10/2014 17:53

    I want to mention my own affection for the generosity meant for individuals that have the importance for guide using this problem. Your perseverance to finding the information throughout ended up wonderfully productive and still have at all times created pros much like us to achieve his or her dreams. Your personal very helpful short training indicates a good deal if you ask me plus for you to my personal workers in offices. Thank you; by all people of us.

  32. Pingback: Corporate counsel
  33. Pingback: pozicka
  34. Google 24/10/2014 02:20

    That may be the end of this report. Right here you

  35. Pingback: Restaurant
  36. Pingback: SEO Company KSA
  37. clearlice reviews 25/10/2014 15:30

    I wanted to thank you for this great read!! I certainly loved every bit of it. I’ve got you saved as a favorite to check out new stuff you post

  38. Pingback: useful reference
  39. Pingback: Vernon
  40. how to make a cartoon movie 01/12/2014 08:39

    Appreciate your sharing this best doctor. I have actually been actually browsing online more than 3 hrs today, yet I never ever discovered any sort of fascinating write-up like yours. Them is actually quite worth sufficient to ensure me. In my viewpoint, if all website managers as well as bloggers made good web content as you accomplished, the web will certainly be actually a ton better in comparison to ever before. | I have actually been actually scanning online additional compared to three hrs today, however I never discovered any sort of intriguing guide like yours. In my opinion, if all net owners and bloggers made good information as you did, the internet will certainly be actually a whole lot additional practical compared to ever in the past.

  41. celebrity heels 01/12/2014 20:46

    This is a excellent article, thanks for sharing. The largest reason why, is due to the fact that when you generate different points

  42. Wood Floor 06/12/2014 17:17

    that’s good, thanks for sharing,.. I think this is great blog

Laisser un commentaire

Votre adresse email ne sera pas publiée.

Vous pouvez utiliser les tags et attributs HTML suivants: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>