Reports and Queries in Databases (Grade 12 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Purpose of calculated fields in queries
Purpose of calculated fields in queries
Perform mathematical operations on existing data
Syntax to create a calculation in a query
Syntax to create a calculation in a query
Field name followed by colon, then formula
What must surround field names in calculations
What must surround field names in calculations
Square brackets
Mathematical operators for calculations
Mathematical operators for calculations
Plus (+), minus (-), divide (/), multiply (*)
When AND operator returns results
When AND operator returns results
When both conditions are true
When OR operator returns results
When OR operator returns results
When at least one condition is true
What IS NULL operator checks for
What IS NULL operator checks for
Empty fields
What asterisk (*) wildcard represents
What asterisk (*) wildcard represents
Multiple unknown characters
What question mark (?) wildcard represents
What question mark (?) wildcard represents
Exactly one unknown character
Criteria placement: same row vs different rows
Criteria placement: same row vs different rows
Same row = AND; different rows = OR