Access

Hi Matthew, Thank you for your post, welcome to the forum, in answer to your question.
Access is a database which will store, sort and filter data, Excel is a 'number cruncher' they both have overlapping functions, ie Excel can contain a 'flat file database' and Access can undertake calculations on field data.
However the point at which you decide to move records from Access to Excel would be when Access can no longer provide you with the ease of creating calculations that you can find in Excel.
However why not consider this option; create and calculate your requirements in Excel, but link the table to your Access Database.
To link an Excel Table to an Access Database you could search this forum to find the steps necessary, or come back and I will provide. I hope that helps, best regards Pete