How to find farms run by women in a query?

Question

Microsoft Access

There is a database.

The task is to
find farms in the Elanetsky district, which are run by women.
I found the farms of the Elanetsky district. But I don’t know how to find who are led by women. As a gender, only First Name, Last Name are not indicated in the database. Please tell me how can this be done?

Answer 1

In a simple way - no way. It is not easy to distinguish a male name from a female one.
You can, of course, use an additional table (of the NAME:SEX type), by which to search - a male or female name, but this is not very fast and convenient, and it does not give a guarantee.

Answer 2

As an option - take the name and patronymic, and look for the endings -a (for names) or -vna (for patronymics). And disassemble the rest by hand.