I'm sure that LiveCycle Designer can create forms to meet all of those requirements. Unfortunately I personally don't have the time to write a specific guide for all of those tasks but perhaps someone on the forum might.
Instead I'd recommend taking a look at "Creating Dynamic Forms with Adobe LiveCycle Designer", it's a good book which should take you to a fairly advanced level creating and scripting data bound forms. It's not too long either, which is a bonus.
It sounds to me like you know what you want but do not have the skills - yet, to do the development. I would suggest you look on the Adobe website for some help developing your form(s) from and Adobe Solutions Partner.