ICT GRADE 6 - 14TH SEPTEMBER 2021

TO RESIZE A FIELD:

• CURSOR WILL BE PLACED OVER THE LEFT GRIDLINE IN THE FIELD TITLE.

• CURSOR WILL BE PLACED OVER THE GRAY AREA IN THE FIELD TITLE.

• CURSOR WILL BE PLACED OVER THE RIGHT GRIDLINE IN THE FIELD TITLE.

• CURSOR WILL BE PLACED OVER THE LEFT OF THE ROW.

A HIDDEN FIELD IS ______________ BUT IS STILL PART OF YOUR _________________.

• ACCESSIBLE - COLUMN

• INVISIBLE - DATABASE

• ACCESSIBLE - ROW

• INVISIBLE - GRIDLINE

TO HIDE A FIELD:

• RIGHT-CLICK THE FIELD TITLE - SELECT UNHIDE FIELDS

• RIGHT-CLICK THE FIELD TITLE - SELECT HIDE FIELDS

• RIGHT-CLICK THE RECORD ROW - SELECT UNHIDE FIELDS

• RIGHT-CLICK THE RECORD ROW - SELECT HIDE FIELDS

THE DARKER ALTERNATE ROW COLOR IN MS ACCESS 2016:

• GIVES THE DATA A VISUAL APPEAL.

• HIGHLIGHTS THE INDIVIDUAL FIELDS.

• MAKES YOUR TABLE EASIER TO READ.

• ALL OF THE ABOVE.

GRIDLINES ARE:

• ARE THE THIN LINES THAT APPEAR BETWEEN THE ROWS.

• ARE THE THIN LINES THAT APPEAR BETWEEN EACH CELL IN A FORM.

• ARE THE THIN LINES THAT APPEAR BETWEEN EACH COLUMN.

• ARE THE THIN LINES THAT APPEAR BETWEEN EACH CELL, ROW AND COLUMN OF A TABLE.

FORMS ENSURE THAT YOU ARE ENTERING THE ____________ __________ IN THE ______________ ______________ AND ________________.

• RIGHT DATA - RIGHT LOCATION - COLOR

• RIGHT FIELDS - RIGHT LOCATION - ORDER

• RIGHT DATA - ALTERNATE COLOR - FORMAT

• RIGHT DATA - RIGHT LOCATION - FORMAT

THERE ARE _____________ WAYS TO ADD A __________ RECORD:

• THREE - MODIFIED

• THREE - NEW

• THREE - COLORFUL

• ALL OF THE ABOVE

NUMBER DATA TYPE:

• USED FOR RECORDS CONTAINING NUMERIC DATA(EXCLUDING MONETARY).

• USED FOR FIELDS CONTAINING NUMERIC DATA(EXCLUDING MONETARY).

• USED FOR FIELDS CONTAINING NUMERIC DATA(INCLUDING MONETARY).

• USED FOR RECORDS CONTAINING NUMERIC DATA(INCLUDING MONETARY).

FIELD IS MORE THAN JUST A ____________; IT IS A WAY OF ______________ ________________ BY THE _____________ OF DATA IT IS.

• COLUMN - ORGANIZING INFORMATION - TYPE

• COLUMN - FORMATTING DATA - TYPE

• COLUMN - INSERTING COLOR - TYPE

• COLUMN - ORGANIZING INFORMATION - SIZE

ALL TABLES ARE COMPOSED OF:

• HORIZONTAL FIELDS AND VERTICAL RECORDS.

• HORIZONTAL COLUMNS AND VERTICAL ROWS.

• HORIZONTAL ROWS AND VERTICAL COLUMNS.

• HORIZONTAL CELLS AND VERTICAL FORMS