Excel to Access; or both?

Have (complex) calculation worksheets. 1 sheet for data entry, 1 for 2 page report including all caculations. The report data entry is sent to another file for storage of all previous data. This file now has 7500 rows and 30 columns of records and takes a long time to retrieve and sort data. Should I try to duplicate the whole thing in Access (don’t know how to do this quickly), or should I leave the calculations and output reports in Excel, leaving only the records in Access? Can I then queryfrom Excel withouit having to open Access?