Access

Welcome to the first part of our Microsoft Office Access 2016 course. Access is Microsoft’s powerful and easy-to-use spreadsheet program. This new version of Access incorporates some new features and integration of features that were previously only available as separate add-ins.

By the end of this course, users should be comfortable with creating a new spreadsheet, working with basic formulae, making a spreadsheet look professional and presentable, and saving and printing a spreadsheet




Skill Level: Beginner

Power Point

Use a Graphical User Interface (GUI)-based presentation application to prepare and produce a presentation according to a given brief


Skill Level: Beginner

Microsoft Excel

Specific Outcome 1: Demonstrate an understanding of the principles of spreadsheets

Specific Outcome 2   Create, open and save spreadsheets

Specific Outcome 3: Produce a spreadsheet from a given specification

Specific Outcome 4: Edit a spreadsheet

Specific Outcome 5: Format a spreadsheet

Specific Outcome 6: Check spelling in a spreadsheet

Specific Outcome 7: Print a spreadsheet





Skill Level: Beginner

Microsoft Word

Specific Outcome 1: Work with multiple documents: Minimum 2 documents

Assessment Criteria

ü  A number of documents are opened

ü  Control is switched between the open documents

ü  Documents are sized so that at least two documents can be seen at the same time

ü  Text is manipulated between active documents

Specific Outcome 2: Format Text

Assessment Criteria

ü  A border is applied to text and removed from text

ü  Fill (shading) is applied to text and removed from text

ü  The current date and time is added

ü  An automatic field is added: Date, time, document information

ü  Special Characters and symbols are inserted

ü  Hyphenation is activated and applied: At least one of the following: Automatic, soft, optional

ü  Special effects are applied to text: Animation, text border

ü  Character Spacing is changed

Specific Outcome 3: Format paragraphs

Assessment Criteria

ü  Tabs are set, reset and removed: Tabs: left tab, right tab, centre tab, decimal align tab, leading character tab; at least 2 methods of setting tabs are demonstrated

ü  The default tab setting is changed

ü  Bullets are applied and removed: Automatic while entering, to existing text.  Bullet character, bullet position, text position

ü  The difference between numbered text and outline numbered text is explained. 

ü  Numbering is applied and removed: Automatic while entering, to existing text; single level numbering, multi-level numbering to at least three levels.

ü  Numbering formats are changed within existing paragraph: Number format, number style, number position, text position

ü  A border is applied and removed

ü  Fill (shading) is applied and removed

ü  Paragraph spacing is changed: Line Spacing, Before and After paragraph

Specific Outcome 4: Format Pages

Assessment Criteria

ü  The page format of a document is changed: Page size, page orientation, margins, layout

ü  Manual Page breaks are inserted

ü  Page breaks are deleted

ü  A border is applied and removed

Specific Outcome5: Format a Document

Assessment Criteria

ü  Methods of automatically formatting a document are explained: Templates, styles, manual

ü  A header is added to and removed from a document

ü  Page numbers are added to a document

ü  A document is split into sections: Minimum 2 sections

ü  Endnotes and footnotes are inserted into a document

ü  Section Break is deleted

Specific Outcome6: Templates are used and created

Assessment Criteria

ü  A document is created using an existing template

ü  A document is saved as a new template with a specific name and in a specific folder

ü  A created template is used


Skill Level: Beginner