CLASS VI - ICT - WEEK 5

TABLES ARE COMPOSED OF:

• HORIZONTAL COLUMNS AND VERTICAL ROWS.

• HORIZONTAL ROWS AND VERTICAL COLUMNS.

• HORIZONTAL ROWS AND VERTICAL TABLES.

• HORIZONTAL TABLE AND VERTICAL ROWS.

FIELDS AND ROWS:

• ARE ONE AND THE SAME THING.

• CANNOT BE RESIZED.

• ARE FOUND IN MS PPT.

• CAN BE RESIZED.

A HIDDEN FIELD IS:

• IS INVISIBLE BUT CAN NEVER BE A PART OF YOUR DATABASE.

• DELETED FROM THE TABLE.

• IS INVISIBLE BUT IS STILL PART OF YOUR DATABASE.

• DELETED FROM THE DATABASE.

ALTERNATE ROW COLOR CAN BE CHANGED FROM:

• HOME TAB - TEXT FORMATTING GROUP - ALTERNATE ROW COLOR DROP DOWN ARROW.

• HOME TAB - TEXT FORMATTING GROUP - ALTERNATE ROW COLOR RIBBON.

• HOME GROUP - TEXT FORMATTING TAB - ALTERNATE ROW COLOR DROP DOWN ARROW.

• HOME TAB - RECORDS GROUP - ALTERNATE ROW COLOR GROUP.

DATE/TIME DATA TYPE IS FOR:

• FIELDS CONTAINING NUMBERS.

• FIELDS CONTAINING DATE OR CURRENCY.

• FIELDS CONTAINING DATE OR TIME ENTRIES.

• FIELDS CONTAINING NUMBERS OR TIME ENTRIES.

DATABASE IS A COLLECTION:

• OF DATA ORGANIZED IN ONLY TWO CONNECTED LISTS.

• OF DATA ORGANIZED IN MANY CONNECTED LISTS.

• OF DATA ORGANIZED IN A SINGLE LIST.

• OF DATA ORGANIZED IN TEXT BOXES.

MS ACCESS STORES ITS LISTS OF DATA IN:

• FIELDS

• COLUMNS

• ROWS

• TABLES

TEXT DATA TYPE IS USED FOR FIELDS CONTAINING:

• ALPHANUMERIC DATA.

• TEXT AND NUMBERS.

• PURE NUMERIC DATA THAT IS NOT USED FOR CALCULATIONS.

• ALL OF THE ABOVE

FOUR OBJECTS OF DATABASES IN MS ACCESS:

• TABLES,QUERIES,FIELDS AND REPORTS.

• TABLES,QUERIES,FIELDS AND RECORDS..

• TABLES,QUERIES,FORMS AND REPORTS.

• TABLES,COLUMNS,FORMS AND REPORTS.

SHORTCUT FOR SAVE IS:

• CTRL + Z

• CTRL + A

• CTRL + V

• CTRL + S