The purpose of Design View is tocreate or set up a table structure with data types and field properties.In Design View, we can add new fieldsto a table; set indexes, assign primary keys and data types as well asedit the field properties. So, if you are wanting to edit any structuralchanges to the table, Design View isthe view to navigate to. Data cannot be added in
- We will continue with SSGSchoolAdmin.accdb. Click onthe Create | Table Design icon.
- The new table opens up in DesignView, after which you can enter field names into the relevantcolumns. The ID field name is insertedautomatically for you.
- Enter StudentName as the second field heading, thenchoose the short text data type from the drop-down list.
- Save the table structure by clicking on the
Save icon. EnterEnrolledStudentsTbl as the table name. Note that the ribbonhas changed to reflect the Design Viewicons and Table Tools contextualmenu.