newbie help

  • Thread starter Thread starter Graham Warren
  • Start date Start date
G

Graham Warren

Hi. This is probably really easy for some of you, I've been lurking for a
little while and I'm amazed at your level of knowledge for a
'gettingstarted' NG. My problem: I need a database for the following
information: I have 25 pupils (surname/forename) who each do 7 modules of
course work in a year. I have this data in an excel file, but want to make
it into an access database so that I can extract each pupils name and
results on separate reports. I've managed to get the data itself into a
database of sorts by importing it from excel but can't figure out how to set
up a query such that I can generate individual reports for each child. Any
help would be much appreciated. Graham. I'm running Access 2000.
 
to make specific table design suggestions, we need some details. please post
back with details of your current table, as

TableName
FirstFieldName
SecondFieldName
etc.

and describe the process you're tracking in a little more detail.
 
Hi. This is probably really easy for some of you, I've been lurking for a
little while and I'm amazed at your level of knowledge for a
'gettingstarted' NG. My problem: I need a database for the following
information: I have 25 pupils (surname/forename) who each do 7 modules of
course work in a year. I have this data in an excel file, but want to make
it into an access database so that I can extract each pupils name and
results on separate reports. I've managed to get the data itself into a
database of sorts by importing it from excel but can't figure out how to set
up a query such that I can generate individual reports for each child. Any
help would be much appreciated. Graham. I'm running Access 2000.
Click to expand...

Excel is a spreadsheet, a good one; Access is a relational database.
They are *different* - a good Excel design will very likely be a
rather bad Access design, especially in a problem like this one!

I would say that you would need at least three tables:

Students
StudentID <Primary Key>
Surname
Forename
<other biographical information as needed>

Modules
ModuleNo <Primary Key>
Description

Coursework
StudentID <link to Students>
ModuleNo <link to Modules>
<information about this student/this module, e.g. date completed,
grade, comments>

There would be only one record in Students for each student, seven
records (currently) in the Modules table, and multiple rows in the
Coursework table.
 
Back
Top