Information Technology

The essentials

Please find below your free information on the essentials of information technology. Although this information is useful for Help Desk professionals, it should prove to be useful to anyone wanting to gather reasonably quick advice in relation to this field.

It is perhaps wise at this stage to inform you that although SUNRISE has made every effort to ensure the information presented in this section is accurate and up-to-date, it should not be seen as a substitute for the standard user's manual or other professional advice. Rather it should complement and guide you through the more important aspects about computers, software, external hardware devices and IT in general.

Although the information was quickly put together from an Australian perspective, many of the ideas and concepts described in this section should be virtually the same for most other countries.

However if you would like to see other information included in this section, perhaps to make it more suited to your local environment or any other comments, then please your information. Your name and other details will be posted online should we decide to publish your work.

Contents

Microsoft Access - A Crash Course

  1. INTRODUCTION
    What is Microsoft Access?
  2. CREATING TABLES
    Preparing the tables for storing data
  3. FIELD PROPERTIES
    Working with fields
  4. CREATING TABLE RELATIONSHIPS
    Linking tables
  5. WORKING WITH DATA
    How to store data
  6. RECORDS
    How to sort and find records in datasheet view
  7. CREATING QUERIES
    How to sort, extract and perform calculations on records
  8. CREATING FORMS
    Making data-entry and access to information easy
  9. CREATING REPORTS
    Presenting data on paper
  10. CREATING MACROS
    Performing scripts
  11. CREATING PROFESSIONAL DATABASES
    Visual Basic for Applications (VBA)
  12. DATA-MODELLING
    The process of developing a (database) system
  13. DATABASES AIN'T DATABASES?!
    Comparing Microsoft Access with FileMaker Pro
  14. BIBLIOGRAPHY

Microsoft Excel - A Crash Course

  1. INTRODUCTION
    What is Microsoft Excel?
  2. ENTERING DATA
    The basics
  3. ENTERING FORMULAS
    Showing some of the power of Excel
  4. DESIGNING YOUR SPREADSHEET
    How to make things look good
  5. DRAWING GRAPHS
    Creating the big picture
  6. PRINTING
    Putting your spreadsheet on paper
  7. MACROS
    Automating your actions
  8. BIBLIOGRAPHY

Microsoft Word - A Crash Course

  1. INTRODUCTION
    What is Microsoft Word?
  2. ENTERING TEXT
    The basics
  3. DESIGNING YOUR WORD DOCUMENT
    Creating a professional looking document
  4. ENTERING PICTURES
    Creating a professional looking document
  5. DRAWING TOOLS
    Creating a professional looking document
  6. PRINTING
    Putting your document on paper
  7. MACROS
    Automating your actions
  8. BIBLIOGRAPHY

Operating System: Mac Classic

  1. PROBLEM-SOLVING ON A MACINTOSH
    The General Approach
  2. SYSTEM STABILITY
    Check List for Mac OS9
  3. OS9 STABILITY
    A special report
  4. APPLICATION STABILITY
    Check List
  5. NETWORK STABILITY
    Check List
  6. MAKING YOUR MACINTOSH RUN FASTER
    Check List
  7. COMMON MACINTOSH PROBLEMS
    Examples
  8. SOFTWARE RECOMMENDATIONS
    Which stable Mac OS Classic should I go for?
  9. SOFTWARE RECOMMENDATIONS
    Which disk utility software should I go for?
  10. BIBLIOGRAPHY
    Further reading

Operating System: OS X

  1. PROBLEM-SOLVING ON A MACINTOSH
    The General Approach
  2. About OSX
    Apple's 21st Century OS
  3. Getting started with OSX
    Customising your experience
  4. ADVANCED FEATURES AND APPLICATIONS OF OS X
    For professional users
  5. SYSTEM STABILITY
    Check List for Mac OSX
  6. OS X Jaguar
    About version 10.2.x
  7. OS X Panther
    About version 10.3.x
  8. OS X Tiger
    About version 10.4.x
  9. OS X Leopard
    About version 10.5.x
  10. OS X Snow Leopard
    About version 10.6.x
  11. OS X Lion
    About version 10.7.x
  12. OS X Mountain Lion
    About version 10.8.x
  13. OS X Mavericks
    About version 10.9.x
  14. OS X Yosemite
    About version 10.10.x
  15. OS X El Capitan
    About version 10.11.x
  16. macOS Sierra
    About version 10.12.x
  17. macOS High Sierra
    About version 10.13.x
  18. SheepShaver
    The return of the Classic Environment
  19. BIBLIOGRAPHY
    Further reading

