Have a legacy Access database, small but well formed. The database manages information for a project with a short finite life cycle (oil & gas pipeline projects, one to three years and done.)
Want to use SharePoint 2013 Online (we're enterprise version) particularly for data entry. Best outcome is that we use a split design, where access tables are in SharePoint.
Best way to form the question is: What is best practice direction to tackle the task at hand of migrating the database and developing rich SharePoint forms to do data entry and manage data views?