CLASS VI - ICT - WEEK 6

FORMS:

• CAN HELP CHANGE THE ROW COLOR.

• CONTAINS MANY COMMANDS THAT ASSIST IN SCROLLING THROUGH RECORDS.

• ARE CREATED IN MS WORD.

• CAN HELP KEEP YOUR DATABASE ACCURATE AND CONSISTENT.

TABLE FORMATTING OPTIONS CONSIST OF:

• ROWS AND FIELDS.

• ALTERNATE ROW COLOR AND DATA TYPE.

• ALTERNATE ROW COLOR AND MODIFYING GRIDLINES.

• ALTERNATE GRIDLINES AND CELL SIZE.

CHANGE ALTERNATE ROW COLOR( SELECT THE PATH):

• HOME TAB

• CREATE TAB

• TEXT FORMATTING GROUP

• ALTERNATE ROW COLOR

MS ACCESS STORES ITS LISTS OF DATA IN:

• NAVIGATION PANE.

• TABLES.

• ONLY FIELDS.

• AN ATTACHMENT.

VALIDATION RULE:

• IS A RULE ABOUT THE TYPE OF DATA THAT CAN APPEAR IN THAT FIELD.

• IS A RULE ABOUT THE TYPE OF ROW COLOR THAT CAN APPEAR IN THAT RECORD.

• IS A RULE ABOUT THE GRIDLINES THAT CAN APPEAR IN THAT FIELD.

• IS A RULE ABOUT THE TYPE OF TABLE THAT APPEARS IN THE NAVIGATION PANE.

TO CUSTOMIZE WHICH GRIDLINES APPEAR:

• HOME TAB - RECORDS GROUP - GRIDLINES DROP DOWN ARROW.

• HOME TAB - FIND GROUP - GRIDLINES DROP DOWN ARROW.

• HOME TAB - TEXT FORMATTING GROUP - GRIDLINES RIBBON.

• HOME TAB - TEXT FORMATTING GROUP - GRIDLINES DROP DOWN ARROW.

SORTING AND FILTERING ARE TWO TOOLS THAT LET YOU:

• CHANGE THE DATA TYPE OF YOUR FIELDS.

• CUSTOMIZE HOW YOU ORGANIZE AND VIEW YOUR DATA.

• MANAGE FORMATTING THE TABLES..

• CREATE A RELATIONSHIP BETWEEN THREE TABLES.

IN MS ACCESS BOTH TEXT AND NUMBERS:

• CANNOT BE SORTED.

• CAN ONLY BE SORTED IN AN ASCENDING ORDER.

• CAN ONLY BE SORTED IN AN DESCENDING ORDER.

• CAN BE SORTED.

TEXT FORMATTING CAN BE FOUND IN THE:

• CREATE TAB

• TABLE TAB

• HOME TAB

• FIELDS TAB

NAVIGATION PANE CONSISTS OF ALL THE:

• OBJECTS IN YOUR DATABASE.

• FORMATTING TOOLS.

• ADD/DELETE OPTIONS.

• DATABASE TOOLS.