Mac Hardware

A summary

  1. HARDWARE STABILITY
    What to look for

The PowerPC generation

  1. POWERBOOK G3 SERIES 'WALL STREET"
    Common problems
  2. POWERBOOK G3 SERIES 'PISMO/FIREWIRE"
    Common problems
  3. G3/G4 IBOOK
    Common problems
  4. eMAC G4
    Common problems
  5. TITANIUM G4 POWERBOOK
    Features and common problems
  6. ALUMINIUM G4 POWERBOOK
    Features and common problems
  7. G5 DESKTOP COMPUTER
    Common problems

The Intel generation

  1. INTEL ARRIVES
    Will Intel save Apple from certain demise?
  2. MACBOOK
    Features and common problems
  3. MACBOOK AIR
    Features and common problems
  4. MACBOOK PRO
    Features and common problems
  5. MAC MINI CORE DUO
    Features and common problems
  6. IMAC CORE DUO
    Features and common problems
  7. INTEL MACS
    Apple attempting to show the attraction of Intel Macs

Other Apple products

  1. THE iPOD HARDWARE INSTABILITY PROBLEM
    The design fault from Apple
  2. THE iPHONE
    The iPod on steroids
  3. THE iPAD
    Turning the iPod/iPhone into an eBook reader device
  4. POWER ADAPTERS
    Common Problems
  5. RECHARGEABLE BATTERIES
    Common Problems

The future

  1. APPLE COMPUTER, INC.
    Past and Present
  2. BIBLIOGRAPHY
    Further reading

Operating System: Windows XP

  1. PROBLEM-SOLVING ON A PC
    The General Approach
  2. AFTER INSTALLATION OF WINDOWS XP
    What to do next?
  3. ADVANCED FEATURES AND APPLICATIONS OF WINDOWS XP
    For professional users
  4. ADVANCED PROBLEM SOLVING ON WINDOWS XP
    For professional users
  5. HANDLING PC APPLICATIONS
    For professional users
  6. PC NETWORKS ON PRE-WINDOWS XP SYSTEMS
    The fundamentals
  7. THE FUTURE FOR WINDOWS XP
    Windows Vista
  8. BIBLIOGRAPHY
    Further reading

A General Overview of IT

Technology trend

  1. Self-employment trends
  2. Industry-sector trends
  3. IT trends

IT management

  1. Migration of technology
  2. IT outsourcing
  3. IT Acquisitions
  4. The importance of innovation and education for small IT businesses
  5. Managing change in the IT industry

Information

  1. Information - the worldwide commodity driving the IT industry
  2. Turning information into knowledge
  3. Who should control the information?
  4. Methods of storing information

Hardware

  1. The computer - why use it?
  2. The computer - features you can expect to find
  3. The computer - how to buy
  4. How to refurbish an old PC
  5. Peripherals for your computer - the essentials
  6. Peripherals for your computer - backup systems
  7. Peripherals for your computer - printers
  8. Peripherals for your computer - scanners
  9. Peripherals for your computer - music systems
  10. Peripherals for your computer - the mouse
  11. Computer manufacturers - PC or Mac?
  12. The cost of computers
  13. The future for computers

Software

  1. The software (The Consumer Sector)
  2. The software (The Business Sector)
  3. Free Software Licenses
  4. Operating Systems (OS)

Networks

  1. Introduction to networks
  2. How to Setup a PC Network (Hardware)
  3. How to Setup a PC Network (Software)
  4. How to Setup and Access a Shared Printer
  5. The basics of Novell Netware 4.11
  6. The network tools

Privacy and security

  1. The issue of privacy
  2. The importance of good security
  3. Keeping your personal information secure
  4. How to handle a computer security breach

The internet

  1. What is the Internet?
  2. What do I need to access the Internet?
  3. How do I get on the Internet?
  4. How many people uses the Internet?
  5. Who uses the Internet?
  6. Why are there so few women on the Internet?
  7. ISPs
  8. The Internet Network
  9. The tools for creating a web page
  10. The secret to good web page designs
  11. The technical aspects of designing a good web page
  12. What do you do after designing a web page?
  13. DNS
  14. Future trends in Web page designing
  15. What is the Internet used for? Part 1
  16. What is the Internet used for? Part 2
  17. Can people make money on the Internet? Part I
  18. Can people make money on the Internet? Part 2
  19. How to advertise on the Internet
  20. Web Scams
  21. The future for the Internet
  22. The future for HTML

How do I...

  1. ...turn LPs into CDs?
  2. ...use HTML to create web pages?