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