does anyone know whether excel macros will run properly in access?
You can’t run Excel macros inside Access because the object models are completely different, but you can run Excel macros from Access using Automation code. You can link Excel spreadsheets to Access as a first measure. However, if you want snappy performance in Access you will need to import the data and run it using the native tables. Best bet is to build the table structure in Access, build the user interface using Access forms, and then split the database. That way you separate logic (of which every user has a copy) from data (kept in one location).
