title: Storing Multiple choice answers of a Module Options Form in a Microsoft Access Database
body: <p>I currently am trying to work out how to create a relational database for a University Module Options form. First you enter your student ID, Name, Surname and select your degree programme e.g. Human Resource Management then choose multiple modules through the form using checkboxes until the total credits for each semester for each programme is chosen.</p>
  
  <p>However in choosing multiple modules and in being a relational database design i am unsure of how to store these multiple answers in the Student Options table as shown below.</p>
  
  <p>I currently have the tables of</p>
  
  <p><strong>Table: Student</strong>
  Field Names:
  Student ID (primary key)
  Name
  Surname</p>
  
  <p><strong>Table: Programme</strong>
  Programme (primary key)
  Semester 1 Credits (different programmes allow different amount of credits )
  Semester 2 Credits  (different programmes allow different amount of credits )</p>
  
  <p><strong>Table: Module</strong>
  Module ID (primary key)
  Module Name
  Credits
  Prerequisite</p>
  
  <p>The last table is one i am struggling with as after the modules are chosen from the form they will be stored in this table and currently have this...</p>
  
  <p><strong>Table: Student Options</strong>
  Student ID (primary key)
  Programme (link to programme table)</p>
  
  <p>However i am unsure what fields to have to store them in without being too cluttered and still having a link to the modules table as shown below which are all stored individually.</p>
  
  <p>Does my modules table need to have a relationship link to the student options table to be a relational database ?</p>
  
  <p>How would i store the multiple modules chosen into the student options form?</p>
  
  <p>Thanks</p>