Help a Noob

[accessaws]

Hi, No experience with Access but work in IT and am a quick learner, I want to create a database where I would list a bunch of people (names, location, etc) and then have another list of hobbies. I want to link a person to their hobbies, whether it be one hobby from the list or multiple hobbies. I then need to report what certain individuals have what hobbies in common.
For example. Bob is linked to bowling, gardening, walking. Sue is linked to bowling, reading, Tom is linked to reading.


I run a report to see what Bob has in common with Sue, result is bowling. I run a report to see what Bob has in common with Tom, no results.
Access for MS Office 365

[Welshgasman]

You will need at least

tblPeople
tblHobby
tblPeopleHobby

The last table will link to the other two tables

I would use an autonumber field for each table and use them as your PK, FK

That should get you started.

[orange]

@accessaws

I recommend this tutorial from RogersAccessLibrary to assist with database design. Normalization.
He leads you through a procedure to go from a business description, to table and relationships to support your business.
You will learn and what you learn can be used with any database.