MICROSOFT ACCESS STEP BY STEP GUIDE - ICT lounge

Section 11: data Manipulation Mark Nicholls ICT lounge P a g e | 1 IGCSE ICT SECTION 11 data MANIPULATION MICROSOFT ACCESS step BY step GUIDE Mark Nicholls ICT lounge Section 11: data Manipulation Mark Nicholls ICT lounge P a g e | 2 Contents Task 35 Page 3 Opening a new Page 4 Importing .csv file into the Page 5 - 9 Amending Field Page 10 - 11 Taking Screenshot Page 12 Task 36 Page 13 Inserting and Checking New Page 13 - 14 Task 38 Page 15 Identifying Query Tasks and Report Page 15 Creating the First Page 16 - 17 Creating a Calculated Field within the Page 18 - 19 Changing Format of a Calculated Page 20 First Query Search Page21 - 22 Setting up a Report of the First Page23 - 27 Performing Calculations within Page 28 - 31 Adding Header and Footer information to a Page 32 - 34 Task 40 Page 35 Creating the Second Page 35 - 37 Second Query Search Page 37 - 39 Setting up Labels of the Second Page 39 - 43 Adding Header and Footer information to Page 43 - 46 Task 42 Page 47 Creating the Third Page 47 Third Query Search Page 47 48 Hiding Fields within a Page 48 Sorting information within a Page 49 Task 43 and 44 Page 51 Exporting data from a Page 51

Section 11: Data Manipulation Mark Nicholls – ICT Lounge P a g e | 12 Taking a screenshot – how to do it: 1. Open your Kites Table in Design View. 2. The task asks you to take a screenshot of the Field Names and Data Types used within the table. To do this, simply press PrtScn on the keyboard. 3. Open up an empty Microsoft Word document and

Loading..

Tags:

  Guide, Data, Step, Access, Microsoft, Simply, Microsoft access step by step guide

Information

Related search queries