Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create Registration Form
I work for a non-profit company in the education field. I need to create a
registration form for about 100 of our field staff who are located across the US. They will register for required, optional and self-study (at home study) classes. The classes offered will be in their area of expertise (elem school reading, middle school math, bi-lingual reading, etc). So, we don't want a staff member registering for a middle school math class if their area of expertice is in elementary school reading. I was wondering 1) is Excel the program I should use and if not any suggestions; 2) is there a specific tutorial someone can suggest; 3) a template I might use; and/or 4) are there any suggestions at all? I will be forever grateful for your help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create Registration Form
Sounds like this may be best in Access since you'll probably get everything
you'll want in one place.. reporting and such, but can be done using Forms in Excel. there's a lot of possible ideas based on the below description. Definitely want the first selection to filter the second list. I'm sure other have links to all kinds of tutorials to make almost any form you could imagine. You can always do a Google search as well, or just browse through the templates you have. "Di_W" wrote: I work for a non-profit company in the education field. I need to create a registration form for about 100 of our field staff who are located across the US. They will register for required, optional and self-study (at home study) classes. The classes offered will be in their area of expertise (elem school reading, middle school math, bi-lingual reading, etc). So, we don't want a staff member registering for a middle school math class if their area of expertice is in elementary school reading. I was wondering 1) is Excel the program I should use and if not any suggestions; 2) is there a specific tutorial someone can suggest; 3) a template I might use; and/or 4) are there any suggestions at all? I will be forever grateful for your help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create Registration Form
Thanks for your suggestions. I tried searching online. It was very
cumbersome and I found nothing specific to my situation. I also was unable to determine from the tutorial descriptions whether it would cover this area. "Sean Timmons" wrote: Sounds like this may be best in Access since you'll probably get everything you'll want in one place.. reporting and such, but can be done using Forms in Excel. there's a lot of possible ideas based on the below description. Definitely want the first selection to filter the second list. I'm sure other have links to all kinds of tutorials to make almost any form you could imagine. You can always do a Google search as well, or just browse through the templates you have. "Di_W" wrote: I work for a non-profit company in the education field. I need to create a registration form for about 100 of our field staff who are located across the US. They will register for required, optional and self-study (at home study) classes. The classes offered will be in their area of expertise (elem school reading, middle school math, bi-lingual reading, etc). So, we don't want a staff member registering for a middle school math class if their area of expertice is in elementary school reading. I was wondering 1) is Excel the program I should use and if not any suggestions; 2) is there a specific tutorial someone can suggest; 3) a template I might use; and/or 4) are there any suggestions at all? I will be forever grateful for your help! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create Registration Form
Well, as a start, you'd make three tables at least.
First table has names and any descriptive info you'd want included - address, phone #, etc. Second table would have area of expertise and, perhaps a number system to assign to different courses. Then, third table has your numbers and courses, required optional and the lot. So, expertise in, say, phys ed is asigned a value of 3, courses related to phys ed would have values of 3 assigned as well. This is your key. Then, your form would request an input of names, select expertise from a drop-down. Once picked, a query searches for the associated value in the course list and you have a combo box that allows you to pick multiple required and/or optional corses. Save all of this into a fourth table, so in the end you have name, info, expertise, course name down the rows. May be somethign to just start building from the ground up and see how it looks. "Di_W" wrote: Thanks for your suggestions. I tried searching online. It was very cumbersome and I found nothing specific to my situation. I also was unable to determine from the tutorial descriptions whether it would cover this area. "Sean Timmons" wrote: Sounds like this may be best in Access since you'll probably get everything you'll want in one place.. reporting and such, but can be done using Forms in Excel. there's a lot of possible ideas based on the below description. Definitely want the first selection to filter the second list. I'm sure other have links to all kinds of tutorials to make almost any form you could imagine. You can always do a Google search as well, or just browse through the templates you have. "Di_W" wrote: I work for a non-profit company in the education field. I need to create a registration form for about 100 of our field staff who are located across the US. They will register for required, optional and self-study (at home study) classes. The classes offered will be in their area of expertise (elem school reading, middle school math, bi-lingual reading, etc). So, we don't want a staff member registering for a middle school math class if their area of expertice is in elementary school reading. I was wondering 1) is Excel the program I should use and if not any suggestions; 2) is there a specific tutorial someone can suggest; 3) a template I might use; and/or 4) are there any suggestions at all? I will be forever grateful for your help! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create Registration Form
Good morning, Sean. This is a great suggestion! There are times when I
approach a project with so many variables and my mind just freezes. I can't wait to start building my first attempt at this. Thank you so much for working with me. Diane "Sean Timmons" wrote: Well, as a start, you'd make three tables at least. First table has names and any descriptive info you'd want included - address, phone #, etc. Second table would have area of expertise and, perhaps a number system to assign to different courses. Then, third table has your numbers and courses, required optional and the lot. So, expertise in, say, phys ed is asigned a value of 3, courses related to phys ed would have values of 3 assigned as well. This is your key. Then, your form would request an input of names, select expertise from a drop-down. Once picked, a query searches for the associated value in the course list and you have a combo box that allows you to pick multiple required and/or optional corses. Save all of this into a fourth table, so in the end you have name, info, expertise, course name down the rows. May be somethign to just start building from the ground up and see how it looks. "Di_W" wrote: Thanks for your suggestions. I tried searching online. It was very cumbersome and I found nothing specific to my situation. I also was unable to determine from the tutorial descriptions whether it would cover this area. "Sean Timmons" wrote: Sounds like this may be best in Access since you'll probably get everything you'll want in one place.. reporting and such, but can be done using Forms in Excel. there's a lot of possible ideas based on the below description. Definitely want the first selection to filter the second list. I'm sure other have links to all kinds of tutorials to make almost any form you could imagine. You can always do a Google search as well, or just browse through the templates you have. "Di_W" wrote: I work for a non-profit company in the education field. I need to create a registration form for about 100 of our field staff who are located across the US. They will register for required, optional and self-study (at home study) classes. The classes offered will be in their area of expertise (elem school reading, middle school math, bi-lingual reading, etc). So, we don't want a staff member registering for a middle school math class if their area of expertice is in elementary school reading. I was wondering 1) is Excel the program I should use and if not any suggestions; 2) is there a specific tutorial someone can suggest; 3) a template I might use; and/or 4) are there any suggestions at all? I will be forever grateful for your help! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create Registration Form
Not a problem.
You'll find this forum is great once you start your project and get stuck on individual steps. Feel free to post again whenever you get stuck. We'll try to help any way we can! "Di_W" wrote: Good morning, Sean. This is a great suggestion! There are times when I approach a project with so many variables and my mind just freezes. I can't wait to start building my first attempt at this. Thank you so much for working with me. Diane "Sean Timmons" wrote: Well, as a start, you'd make three tables at least. First table has names and any descriptive info you'd want included - address, phone #, etc. Second table would have area of expertise and, perhaps a number system to assign to different courses. Then, third table has your numbers and courses, required optional and the lot. So, expertise in, say, phys ed is asigned a value of 3, courses related to phys ed would have values of 3 assigned as well. This is your key. Then, your form would request an input of names, select expertise from a drop-down. Once picked, a query searches for the associated value in the course list and you have a combo box that allows you to pick multiple required and/or optional corses. Save all of this into a fourth table, so in the end you have name, info, expertise, course name down the rows. May be somethign to just start building from the ground up and see how it looks. "Di_W" wrote: Thanks for your suggestions. I tried searching online. It was very cumbersome and I found nothing specific to my situation. I also was unable to determine from the tutorial descriptions whether it would cover this area. "Sean Timmons" wrote: Sounds like this may be best in Access since you'll probably get everything you'll want in one place.. reporting and such, but can be done using Forms in Excel. there's a lot of possible ideas based on the below description. Definitely want the first selection to filter the second list. I'm sure other have links to all kinds of tutorials to make almost any form you could imagine. You can always do a Google search as well, or just browse through the templates you have. "Di_W" wrote: I work for a non-profit company in the education field. I need to create a registration form for about 100 of our field staff who are located across the US. They will register for required, optional and self-study (at home study) classes. The classes offered will be in their area of expertise (elem school reading, middle school math, bi-lingual reading, etc). So, we don't want a staff member registering for a middle school math class if their area of expertice is in elementary school reading. I was wondering 1) is Excel the program I should use and if not any suggestions; 2) is there a specific tutorial someone can suggest; 3) a template I might use; and/or 4) are there any suggestions at all? I will be forever grateful for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How May I create a form | Excel Discussion (Misc queries) | |||
Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
I am trying to create a form in Excel. In my form I want to be abl | Excel Discussion (Misc queries) | |||
How to create a form to insert a hyerlink.VBA code to create a for | Excel Discussion (Misc queries) | |||
I need a customer registration form template for a small tax prep. | New Users to Excel |