Microsoft Units (Level 1)

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

If you aren't sure what course of study is best for you we have a team of Progression Advisors who can help you decide. You can contact a member of this team by calling the Telephone Enquiry Centre.

Some part time courses require guidance before you can enrol, this is indicated in the specific course information. You can arrange an informal chat with a course tutor by calling the Telephone Enquiry Centre.