Steps to create a Table in Microsoft Access:
- Make a New Table from Scratch
- To begin, go to the Create tab.
- Table can be found by clicking it.
- In Datasheet View, a new table appears. You can begin inputting data immediately, but you should first add some fields.
- Click the field header that says 'Click to Add.'
- A drop-down menu of data types emerges. To understand more about your selections, look at the table at the end of this lesson.
- Choose a field type. When choosing a field type, choose the smallest or shortest field that your data requires. If you only need to store a 2-digit number, for example, don't use Large Number.
- Fill in the field's name. To alter the name of a field header, double-click it and type the name of the field you want to use.
- Steps to add the remaining fields to your table are the same as before. When you're done adding fields, click Close and Yes to preserve your changes.
- Give your new table a unique name.
- Click the OK button.
Read More: Explain Queries In MS Access?