I have multiple activities and multiple categories, i need a form that allows entry of this data

Yes, its a data entry form, however, I am lost on how to construct it so that all activities and the categories they belong to (everything in the picture) can have a numerical value. Would I just create a table for every activity and every category and then relate them to one another?

There will be a single table of Categories and a single table of Activities and then a middle or join table of Activity categories.  That is the table which will have two parents.

I remember from my past QB knowledge that I have done this before, but its been awhile. So I create one table of the 10 activities, and one table of 10 categories, and both tables would be children to the parent intermediary table of activity categories? 
I don't have access to my previous apps to see how I constructed this so I'm still a  bit lost.
By doing the proposed method, the user would utilize the intermediary table and select an activity and select a category and then input the numerical value into that selection. This would seem to work.

You have the setup backwards. The parents are the two tables of the Activities and the Categiries.

The join table of Activity Categiries is the child of both.

Ahh thank you! This worked like a charm!