Re: New Database

Tech-Archive recommends: Fix windows errors by optimizing your registry

How would I keep track of how many semesters a student was active? For
example, I need to create an end of year report and need to know how many
semesters Jane Doe was active. I would need to know if Jane was active Fall,
Spring, and Summer, or just Fall Semester, or just Fall and Spring, etc.

I also want to track the total semesters Jane has been in the
program....Could be 8 semesters starting back from Fall 2009. Or it could be
Jane started Fall 2008 and stopped in Spring 2009 then returns in Fall 2009.

Would I then need a table for active students to track this data?

"June7 via AccessMonster.com" wrote:

Not sure you need another table for active students. This implies you would
delete the student from that table if no longer active. Deletion of records
is something to avoid. This data just seems like more info about the student
(like phone number). Add a field for the status entity that you can use to
filter for active students.

Kris D wrote:
I recently posted a question under general questions and was given great
advise, but I am still a little confused.

I need to create a database for a college program that I am responsible for.
I currently work out of many spreadsheets. A database will make my job
easier.

Here is what I currently do out of excel:

I have a workbook for an academic year (2009/2010) with three worksheets
(Summer 2009, Fall 2009, Spring 2010) within the workbook. Each work***
contains everything about an active student for that semester. I have
columns past "Z" which includes some of the following:

Date
Student ID
Case #
Last Name
First Name
Case Worker
Address
City
State
Zip
Phone Number
On TANF (yes/no)
FAFSA on file (yes/no)
Referral for Workstudy (yes/no)
Referral for Childcare (yes/no)
Referral for Bookloan (yes/no)

Now a student must meet with an academic counselor once a semester to be
active in the program each semester. For example, a student comes in for a
supportive service (bookloan) during Fall 2009; I would need to verify there
status in the program for the Fall 2009 semester prior to giving that
service.

I currently set up tables for the following:

Students (ID #, case #, name, address, phone number, and Date of birth)
Case Workers (ID #, name, phone number, and fax number)
Semesters (Semester/year, Start date, End date)

Not sure if I am on the right track. But I think I need another table that
is for active students? With fields like; Student, Semester/year, TANF
(yes/no), FAFSA (yes/no), Workstudy Referral (yes/no), Childcare Referral
(yes/no), Bookloan Referral (yes/no)....

Now that I have written all this information I don't think my database is
going to be a simple database? Sounds like this is going to take me months
to create. Any idea on how much it would cost for someone to create
something like this for me?

Thank you to anyone that can help.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200908/1


.

Quantcast