Using Many-to-Many Relationships in Microsoft Access to Track Employee Certifications, Courses, etc.

[@juststoppingby1602]

THANK YOU. This opens up so many doors for me.

[@599CD]

Glad to help

[@zakiqdb64]

excellent teacher , you cover the subject step by step can we create budget business within organization to manage the budge ex. we have annual budget expanse required to pay invoice when received

[@599CD]

599cd.com/ProjectBudgets

[@bertholdtohoover446]

Hello. Thanks for the videos, I really appreciate it. I just have one question, how would I in this example add multiple courses to a single customer? I'm still a beginner, so apologies if this has already been explained. I'm actually trying to build a database as a practice for the local restaurants in my area, I was wondering if it's possible to say, search for all restaurants that serve Pizza.

[@jdwright89]

Do you have any videos you would suggest for an artifact archive? I am an archaeologist and I need to be able to connect locations with artifact types. For example Site 1Ab123 has 3 Clovis Arrowheads, 2 Madison Arrowheads, 1 Mulberry Pottery, and 4 Hammer stones. I would need to have a system where I can list any type of artifact with any archaeological site.

[@dianecoverdale2342]

Thank you. Now I was wondering if you clicked on your ContactT table would you see the list of your customers with the sub list of the certificates taken? I've been trying to set up something like this for work. A product table, a raw material table and a raw material test table. But my problem is that often times the raw material can be used an another product, causing duplicates. Would the junction table remedy the duplicates?

[@calebhansen4991]

Great Videos. This is really going to help me out with fixing our processes, or lack thereof, at my company. Question, I became a Gold member but I can't seem to find the Many to Many extended cuts video in the members page. Can you share a link for that?

[@calebhansen4991]

Nevermind. Took me about 10 minutes of scrolling but I found it. I feel like there is a video search bar that I must be missing somewhere.

[@599CD]

There's a search bar on the top of my site. Right side. Every extended cut is on that video's page.

[@lawrenceayanful6204]

Stellar work chief... want to to know how many levels do your Access course have {beginner to exper}. And how much per level.

[@599CD]

As of right now there are 9 Beginner levels, 32 Expert levels, 6 Advanced levels and 44 Developer levels and you can find all the pricing on my website at 599cd.com/Order. And remember members get a discount up to 50% off.

[@ishaqmuhammed4342]

Simple and excellent explanation, really appreciate. How can I create a report, let say to show the list of cars I owned on the report? Can you help?

[@599CD]

Same way you create a form, except instead of a subform use a subreport

[@ishaqmuhammed4342]

@@599CD Ok, thank you for the aid.

[@MichelleFournet]

So at what point did you set up the relationships? I must have missed it.

[@Hrubicundus]

Love it Richard. But i have a question and it is a little bit spicy. How do you search for multiple values? For example, show me all the customers who got the Star Trek 101 certificate AND the Access Beginners certificate? I can't figure out how to do this query. Any ideas Ricardo?

[@lpanades]

About nomenclature: you created a junction table in the example of the certifications. Should I use an "j" like first letter o table name to identify it like a junction table? But, you put dates of conclusion so this kind of table is "fact table" if I'm not wrong. Question: Should I use one "j" or one "f" before table's name?

[@connienorris274]

I'm a silver member. How do I find the many-to-many extended cut?

[@599CD]

Look in the description below the video, you'll find it in the text there.

[@CGML]

Thanks bud! great video and instructions.

[@599CD]

Glad it helped

[@habibullahsamander2798]

If I buy membership in your website, will I have access to all the previous tech help videos ?

[@599CD]

You most certainly will. All of them. There's a lot now. :)

[@saeedbaryal8723]

Respected Sir, I want you to show me the way how we can make a database work only in a specific PC. I have seen many databases they work only one PC, but if you copy them to other PCs they don't work.

[@599CD]

There could be a million reasons why it won't run. Assuming it's not copy protected, check your Windows install and make sure you don't have any problems. Without a LOT more information, I really can't help you.

[@saeedbaryal8723]

@@599CD Thank you, dear sir. I really paise your help and replies to my comments.

[@SiDaemon]

Love the Trek references! LLAP

[@599CD]

Make it so! :)

[@jcwynn4075]

I'm not the expert, but I think for junction tables, an autonumber ID field as the primary key seems like bad practice. The primary key should be the combination of the two foreign keys (a conposite key). The way this is set up, you can have the same 2 IDs for multiple records and the database would allow it because it just uses another autoID, but in practice it makes no sense to do so.

[@moving2marz]

Thank you, your videos are so helpful. Question: If the many-to-many list of cars was all types of vehicles (cars, motorcycles, scooters, bicycles, hoverboards, etc.) and you needed to include specific details about the different vehicles, what is the best way to do this, especially since details for cars (seating capacity, cargo room, # of doors, etc) will be different from details for bicycles (pedal type, frame type, etc.). Also, how do you include multiple colors for each vehicle? Based on your Too Many Tables and Multiple Phone Numbers videos, I think the solution is a separate table for multiple colors (or multiple anything) and an extended details table for each type of vehicle (car details, bicycle details, etc.) to avoid null values of details that aren't applicable?

[@599CD]

That's a VERY good question. Too detailed to go into here. Why don't you email me this and I'll try to include it in a future video? Send me all the different options you can think of.

[@gayanthafernando9395]

Pls sir release the vedio how to create many to many relashionship form design

[@599CD]

The Extended Cut covers building forms for this: kzbin.info/www/bejne/hGWZnpp_prGLmKM

[@mehrasayat1643]

سلام آموزش های خوبی هستند ولی برای من که توی ایران هستم پرداخت هزینه امکان پذیر نیست. آیا راه دیگه ای برای دریافت آموزش های شما هست؟

[@599CD]

I don't know what forms of payment KZbin accepts, but I also accept Paypal, Venmo, CashApp, and others if you sign up through my web site at 599cd.com/Members.

[@stanTrX]

You never use table relationship,do you?

[@599CD]

Not unless I have a specific reason to. I talk about it more in 599cd.com/Relationships

[@syedabbas201]

Like done share done 👍 👌

[@599CD]

Sweet