Prev: Product table
Next: open query from Switchboard
From: Nantika on 22 Apr 2010 00:39
I am using the education template for a vocational training school.

I have put all the information into the profile for a student. I want to be
able to list all the courses that one student has taken. I also want to be
able to pull up a roster per course from the student profiles.

I have been able to pull up a report course roster but now a couple of
students are returning to take different course. I can list more on the
profile page but I don't think that is the only thing I can do.


Enjoy every day!
From: John W. Vinson on 22 Apr 2010 01:07
On Wed, 21 Apr 2010 21:39:01 -0700, Nantika
<Nantika(a)discussions.microsoft.com> wrote:

>I am using the education template for a vocational training school.
>
>I have put all the information into the profile for a student. I want to be
>able to list all the courses that one student has taken. I also want to be
>able to pull up a roster per course from the student profiles.
>
>I have been able to pull up a report course roster but now a couple of
>students are returning to take different course. I can list more on the
>profile page but I don't think that is the only thing I can do.
>
>
>Enjoy every day!

Do you have a question, Nantika?

Most of the volunteers here don't have the "education template" and I
certainly don't have time to search it out, download it, and dig through
Microsoft's design to interpret it. I'm sure that the tables in the template
have the data you need to do this, or can be modified to do so; but you'll
need to understand the structure of the tables, how the tables are related,
and create appropriate queries to get the results you want. Microsoft cannot
think of everything you might want to do and include it! Think of the template
as a starting point, and Access as a toolbox; if you need a particular report
use the toolbox to build one.

If you need help doing so please post a description of the tables, their
relationships, and what you want to see.
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Product table
Next: open query from Switchboard