If you want to rank data in MS Access, you will need to go into the query builder and in SQL view.

Code:
SELECT Table,
       (SELECT COUNT(T1.fieldyouwanttorank) 
          FROM
                 [Table] AS T1 
         WHERE T1.fieldyouwanttorank>= T2.fieldyouwanttorank) AS Rank 
FROM 
      [Table] AS T2 
ORDER BY fieldyouwanttorankDESC
This YouTube video also provides...