I understand that Access 2010 has a multivalued fields function, but my supervisor has told me not to use those.
Essentially I have EVENTS(eid,title,date,presenters) and PEOPLE(pid,fname,lname,role)
An event can have any number of presenters. I currently have imported the rawdata from excel...