How to Add a Calculation to a Query (Grade 12 NSC Matric Computer Application Technology): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What is the main purpose of adding calculated fields to a query?
What is the main purpose of adding calculated fields to a query?
To perform mathematical operations on data
When creating a calculated field, what punctuation follows the field name?
When creating a calculated field, what punctuation follows the field name?
A colon (:)
What must you use around field names in calculations for the database to recognise them?
What must you use around field names in calculations for the database to recognise them?
Square brackets
In calculation order of operations, what is calculated first?
In calculation order of operations, what is calculated first?
Brackets
How do you access formatting options for a calculated field?
How do you access formatting options for a calculated field?
Right-click field, select Properties
When does the AND operator return results?
When does the AND operator return results?
When both conditions are true
What does the IS NULL operator check for?
What does the IS NULL operator check for?
Empty fields
What does the asterisk (*) wildcard operator represent?
What does the asterisk (*) wildcard operator represent?
Multiple unknown characters
How many unknown characters does the question mark (?) wildcard represent?
How many unknown characters does the question mark (?) wildcard represent?
Exactly one
When operators are placed in the same criteria row, which operator is used automatically?
When operators are placed in the same criteria row, which operator is used automatically?
AND