ICT - GRADE 6 - 21ST SEPTEMBER - 2021

________________ AND _______________ ARE TOOLS THAT LET YOU ORGANIZE YOUR ______________ .

• FILTERING - SORTING - FORMS

• SORTING - FILTERING - DATA

• FILTERING - SORTING - NUMERICS

• SORTING - FILTERING - TEXT

BY ________________, THE BACKGROUND OF EVERY OTHER ___________ IN AN MS ACCESS ________________ IS A FEW SHADES ________________ THAN THE BACKGROUND OF THE REST OF THE _________________.

• DEFAULT - FIELD - TABLE - DARKER - TABLE

• DEFAULT - COLUMN - TABLE - LIGHTER - TABLE

• DEFAULT - ROW - TABLE - DARKER - TABLE

• DEFAULT - FIELD - TABLE - LIGHTER - TABLE

WHEN YOU SORT DATA:

• YOU ARE PUTTING THE TEXT IN ORDER.

• YOU ARE PUTTING THE DATA IN ORDER.

• YOU ARE PUTTING THE NUMBERS IN ORDER.

• YOU ARE PUTTING THE FORMS IN ORDER.

ASCENDING ORDER AND DESCENDING ORDER MEANS:

• GOING UP - GOING DOWN

• GOING DOWN - GOING UP

• LARGEST TO SMALLEST - SMALLEST TO LARGEST

• LOGICAL ORDER - NUMERIC ORDER

FILTERS ALLOWS YOU TO:

• VIEW ONLY THE RECORDS.

• VIEW ONLY THE FIELDS.

• VIEW ONLY THE DATA YOU WANT TO SEE.

• VIEW ONLY THE FORMS.

WHEN YOU CREATE A _______________, YOU SET _______________ FOR THE _____________ YOU WANT TO DISPLAY.

• DATA - FILTER - CRITERIA

• DATA - CRITERIA - FILTER

• TABLE - CRITERIA - DATA

• FILTER - CRITERIA - DATA

_______________ ENSURE THAT YOU ARE ENTERING THE ___________ DATA IN THE ______________ LOCATION AND ________________.

• FORMS - NUMERIC - RIGHT - RIGHT - FORMAT

• FORMS - TEXT - RIGHT - RIGHT - FORMAT

• TABLES - RIGHT - RIGHT - FORMAT

• FORMS - RIGHT - RIGHT - FORMAT

_______________ HELPS TO KEEP YOUR DATABASE ____________________ AND CONSISTENT.

• TABLES - ACCURATE

• FORMS - ACCURATE

• SORTING - ACCURATE

• FILTERING - ACCURATE

DATA WITHIN A HIDDEN FIELD CAN STILL BE ______________ FROM ______________, QUERIES, REPORTS AND ANY RELATED _______________.

• SORTED - FORMS - TABLES

• FILTERED - FORMS - TABLES

• ACCESSED - FORMS - TABLES

• GROUPED - FORMS -TABLES

FILTERING DATA LETS YOU ___________ UNIMPORTANT ___________ AND ___________ ONLY ON THE DATA YOU ARE ____________________ IN.

• HIDE - TERMS - FOCUS - INTERESTED

• GROUP - DATA - TABLES - INTERESTED

• HIDE - DATA - FOCUS - INTERESTED

• GROUP - DATA - FOCUS - INTERESTED