Search code examples
ms-accessms-officems-access-2013ms-access-2016

A form which will contain a list of students


I want to understand how to create a form which will look like a "table of something". Here is what I mean:

enter image description here

Above is a screenshot from "Students" template (one of built-in templates of Access 2016). So, you can add new students here and easily edit any information. For example, you can change the "Level" of the student from "1st Grade" to "2nd".

Well, I understand that this form is attached to "Students" table:

enter image description here

But when I try to create some form myself, it doesn't contain a list of students. Instead, it contain the details of only one student:

enter image description here

How I can achieve the desired result, shown on the 1st image?


Solution

  • Use for form's Default View Datasheet or Continuous Forms instead of Single Form you used.