Data Manipulation Step By Step Booklet
Section 11: Data Manipulation
Mark Nicholls – ICT Lounge
IGCSE ICT – SECTION 11
DATA MANIPULATION
MICROSOFT ACCESS
STEP BY STEP GUIDE
Mark Nicholls
ICT Lounge
Page |1
Section 11: Data Manipulation
Mark Nicholls – ICT Lounge
Contents
Task 35 details………………………………………………………………………………………… Page 3
Opening a new Database…………………………………………………………………………. Page 4
Importing .csv file into the Database………………………………………………………. Page 5 - 9
Amending Field Properties……………………………………………………………………….. Page 10 - 11
Taking Screenshot Evidence……………………………………………………………………… Page 12
Task 36 details…………………………………………………………………………………………. Page 13
Inserting and Checking New Records……………………………………………………….. Page 13 - 14
Task 38 details……………………………………………………………………………………….. Page 15
Identifying Query Tasks and Report Tasks………………………………………………… Page 15
Creating the First Query……………..…………………………………………………………. Page 16 - 17
Creating a Calculated Field within the Query…………………………………………
Page 18 - 19
Changing Format of a Calculated Field…………………………………………………….. Page 20
First Query Search Criteria……………………………………………………………………… Page21 - 22
Setting up a Report of the First Query………..………………………………………….. Page23 - 27
Performing Calculations within Reports……………………………………………………. Page 28 - 31
Adding Header and Footer information to a Report………………………………. Page 32 - 34
Task 40 details…………………………………………………………………………………………. Page 35
Creating the Second Query…………………………………………………………………….. Page 35 - 37
Second Query Search Criteria………………………………………………………………….. Page 37 - 39
Setting up Labels of the Second Query…………………………………………………… Page 39 - 43
Adding Header and Footer information to Labels…………………………………… Page 43 - 46
Task 42 details………………………………………………………………………………………… Page 47
Creating the Third Query……………………………………………………………………….... Page 47
Third Query Search Criteria……………………………………………………………………… Page 47 – 48
Hiding Fields within a Query……………………………………………………………………. Page 48
Sorting information within a Query………………………………………………………… Page 49
Task 43 and 44
Mark Nicholls – ICT Lounge
IGCSE ICT – SECTION 11
DATA MANIPULATION
MICROSOFT ACCESS
STEP BY STEP GUIDE
Mark Nicholls
ICT Lounge
Page |1
Section 11: Data Manipulation
Mark Nicholls – ICT Lounge
Contents
Task 35 details………………………………………………………………………………………… Page 3
Opening a new Database…………………………………………………………………………. Page 4
Importing .csv file into the Database………………………………………………………. Page 5 - 9
Amending Field Properties……………………………………………………………………….. Page 10 - 11
Taking Screenshot Evidence……………………………………………………………………… Page 12
Task 36 details…………………………………………………………………………………………. Page 13
Inserting and Checking New Records……………………………………………………….. Page 13 - 14
Task 38 details……………………………………………………………………………………….. Page 15
Identifying Query Tasks and Report Tasks………………………………………………… Page 15
Creating the First Query……………..…………………………………………………………. Page 16 - 17
Creating a Calculated Field within the Query…………………………………………
Page 18 - 19
Changing Format of a Calculated Field…………………………………………………….. Page 20
First Query Search Criteria……………………………………………………………………… Page21 - 22
Setting up a Report of the First Query………..………………………………………….. Page23 - 27
Performing Calculations within Reports……………………………………………………. Page 28 - 31
Adding Header and Footer information to a Report………………………………. Page 32 - 34
Task 40 details…………………………………………………………………………………………. Page 35
Creating the Second Query…………………………………………………………………….. Page 35 - 37
Second Query Search Criteria………………………………………………………………….. Page 37 - 39
Setting up Labels of the Second Query…………………………………………………… Page 39 - 43
Adding Header and Footer information to Labels…………………………………… Page 43 - 46
Task 42 details………………………………………………………………………………………… Page 47
Creating the Third Query……………………………………………………………………….... Page 47
Third Query Search Criteria……………………………………………………………………… Page 47 – 48
Hiding Fields within a Query……………………………………………………………………. Page 48
Sorting information within a Query………………………………………………………… Page 49
Task 43 and 44