A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Create Registration Form



 
 
Thread Tools Display Modes
  #1  
Old September 25th 08, 10:00 PM posted to microsoft.public.excel.worksheet.functions
Di_W
external usenet poster
 
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!
Ads
  #2  
Old September 25th 08, 10:25 PM posted to microsoft.public.excel.worksheet.functions
Sean Timmons
external usenet poster
 
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  
Old September 25th 08, 10:41 PM posted to microsoft.public.excel.worksheet.functions
Di_W
external usenet poster
 
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  
Old September 25th 08, 11:43 PM posted to microsoft.public.excel.worksheet.functions
Sean Timmons
external usenet poster
 
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  
Old September 26th 08, 01:50 PM posted to microsoft.public.excel.worksheet.functions
Di_W
external usenet poster
 
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  
Old September 26th 08, 10:52 PM posted to microsoft.public.excel.worksheet.functions
Sean Timmons
external usenet poster
 
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!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How May I create a form Pascale Excel Discussion (Misc queries) 2 February 7th 08 12:43 PM
Create a form in excel so I can enter data using Data>Form Lynn Excel Discussion (Misc queries) 2 February 14th 07 06: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 03: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 09:06 PM


All times are GMT +1. The time now is 05:47 PM.


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