LEARN MICROSOFT ACCESS STEP BY STEP

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