database for alumni group

pile-it Mark

Board Regular
Joined
Jan 10, 2006
Messages
125
I was asked to create a database for a High school band group. No, I don't do this for a living, i am not that skilled, the name says it all. I initially thought it would be an easy task. just use excell. i have a maintenance tracking program i thought i would modify the data entry page and then the interested parties could type away.

but since there will be over 40 years of names. figure 25 new kids a year, we are talking around 500 sets of information. about 90 columns wide. that would need to be able to searched by many variables. and then mail merged.

My initial idea that this is easy, has turned into the question " is this the right tool for the job?" i only know Excel and a little Word. should i learn something else?
i started a form. but now am stuck.

Thanks,

Mark
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

bethg7

Board Regular
Joined
Sep 9, 2009
Messages
77
I use the Form View in excel. 2007 doesn't have that button on the ribbon; but you can put it on the Quick Menu by going to the Window button and Excel Options.

With that data form view, you can search on ANY criteria from ANY column! Maybe that would work for you.

Beth
 

bethg7

Board Regular
Joined
Sep 9, 2009
Messages
77
I am so-so. I do my own programming in VBA; but since joining here, I am finding so very much that I just didn't know!!

There are real experts here though that help everyone work things out.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,531
Messages
5,625,369
Members
416,098
Latest member
jpmiralrio

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top