10.11 data manipulation

10.11 Data Manipulation

3 Reports

You will need…• Specimen 2007 Paper 2 Task C (a PDF) q 43• Read this question carefully before you start• The database 2007_Specimen that you saved

from section 2 opened in Access 2007

Click on the Create tab

Click on Report Wizard

Base the report on the query from section 2

Bring across all the fields… Next

No grouping is needed here… Next

Sort Growth in ascending order… NextNo real need for this since you did it in the query as well.

Tabular is OK and the question says Portrait… Next

Choose a style… NextDon’t take too long!

Make the title Far East Sites… Preview… Finish

Check it fits on one page and all data are visibleTwo field names are not showing fully.

Close the Preview

Resize the text boxes that are not correctTake care not to go over the edges of the page

Click View to check…

… and return to Design view

Delete unwanted text boxes in the Page footer

Choose the Label tool

Drag a box and write your name

View the report

Check it, save and print

End of section 3