can i copy an entire record row in access to another record?

[Mike]

Im building a database to hold exam records. Each exam has to be allocated to
one particular student. A student may take up to 50 of these small exams per
year. At present i have to create a new record row containing the student
name, DOB, sex, and student number and then the exam code. Is there a wayto
copy one record to the next row whichwill insert all the name dob data and
then just change the exam code ?

thanx

 

[Al Camp]

Mike,
Sounds like you've built a "flat" database. Every time a student takes an
exam. you create a completely new record.
A "realtional" database allows you to avoid that problem.

You should have a Students table vs an ExamsTaken table set up as a "One
to Many" relationship... one student... many exams, linked by a common,
unique field value such as StudentID.

Imagine a form where the main form is based on a Student,,, and a
continuous subform on that form that would contain all the ExamTaken info.
Each time a student takes an exam, you would go to that students record and
just add another ExamID to those exams associated to that particular
student.

This is how data in the 2 tables would look.

Student ExamsTaken
ID Name ID Exam
3 Bob 3 A12
3 A13
3 C1
3 C5
4 Alice 4 A12
4 A21
4 C5

Believe me... this is the way to go, and you'll spend a lot less time
updating a database that's properly designed. Also, it will be so much
easier to get the data "out" of a properly designed database... reports,
queries... etc.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions