Tips

Modified 31 May 2013


Tip sheets

Applications

Access

  1. Introduction - What is
  2. Forms - Creating a combo box, Insert images
  3. Queries - Creating a simple query, Criteria, Calculations on records in a query, Examples of expressions that use text values as criteria, Update queries
  4. Reports - Calculations in a report, More calculations in a report, Getting it right AccessCalculations
  5. Tables - Data type properties, Format properties, Validating data, Creating a combo box, Data types quiz, Primary key quiz, Boolean features
  6. Personalised - Startup
  7. Data access pages - Introduction, Pages used for data entry, Create a page using a wizard, Formatting pages, Customising navigation control
  8. Save - Saving to other place
  9. Big quiz
  10. Switchboard
  11. Access 2007 manual and PPT
  12. Access Reports Quiz and zipped

Adobe Acrobat

  1. Working with Adobe Acrobat

Delicious

  1. How to use delicious and mp3 and ppt

Excel

  1. Formulaes and Functions - Concatenate, Countif, Left, MRound, Round, SumIf, Sumif, Functions quiz, Vlookup
  2. PivotTable, Pivot table
  3. Microsoft Map
  4. Graph - Frequency distribution graph
  5. Self-marking quizzes
  6. Financial functions, two-variable data tables and spinners
  7. Conditional formatting and conditional formatting
  8. Assigning a macro to a button
  9. Creating a custom menu
  10. Creating a macro
  11. Advanced filters
  12. Error indicators quiz
  13. Data validation
  14. Collection of Excel quizzes
  15. Excel 2007 manual, PPT and crossword

FrontPage

  1. Creating a web using FrontPage
  2. Webscripting
  3. Webinteractivity

HTML

  1. Lists

Odeo (Podcasts)

  1. Creating sound files as mp3s to download or link to online
  2. Creating a podcast in Odeo and promoting it in Blogger and iTunes

Outlook

  1. Using Outlook

PowerPoint

  1. Creating a presentation using PowerPoint
  2. Create a hyperlink or bookmark in PowerPoint
  3. Saving a PowerPoint file as Read-Only
  4. Create a MultiPage feature in PowerPoint using Visual Basic for Applications
  5. Create a Text Tip feature in PowerPoint using Visual Basic for Applications
  6. Create a simple quiz feature in PowerPoint using Visual Basic for Applications

WinZip

  1. Zipping and unzipping files or in another way, Compressing or uncompressing files

Word

  1. Saving a Word file as Read-Only
  2. Create forms that users can view and complete in Word
  3. Creating a graph in Word
  4. Creating a multimedia Word document
  5. Creating individual labels with mail merge
  6. Working with long documents - Section breaks, Column breaks, Using styles, Modifying styles, Modifying styles of Captions, Table of Contents, Table of Figures, Cross references, Track changes
  7. Mail merge from Access PPT and zipped
  8. 2011 exam and mail merge
  9. Word form fields and Fields MOV and SWF ExtractMov  ExtractSwf     ExtractWmv

Google

Twitter

Videos

Useful information

OAO

  1. 2010

Blogging

  1. Quiz on Blogging and on RSS feeds
  2. Blogging for beginners slide show and pdf
  3. RSS feeds

Desk top publishing

  1. General guidelines

Read-Only

  1. Saving a Word file as Read-Only
  2. Saving a PowerPoint file as Read-Only

Assessment

  1. Marking an exam paper
  2. Processing marks

PAT

  1. Quiz (stupid, awful)

Online safety

Effectiveness of online learning

Marking

Keeping in contact

Digital camera

UCT

MCQ questions

Report writing  Zipped

Finister

Ipad testing

3 Classification Where is it found in Word?
3 Sentence sequencing Table of contents
3 Tree Shortcuts
3 Tree Where is it found in Word?
3_2 Sentence sequencing Bookmarks
3_2 Sentence sequencing Using hyperlinks with bookmarks
3_3 Sentence sequencing Mail merge
Word quiz
Word quiz 2
Word quiz 3
Word quiz 4
Word 5 Stop

 

 

 

 

Return to Computer Applications Technology index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.