Structural questions

[Leviathan]

I am new to Access. I have been studying version 2016 for a few weeks. My question is a how to question. I have been tasked with creating a database that has these features.
We have 20 separate organizations with a total of 150 people. I would like to link the organizations with the people and also have a table that has personal and professional information of the people listed.
To access from the persons name the organization they belong to and from the organization name a list of people who work there. I would appreciate anyone who could point me in the correct direction.

[ranman256]

youll need some tables:

tOrg table
------------
OrdID (auto)
OrgName
addr
etc

tPersons table
-------------
PersonID (auto)
FirstN
LastN
OrgID (long) to show what org they work for.
addr
etc

Im sure youll need some more tables, but I dont know what youre doing with the people.

[orange]

You will learn a method to help you with database design by working through 2 or 3 of the tutorials listed below.
You have to do the work, but you will learn, and what you learn can be used with any database.

http://www.rogersaccesslibrary.com/T...lationship.zip
http://www.rogersaccesslibrary.com/T...nformation.zip
http://www.rogersaccesslibrary.com/T...getsDesign.zip

Spend 45 -60 minutes on a tutorial and learn/experience the technique.

Don't start by experimenting with Access --learn how to design a database first.
Good luck.