Once again I've run into uncharted waters. The captain suggested that it might be prudent to hail Ars, to see if they had any advice.I've got a report which requires data from the local database ...

While I have never used SQL Server Reporting Services, it seems to have a lot of advantages over an Access-based reporting tool.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

Want faster SQL queries? Here are nine best practices for writing SQL queries that work like a charm (or at least, like they should).

Make life easier for your Access users by building a parameter query that lets them search for specific text. Instead of fumbling around with wildcard characters, they can just enter the search ...