resources from my career
There will inevitably be age grouping and age range requirements for many of your reporting needs, and the know-how to quickly and accurately calculate a patient's age is crucial to developing trust among your customers and colleagues.
Sometimes it is critical to calculate the age in your SQL language before the data even gets exported from the source.
But if you have the source data (and it includes the date of birth!) you can easily create age and age group calculations in Access or Excel. If you will be using Access to join tables and create multiple reports from the same data set, you should consider calculating the age (and establishing any age groups or ranges) within your Access queries. Alternatively, you can add your Age field "on the fly" using a quick formula in Excel, before you begin work on your final reporting.
This article explains how to compute a patient's age using each of these tools.