make a project on step to create a new table in design view [ with pictures]
Answers
Here's how to create a table in Design View.
Screenshot of Microsoft Access 2016 with the Table Design button highlighted
Click the Table Design Button
Click Table Design on the Ribbon (from the Create tab).
Screenshot of the blank table
The Blank Table
A blank table will appear in Design View.
You can see that field names are to be entered on top of each other down the left column, and their corresponding data types will be listed in the next column.
One of the big differences between Design View and Datasheet View is how they display the fields. Design View displays them as rows (down the left), whereas, Datasheet View displays them as columns (along the top).
Regardless, this doesn't change the design of the table. It's still the same table whether it was designed in Datasheet View or Design View.
Screenshot of the table in Design View with the field section highlighted
Enter the Fields
Enter a name for each field down the left column.
Select each field's data type from the next column.
You can also create a lookup table if required, by selecting Lookup Wizard... from the data type list.
Screenshot of the table in Design View with the field properties section highlighted
Enter the Field Properties
You can also change each field's properties in the bottom pane.
To do this, you need to click on the field first. Clicking a field updates the bottom pane with the properties for that field.
The properties displayed in the bottom pane are different, depending on the data type of the selected field.
Field properties can be used to do things like, specify a default value for the field, specify whether it's a required field, create an input mask, and more.
Screenshot of setting a primary key
Set a Primary Key
To set a field as a primary key, right click on the field and select Primary Key.