Use the query wizard to create a crosstab query based on the SalesPerProduct query. The new...

Published: 25 February 2016
on channel: LEARN IT in 30 seconds by TEST4U
1,642
1

Use the query wizard to create a crosstab query based on the SalesPerProduct query. The new query will display the ProductID and Description fields as row headings and the myYear field as column heading. Also make sure the query calculates the sum of the values displayed in the myTotal field. Save the query as NewSales and close it.Want more? Then download our TEST4U demo from https://www.test4u.eu/en/demo
TEST4U provides an innovative approach to learning. Ignore the boring e-courses and use a new, interactive tool like 700 000 satisfied users did.
TEST4U is an automated test which cooperates with the actual applications and can be used to prepare the students for certification exams (e.g. Microsoft-Certiport, ECDL/ICDL, DIPLOMA etc.) and train and assess employees.
More on https://www.test4u.eu/en/demo


Watch video Use the query wizard to create a crosstab query based on the SalesPerProduct query. The new... online without registration, duration hours minute second in high quality. This video was added by user LEARN IT in 30 seconds by TEST4U 25 February 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,642 once and liked it 1 people.