I am trying to make a very large list of records with about 1,000 items or more added monthly, and I was told that it would be better to use an Access table instead of a Sharepoint list for so many items. It is a list of servicings for devices, and we already have the devices in a Sharepoint list that is continuously updated. Is there any way to pull up the devices from the Sharepoint list from an Access form, for easier data entry? I know how lookups look in Sharepoint but relationships in Access are more complicated. Is this even possible?
There is a datasheet view that you may be interested in. Every SharePoint List has a datasheet view that acts like Access or an Excel spreadsheet so that data sorts in a row/column format.