I'm new to Access and I'm trying to create a table to store students' information.
There is a "Birthday" field and an "Age" field in the table "Student".
I want to derive the "Age" value from the "Birthday" value. So that each time I just need to input the value of "Birthday" and then the "Age" value can be generated automatically.
However, I tried hard but couldn't find a solution.
Can anybody help me with this problem?

Thank you.

You do not need to store Age since it can be calculated from BirthDate. Think about it. The day after you store the age of a person it could be incorrect! This is one of the easiest to understand examples of why storing calculated fields leads to data anomolies. If you don't know how to calculate age, search here. There are many threads on the topic.