One of your hardest issues is building a table of "allowed" values.  In your
example, "black", "white", are very troublesome what if you want "Cherokee"
also.  In order to ever make sense of your data you will need to have such a
table that limits the choices.  Otherwise you end up with variations of
spelling and shades of classification that when grouped make no sense to
your 'termonology model'

As an interesting aside some datatabases even have up to 7 different groups
for gender:

Another issue is Age (a value that changes over time).  You will be better
off with DateOf Birth (a constant -- unless you live in California :>)

After you have the proper grouping you simply use a 'groupby' query.  Look
for the 'sigma' (sum) icon on the toolbar of the query builder and you group
by the fields of interest.  Start with getting just a simple group like
"male", "female"  after you see how that works you should be able to extend
that to get the combined grouping you desire.

You can then display the data from the group query in either a form or
report as desired.  In the report you can add a group header, footer and set
it to report a running sum or group sum.

Lots of luck on your project.

Ed Warren.