ICT - GRADE 6 - 7TH SEPTEMBER - 2021

MS ACCESS IS A:

• MERGE OF FIELDS AND RECORDS

• CREATION AND MANAGEMENT PROGRAM

• A ROBUST NUMERIC PROGRAM

• A NON-RELATIONAL DATABASE

IN THE NAVIGATION PANE:

• OBJECTS ARE SORTED BY TYPE

• ONE CAN OPEN, RENAME AND DELETE OBJECTS

• ALL OF THE ABOVE

• NONE OF THE ABOVE

WHAT IS THE ONE THING THAT ACTUALLY SETS DATABASES APART FROM VARIOUS OTHER WAYS OF STORING DATA:

• NAVIGATION PANE

• OBJECTS

• CONNECTIVITY

• TABLES

DATABASE IN MS ACCESS ARE COMPOSED OF FOUR OBJECTS:

• TABLES,QUERIES,FIELDS AND RECORDS

• TABLES,PANE,FORMS AND REPORTS

• TABLES,QUERIES,FORMS AND CONNECTIVITY

• TABLES,QUERIES,FORMS AND REPORTS

ALTHOUGH MS EXCEL IS GOOD AT ORGANIZING AND STORING NUMBERS,MS ACCESS IS:

• FAR ROBUST AT CREATING FIELDS AND RECORDS.

• FAR ROBUST AT HANDLING NON-NUMERIC DATA.

• FAR ROBUST AT HANDLING BOTH NUMERIC AND NON-NUMERIC DATA.

• FAR ROBUST AT CREATING TABLES.

IN MS ACCESS TABLES ARE ORGANIZED INTO:

• GRIDLINES AND ROWS.

• VERTICAL ROWS AND HORIZONTAL COLUMNS.

• VERTICAL COLUMNS AND HORIZONTAL ROWS.

• FIELDS AND GRIDLINES.

____________ ________________ , THE BACKGROUND OF EVERY OTHER ROW IN AN MS ACCESS TABLE IS FEW ________________ _______________ THAN THE ________________ OF THE REST OF THE TABLE.

• BY DEFAULT - SHADES LIGHTER - BACKGROUND

• BY DEFAULT - SHADES DARKER - BACKGROUND

• BY DEFAULT - SHADES DARKER - COLUMN

• BY DEFAULT - SHADES DARKER - DATA

CHANGE THE ALTERNATE ROW COLOR:

• TABLE TAB - TEXT FORMATTING GROUP - ALTERNATE ROW COLOR

• HOME TAB - CLIPBOARD GROUP - ALTERNATE ROW COLOR

• CREATE TAB - TEXT FORMATTING GROUP - ALTERNATE ROW COLOR

• HOME TAB - TEXT FORMATTING GROUP - ALTERNATE ROW COLOR

A HIDDEN FIELD:

• IS INVISIBLE AND PREMANENTLY REMOVED FROM THE DATABASE.

• IS INVISIBLE BUT IS STILL PART OF ONE'S DATABASE.

• IS INVISIBLE BUT CAN BE SEEN IN THE NAVIGATION PANE.

• IS INVISIBLE BUT CAN STILL BE FOUND IN A FORM.

HOW MANY WAYS CAN ONE ADD A NEW RECORD IN MS ACCESS?

• 2

• 3

• 4

• 1