Currently there is no Mode function in Access but you can use following SQL statement to return most frequently occurring value in certain field.
SELECT TOP 1 Test.Test FROM Test GROUP BY Test.Test ORDER BY Count(Test.Test) DESC;
To use this SQL statement,
Create table called 'Test' with atleast one field 'Test'.
Copy and paste above statement in query to get most occuring value in field.