More Than 250
Courses
Developed through years of expertise, CPS HR teaches up-to-date skills applicable on the job.

Part 3: Retrieving Data from a Database using Structured Query Language (SQL)

Part Three focuses on querying a database and using the query results for reports in Excel. In this part you will write simple and complex queries to retrieve results from a database. You will study the structure of a well-designed database and query the database itself to investigate the data within its tables. You will query one database table, filter the results, and limit the results. You will query multiple related database tables and multiple unrelated database tables. Further, you will create calculations in queries that do not reside in the database and use previous VBA code to format the results into a cohesive report in Excel.