Query is a request for data. In this article we are going to explain how to create and modify query in Microsoft Access the easy way.

Use saved queries as opposed to SQL statements as the data sources for Access objects. The wizard will create a corresponding SQL Server object for each saved query.

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

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Juan will present examples, code and discuss using both SQL Server and Access to create business dashboards for companies looking to “Discover the power of their data”.