In Access, you have several options when creating tables. You can create a new blank table from scratch or set up tables that are connected to SharePoint lists. If you use one of the Quick Start options in the Application Parts to create a new database, tables with predefined fields will be created.
When selecting a field type, select the smallest or shortest field that is required for your data. For example, don’t choose Large Number if you only need to store a 2-digit number.
You can also create a table using an application part template. An Application Part is a predefined part of a database, such as a table or form, that you can quickly insert and use in a database.
Select Custom if you wish to specify your own fields or choose Existing SharePoint List if you want to link to a list that has previously been created on the SharePoint site.