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.

Pour marque-pages : Permaliens.


  1. You have an uncanny way of expressing your words which I find very interesting.

  2. find here dit :

    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.

  3. Ping :Sprei Katun

  4. Ping :URL

  5. rumah baju dit :

    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.

  6. Zella Puentes dit :

    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!

  7. Ping :WordPress Blogs Manager

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

  9. health focus dit :

    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.

  10. Ping :get redirected here

  11. 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.

  12. Ping :Scott Harrell Private Investigator

  13. Ping :Top Restaurants in Rye NH

  14. Ping :Best Egg Donation Centers in Illinois

  15. 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!

  16. Ping :ar15 lowers

  17. Ping :Chicago Egg Freezing

  18. rajajudi dit :

    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

  19. Theda Jakiela dit :

    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!

  20. Ping :Chicago In Vitro Fertilization

  21. Ping :Pomodoro

  22. judi bola dit :

    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

  23. 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.

  24. tiens dit :

    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.

  25. Steward dit :

    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.

  26. Ping :Income opportunity

  27. Ping :Cheapest Vaporizer

  28. Ping :Video Game Guide

  29. This article was quite absorbing.

  30. Hello. magnificent job. I did not imagine this. This is a great story. Thanks!

  31. 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.

  32. I truly enjoy examining on this site , it has excellent content .

  33. 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!

  34. Ping :Singapore Wedding Videography

  35. Ping :divination readings

  36. Ping :bandar bola

  37. Ping :Recommended Site

  38. 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.

  39. Ping :Singapore Sensual Massage

  40. Ping :goji vita

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

  42. alat cleaning dit :

    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.

  43. Apryl Kenndy dit :

    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!

  44. Ping :language of desire review

  45. Ping :free gold maps

  46. 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.

  47. Ping :Corporate counsel

  48. Ping :pozicka

  49. Google dit :

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

  50. Ping :Restaurant

  51. Ping :SEO Company KSA

  52. 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

  53. Ping :corporate portrait pricing

  54. Ping :useful reference

  55. Ping :Vernon

  56. 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.

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

  58. Wood Floor dit :

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

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée. Les champs obligatoires sont indiqués avec *