Create a new query that will display the Description and Price fields from the Products table...

http://bit.do/dbL4V DBSchema secret sale page.
Create a new query that will display the Description and Price fields from the Products table and the FileRoot field of the ProductsPhoto table. Apply a criterion to the FileRoot field to retrieve all records containing a photo. Make sure that when the query is executed the Description and Price fields only (following this order) are displayed. Save the query as q1 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