My test case for active archer training has devolved into a 'how can i mess things up?' and 'can they crosstrain?' sideshow to the very very very slowly growing wooden tower (trees just grow back ridiculously slowly on that map and i'm honour-bound to only properly trade with the elves). The one melee dwarf in the four-strong archery squad was recruited without any skills, so i've always kept an eye on him to make sure his happiness doesn't decrease too much. He shortly turned 'unhappy' when the long-dead remains of his sister were dug out of the ice, but remained 'content' otherwise.
But at one point, i got a 'xxx, Woodcrafter, is throwing a tantrum!' message. Looked at her and she was miserable in spite of a load of nice thoughts. The only bad thought was 'lost a pet recently'. Hmmm, i'm not allowing any animals for adoption, so it must be the resident cat lady. Looked through the message log and right enough, four named cats had died of old age. I instantly freed her and the mayor of any jobs and they soon headed off for a meeting. It didn't take long, and the unhappy woodcrafter was mollified and made a quick mental recovery. Funnily, after the meeting she had 'yelled at someone in charge and felt much better afterwards' _and_ 'talked to mother lately' - the mayor is her mother.
In the meantime, i issued war hammers as secondaries to the marksdwarf squad, and they're sparring like crazy, mostly using the crossbows of course.