Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 25th 08, 10:00 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 8
Default 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   Report Post  
Old September 25th 08, 10:25 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1,696
Default 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   Report Post  
Old September 25th 08, 10:41 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 8
Default 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   Report Post  
Old September 25th 08, 11:43 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1,696
Default 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   Report Post  
Old September 26th 08, 01:50 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 8
Default 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   Report Post  
Old September 26th 08, 10:52 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1,696
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How May I create a form Pascale Excel Discussion (Misc queries) 2 February 7th 08 01:43 PM
Create a form in excel so I can enter data using DataForm Lynn Excel Discussion (Misc queries) 2 February 14th 07 07:35 PM
I am trying to create a form in Excel. In my form I want to be abl AngelaD Excel Discussion (Misc queries) 2 January 5th 07 04:16 PM
How to create a form to insert a hyerlink.VBA code to create a for karthi Excel Discussion (Misc queries) 0 July 5th 06 11:26 AM
I need a customer registration form template for a small tax prep. Christi Nichols New Users to Excel 1 January 5th 06 10:06 PM


All times are GMT +1. The time now is 07:30 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017