I'm sure people make posts like this frequently, but here comes one more.

I'm creating a database, and I first started out trying to modify a template
to suit my needs, but after spending umpteen hours on it, I've decided to
start over from scratch so that I can set it up to be the most efficient.
Having said that, I'm at a loss as to setting up my tables properly so that
they will have the proper relationships.

Here is what I need from my database, and maybe someone will be nice enough
to explain what I should have in which tables, how the relationships should
be set up, and then I can take it from there to create the forms, reports,
and queries.

The purpose of the database is to manage student data, but since it is for a
military school, there are some other things that I need to track that
civilian schools will not have.

Student Data:
Last Name
First Name
Middle Initial
Rank
DOB
SSN
Phone #
e-mail address
Home of Record (Address, City, State, ZIP)
Room #
Class # (there will be multiple students per class)
Status
Arrival Date
Graduation Date
Departure Date
Follow-On Orders
Notes
Archive (a checkbox that is used to determine if the student is a current
student or prior student)

PFA Data (Physical Fitness Assessment): (These are conducted every two weeks
and I need to track each students results of the assessment):
Date
Name
Age
Height
Weight
BCA
Sit-Reach
Sit-Ups
Sit-Up Score
Push-Ups
Push-Up Score
Run Time
Run Score
Composite Score

Barracks Data (I'm using a separate table so that I can create a combo box
on the forms that will show which rooms are available when I intake a
student, and then using the Archive field, I can remove a student from a room
and make the room available in the combo box):
Room #
Key #
Student Assigned


Any help in setting up the tables properly would be greatly appreciated.
Thanks in advance.