title: Ms Access table or Query
body: <p>I have a very interesting question.</p>
  
  <p>Let's say I have a table in MS Access which has the following 7 columns: </p>
  
  <pre><code>studentID, firstName, lastName, courseName, homework, grade, semester
  </code></pre>
  
  <p>The table takes 3 homework per semester and calculate the average of those homework for each student.</p>
  
  <p>Now I want to have another table/query that will have the same heading as the first table with an id pointing to the average (the average only) of the 3 homework for each student. But when you click on the id field of the second table it will open the first table with the details of the 3 homework for each student.</p>
  
  <p>I hope you understand my question. I have finished the first table, but I don't know how to go about the second table/query.</p>
  
  <p>Thanks in advance for your input.</p>