IGCSE ICT (0417) P2 data manipulation using Access

TO SHOW RECORDS WHICH CONTAIN A PARTICULAR WORD IN A
FIELD, TYPE THAT WORD IN THE CRITERIA ROW AS ILLUSTRATED
IN THE FOLLOWING:
TO SHOW ONLY RECORDS IN WHICH
THE SKILL LEVEL IS “BEGINNER”
TYPE “BEGINNER” IN THE
CRITERIA ROW

TO SHOW ALL RECORDS THAT DO NOT CONTAIN A
PARTICULAR WORD IN A FIELD TYPE “NOT” FOLLOWED
BY THE WORD AS ILLUSTRATED BELOW:
TO ALL RECORDS IN THE SKILL LEVEL
FIELD ASIDE FROM “BEGINNER”
TYPE ‘NOT “BEGINNER” ’ IN THE
CRIETRIA ROW

TO SHOW ALL RECORDS THAT BEGIN IN A PARTICULAR
WORD OR VALUE IN A FIELD TYPE ‘*’ AFTER THE WORD
OR VALUE
USE BEGINS WITH “LAND BOARD”
TYPE ‘LAND BOARD*’ IN THE
CRITERIA ROW

TO SHOW ALL RECORDS THAT END IN A PARTICULAR
WORD OR VALUE IN A FIELD TYPE ‘*’ FOLLOWED BY
THE WORD
USE ENDS WITH “LAND BOARD”
TYPE ‘*LAND BOARD’ IN THE
CRITERIA ROW

TO SHOW ALL RECORDS THAT CONTAIN A PARTICULAR WORD OR
VALUE IN A FIELD (EITHER IN THE BEGINNING, END OR MIDDLE)
TYPE ‘*’ BEFORE AND AFTER THE WORD IN THE CRITERIA
TO SHOW ALL RECORDS THAT CONTAIN
“LAND BOARD” ANYWERE IN USE
TYPE ‘*LAND BOARD*’ IN THE
CRITERIA ROW

IGCSE ICT (0417) P2 data manipulation using Access

More Related Content

What's hot

Viewers also liked

Similar to IGCSE ICT (0417) P2 data manipulation using Access

Recently uploaded

IGCSE ICT (0417) P2 data manipulation using Access