☰ Contents · Computing

Calculations in queries

Lessons 32 · 1 lessons · N. I. Taylaqov (general editor), A. B. Akhmedov, M. D. Pardayeva, A. A. Abdug‘aniyev, U. M. Mirsanov. Informatics and Information Technologies, Grade 10, 1st edition. “Extremum-Press”, Tashkent, 2017
Answers are for parents and teachers.
1
A notebook costs 4000 so‘m and the quantity is 8. Find [Price]*[Qty].
2
What is the total with 12% VAT for 32000 so‘m?
3
What does IIf([Mark]>=3,"Pass","Fail") give for Mark = 2, 3, 5?
4
What is Avg in a group with the marks 5, 4, 3?
5
Why is Log(x)/Log(10) written for the base-10 logarithm in Access instead of Log(x)?