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

Published: 11 February 2014
on channel: LEARN IT in 30 seconds by TEST4U

152

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, duration hours minute second in high quality that is uploaded to the channel LEARN IT in 30 seconds by TEST4U 11 February 2014. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 152 times and liked it 2 visitors.