Is This Possible...two Results From Same Table?

I'm doing a table for Future Business Leaders of America competitive events assignments.

I want the same table to hold Name and Event Name and be able to sort

However, I want the database to be able to sort to tell me each event that a person has, and at the same time, how many people are in each event. Presently, I have to switch between databases.

On one table, the event name is the primary key, and on the other the person's name is the primary key.

For the event name table, categories are "Event Name" , "Participant 1" , "Participant 2", "participant 3", etc.

For the Person's name table, Categories are "Name", "event 1" , "event 2", "event 3", etc.

I want to have ONE database that will sort lists for all participants in each event AND that will sort into a report or form so that I can inform participants of their events.

How can I do this?

I probably was not very clear, so ask lots of questions if you're unsure.

THANKS A LOT!!