Transcription of MICROSOFT ACCESS STEP BY STEP GUIDE - ICT lounge
{{id}} {{{paragraph}}}
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 53 Importing
Microsoft Office Microsoft Access 2. Click the Office Button followed by New to open the Blank Database pane on the right-hand side in the window. 3. Enter a meaningful File Name: for the database. For example Kites [ would make sense as this is …
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}