Queries (Grade 11 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 queries in a database
Purpose of queries in a database
Bridge between user and database information
Two main types of queries
Two main types of queries
Select queries and Action queries
Function of select queries
Function of select queries
Retrieve and display info, perform calculations
Function of action queries
Function of action queries
Change database by adding, updating, or removing data
Two methods to create queries
Two methods to create queries
Query Design View and Query Wizard
Characteristic of Query Design View
Characteristic of Query Design View
Gives complete control, requires attention to detail
Characteristic of Query Wizard
Characteristic of Query Wizard
Guided approach, quicker and less error-prone
Using OR in query criteria
Using OR in query criteria
Shows records where either one condition or another is met
Using NOT in query criteria
Using NOT in query criteria
Excludes certain records from results
Using AND in query criteria
Using AND in query criteria
Finds records matching two or more conditions simultaneously