I need a sample of Students Database, 2003 Format Please.

[Adnan]

I have Office 2003 installed on my machine. I need a copy of Students
Database Sample downloaded from
http://office.microsoft.com/en-us/templates/TC012253551033.aspx?pid=CT101428361033
and can not view it since I do not have Office 2007. Could anyone out there
with Office 2007 download it, convert it to Office 2003 and email it to me
please?

Thank you,
Adnan

 

[Brendan Reynolds]

I have Office 2003 installed on my machine. I need a copy of Students
Database Sample downloaded from
http://office.microsoft.com/en-us/templates/TC012253551033.aspx?pid=CT101428361033
and can not view it since I do not have Office 2007. Could anyone out
there
with Office 2007 download it, convert it to Office 2003 and email it to me
please?

Thank you,
Adnan

It uses attachment fields, which are new in Access 2007, so converting it to
any earlier version would be a non-trivial task. It is, in any case,
extremely limited, as it has a one-to-many relationship between students and
guardians, a relationship which really needs to be many to many (a parent or
guardian may well have more than once child attending the same educational
institution).

 

[Adnan]

Brendan, thanks for you reply... Are you aware of such sample on 2003 format?
I need to study a little more these relations. I found a good explanation on
link below but can not implement it on forms, I guess I cannot tell which is
Autonumber or primary key etc… (I'm missing something...)

http://www.databasedev.co.uk/student_courses_data_model.html

Thanks for your time and help,
Adnan

 

[Jeanette Cunningham]

If you are looking for a student database, there is a working sample
database that comes with the book by John L Viescas called Building
Microsoft Access Applications (for A 2003).

Jeanette Cunningham

 

[Brendan Reynolds]

Brendan, thanks for you reply... Are you aware of such sample on 2003
format?
I need to study a little more these relations. I found a good explanation
on
link below but can not implement it on forms, I guess I cannot tell which
is
Autonumber or primary key etc… (I'm missing something...)

http://www.databasedev.co.uk/student_courses_data_model.html

There's an Access 2003 "Classroom Management Database" at the following URL,
but I have not looked at it ...

http://office.microsoft.com/en-us/templates/CT101426031033.aspx

Rebecca Riordan (a former Access MVP) has a great explanation of
many-to-many relationships, including how to build forms to display and edit
the data, in her book "Designing Relational Database Systems".

 

[Adnan]

Jeanette,

I do appreciate your response on this post. I have just ordered this book
and hope this explains/meets my needs.


Brendan,

Do appreciate you post, too. I downloaded the sample and am now studding it.


Have an awesome day,
Adnan