Quick Ways to Create or Populate Lists on a SharePoint List
1. Start Microsoft Office Access and open a database by clicking the New Database icon or selecting an existing database.
2. Create a new list.
a. Click Create, click SharePoint lists, and then select whichever list is appropriate.
b. Enter the site address of the Microsoft SharePoint site that you want to use, and then give the list a name.
3. Fill in the data on the data entry page, or populate it from another source by using the data import features of Access.
4. Save the content in Access.
5. Go to your SharePoint site, click Lists, select the list you just created, and it will already have been published.