Welcome to the forums.

You could use linked tables and create some queries that are the
recordsource for some reports. Data remains in SQL but is
accessable from access like it was in access.

For more, try searching the forums. Allot of examples.