100 likes | 218 Views
4-H Blue Ribbon Youth Enrollment Software Training January 2004 on v2.4. Tape 3 Nancy Johnson Florida 4-H http://4h.ifas.ufl.edu/4hbr/ 4hrept@ifas.ufl.edu. 2004 Youth Enrollment Training Tape 3 of 3. BDE Administrator settings for Excel to open Youth Enrollment dBase exports.
E N D
4-H Blue Ribbon Youth Enrollment Software Training January 2004 on v2.4 Tape 3 Nancy Johnson Florida 4-H http://4h.ifas.ufl.edu/4hbr/ 4hrept@ifas.ufl.edu
2004 Youth Enrollment Training Tape 3 of 3 • BDE Administrator settings for Excel to open Youth Enrollment dBase exports. • YE can export to Ascii text or dBase format from various Queries • Create & View examples • use File|Create & View • don’t run under Help|Troubleshooting|SQL
2004 Youth Enrollment Training Tape 3 of 3 • Member/Leader by Club List Report • Mailing Labels • Special|Mailing Labels| -one per family/parent addr • Member Query|Action|Mailing Labels -primary club • Group Youth Enrollment • Case Examples- How do you enter these?
Query for General Volunteers over 19 yrs Select * From Youth2a Where Category=‘G’ and Age>19 Leaders’ Date of Birth needed to get Age Export to Dbase gave error msg Export to Ascii worked but no headings ->Excel
Group Youth • Youth Group Summary Report –by location • Youth Group Enrollment Form –on disk • Youth Group Detail Report -lengthy • Group Custom Reports need to be recreated with new Report Builder in v2.4
Youth Group Enrollment • ES237 menu| Group Youth Enrollments
Youth Group Enrollment • Projects only, >=6 hrs learning experience • Use Club code (not a youth group unit) • Delivery Modes - no Club or Independent 4-H • Special Interest/Short Term • Day Camp • Overnight Camp • School Enrichment • After School Child Care SACC
Typical Enrollment Cases on p.5-7 Group Youth Print screens show 1 class w/Duplicate youth Group Youth Enrollment forms to enter