Hey everyone!
Am familiar with Excel but have never used Access before.
Am trying to create a workflow/ task management database for a village newsletter.
It basically has up to 20 contributors, each needing to contribute on different cycles
eg Mr A - Football Team - Weekly
Mrs B - School news - Every 2 weeks
Mr C - Council news -Monthly
Mr A - Cooking - Monthly
Mrs D - Features - Weekly
(a couple of people write on different subjects like Mr A with different frequencies)
As Editor, I was looking for a database that would flag up when the next articles on a topic would be due and by whom. Have done some background reading and also read that Access has firstly the advantage of contributors being able to email work in. Secondly I could potentially create a task manager to see progress
eg Mr A Football Team - Weekly - Due tomorrow - Being Composed
Mrs B - School news - Every 2 weeks - Due in 4 days time - With Editor
Am not 'techy' but have already gone down the road of learning CSS to help develop our website. Am now thinking I should learn Access too to develop this task manager/ work flow database, but am I overcomplicating things by using Access? Would other options maybe SharePoint or Smartsheet or Asana? I just don't want to go down the long(?) route of learning Access by myself if there were limited benefits compared to manually tracking by Excel. Equally, don't want to spend my life chasing 20 people to submit articles when Access could potentially automate some of it for me.
Grateful for any suggestions!
Many thanks!