How can I set up a student data base using word 2003?

  • Thread starter Thread starter gsuskid23
  • Start date Start date
G

gsuskid23

I am a music teacher and would like to set up a data base for my students
including information regarding - exams, competitions and results. Names,
ages, birthday reminders, parents details and goods and services delivered. I
use Microsoft Office 2003. Any help would be appreciated. Many thanks.
 
Decide what you want to keep track of and put each piece of information into
separate cells. And one row per entry--don't put the data for one person on
multiple rows.

Try to keep your data on a single worksheet. If you thought that you'd want
multiple worksheets (one for each class), think about adding another indicator
column to show the Class ID.

First names in one cell, last names in another.

Addresses are multiple columns:
Street address 1
street address 2
City
state
zip (zip+4)

Use real dates for birthdays if you can--include the month, day and year.

And save often while you're building the workbook. You could even File|SaveAs
using a different name for the workbook. Then when (not if!) you screw it up,
you can go back to the previously saved workbook.

You'll be able to apply data|filter|autofilter to your data base and see/hide
just the stuff you want visible/hidden.

And even use MSWord to create letters/envelopes using MailMerge.
 
Dave Peterson said:
Decide what you want to keep track of and put each piece of information
into
separate cells. And one row per entry--don't put the data for one person
on
multiple rows.

Try to keep your data on a single worksheet. If you thought that you'd
want
multiple worksheets (one for each class), think about adding another
indicator
column to show the Class ID.

First names in one cell, last names in another.

Addresses are multiple columns:
Street address 1
street address 2
City
state
zip (zip+4)

Use real dates for birthdays if you can--include the month, day and year.

And save often while you're building the workbook. You could even
File|SaveAs
using a different name for the workbook. Then when (not if!) you screw it
up,
you can go back to the previously saved workbook.

You'll be able to apply data|filter|autofilter to your data base and
see/hide
just the stuff you want visible/hidden.

And even use MSWord to create letters/envelopes using MailMerge.
Click to expand...

If using MS Office why not try the following:

Classroom Management Database:

http://office.microsoft.com/en-gb/templates/TC010184071033.aspx?CategoryID=CT101426031033&av=ZAC000

All you need is MS Access 2003.

HTH
 
Back
Top