I would start with two tables.
tNames
--------
nID PK (Autonumber)
First
Last
tPartners
----------
rID PK (autonumber)
nID FK (long Integer)
pID FK (long Integer)
qtr (integer)
Create a Query
Code:
SELECT tNames.First, tNames.Last, tPartner.qtr,pNames.First, pNames.Last
FROM (tNames INNER JOIN tPartner ON tNames.ID = tPartner.nID) INNER JOIN tNames AS pNames ON tPartner.pID = pNames.ID
WHERE (((tPartner.qtr)=[Insert Quarter]));;
You can import your names from Excel to Access using the import wizard. This will get you started. You should probably build forms for data input once you have your tables and queries set.
You might want to start with these two short reads to help you understand what is happening what you need to do. Access has a very steep learning curve.
http://www.deeptraining.com/litwin/d...aseDesign.aspx
http://www.accessmvp.com/strive4peace/
Good luck. Post back with questions on specific issues as you move forward.