Microsoft Access: Creating Tables, Queries, Forms and Reports in Design View or the wizard; Creating Relationships between Tables; Queries including: Select queries including different types of queries such as Delete, Append, Update and Make Table; Editing Tables, Queries, Forms and Reports using Design View. Microsoft Excel: Enter, Edit and organise data; Use Page Setup - fit data to one page, use of margins and headers/footers; Formulas to include: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, COUNTBLANK, COUNTIF, SUMIF, ROUND, TODAY, VLOOKUP; Absolute and Relative formulas with the use of the $ sign; Creating charts (Column, Pie and Line). Microsoft Word: Use of Tables, Tabulations and Indents; Use of Word Templates; Format documents as appropriate including using Styles; Headers and footers including automatic fields - e.g. page numbering, filenames; Keyboard shortcuts and other hints and tips.
Name: Microsoft Units (Level 1) Qualification title: Level 1 Certificate Qualification type: Assessment Completed tasks throughout the course and portfolio building, there is no formal exam. Awarding - Created 20150918 12:16:12 Updated 20150918 12:16:12
Use of a personal memory stick would be helpful. Equipment required Use of a personal memory stick would be helpful.
CENTRAL COLLEGE NOTTINGHAM
Further Education
enquiries@centralnottingham.ac.uk
0115 914 6414
http://www.centralnottingham.ac.uk
Maid Marian Way Town: Nottingham