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 details…………………………………………………………………………….. Page 51
Exporting Data from a Query…………………………………………………………………… Page 51 – 53
Importing Exported Data into a Word Document……………………………………… Page 52
Extra Info — Summarising Data………………………………………………………………. Page 54 – 56
