VB app using MS Access reports for SQL Server

We (students) are developing a VB application that uses SQL Server as a backend database. What would be the best way to get MS Access or MS Excel reports from SQL Server? Are there any good resources (books, etc) that would explain this?

Thanks,
Steve

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.