You are previewing How to Pass ECDL for Microsoft.
O'Reilly logo
How to Pass ECDL for Microsoft

Book Description

How to pass ECDL® for Microsoft® Office 2003

Paul Holden & Brendan Munnelly

How to Pass ECDL for Office 2003 has been written and designed to help you to study for the ECDL, to remember what you have learned  – and to pass the exams with confidence!

Fully covering the latest version of the ECDL syllabus – ECDL4  –  using the most popular and commonly-used PC software (Microsoft Windows XP®; Office 2003; and Internet Explorer 6),  How to Pass ECDL provides everything you need to understand and apply the subjects covered by the syllabus, and introduces many new features intended to make your studies more accessible and successful, including:

  •  Two-colour layout makes it easy to follow each lesson and find your way around each module

  • Four-colour “cut-out-and-keep” guides for each module to help your revision

  • Learning goals explain exactly what you will be covering in each module

  • New terms explained by subject area help you get to grips with unfamiliar terminology

  • Example-based workbook approach guides you through new topics by practising as you go

  • Tips boxes give you additional practical insider knowledge

  • Clear screenshots illustrate each feature covered and help build your understanding

  • The European Computer Driving Licence® (ECDL) is THE internationally recognised qualification that will allow you to demonstrate your competence in computer skills. Employers are increasingly relying on the ECDL to improve the skills of their workforce and to recruit computer-literate staff.

    The main benefits of the ECDL to you as an individual are that it:

  • Raises your level of competence in IT and computer skills

  • Improves your productivity at home and work

  • Requires no prior knowledge of IT or computer skills

  • Provides you with an industry-recognised qualification

  • Everything you need to know to demonstrate your competence in computer skills and pass the ECDL tests, all in one book !

    Visit us on the web at

    Table of Contents

    1. Copyright
    2. Pearson Education
    3. Introduction
      1. About ECDL
      2. About This book
    4. 1. Basic Concepts of Information Technology
      1. 1.1. Tools, Machines, Computers
        1. Computers: our latest invention
        2. How computers are different
        3. Information and how it’s measured
          1. Tools: the chimp, the banana and the stick
          2. Machines: the wind in our sails
          3. Computers: the multi-purpose information processor
          4. Information: our picture of the world
          5. How long is a piece of information?
          6. Computers: down to just two numbers
          7. What colour is an information bit?
          8. What is the sound of an information bit?
          9. From bits to bytes, kilobytes, megabytes and gigabytes
          10. Hardware and software
          11. Computers: smaller, faster, cheaper
        4. Conclusion
      2. 1.2. Two Memories and a Brain
        1. Computers: why some are better than others
        2. CPU: the computer’s brain
        3. Main memory (RAM)
        4. System memory (ROM)
        5. Hard disk
          1. The brain: yours and your computer’s
          2. Short-term memory: yours
          3. Short-term memory: your computer’s (RAM)
          4. Long-term memory: yours
          5. Long-term memory: your computer’s
          6. From short- to long-term memory: studying and saving
          7. ROM: the other type of RAM
        6. Conclusion
      3. 1.3. Information In, Information Out
        1. Out of the box: the essentials
        2. Out of the box: optional extras
        3. Removable storage
        4. Computer types
          1. The computer keyboard
          2. Screen/Monitor/VDU
          3. Mouse
          4. Other pointing devices
          5. Printers
          6. How to choose a printer
          7. Modem
          8. Multimedia
          9. Scanner
          10. Digital camera
          11. Loudspeakers
          12. Sound cards
          13. Microphone
          14. Looking after your hardware
          15. When something goes wrong
          16. Information you can take with you
          17. Diskettes (floppy disks)
          18. Zip disks
          19. CD-ROM
          20. CD-RW
          21. DVD
          22. Magnetic tape (data cartridges)
          23. External hard disk
          24. Computers: more than one type
          25. Devices for input, for output, and for both
        5. Conclusion
      4. 1.4. Software: The Two Kinds
        1. What is software?
        2. About system software
        3. About application software
        4. How software is made
        5. Software copyright
          1. Software
          2. Application software
          3. System software
          4. Graphical user interface
          5. How software is made
          6. Software copyright
          7. Software versions
          8. Problems with software
          9. Too many applications can slow down your PC
          10. Data
        6. Conclusion
      5. 1.5. Computer Networks
        1. Networks and groupwork
        2. LANs, WANS and client–server networks
        3. Modems
        4. PSTN, ISDN and ADSL
          1. Computer networking: from individual to groupworking
          2. Networks: is there a downside?
          3. LANs and WANs
          4. Networks: clients and servers
          5. Networks and the telephone system
          6. Modems: what do they do, and how quickly?
          7. From PSTN to ISDN
          8. Staying with PSTN: ADSL
          9. SMS messages
        5. Conclusion
      6. 1.6. The Internet and e-commerce
        1. Introducing the Internet
        2. E-mail: the two kinds
        3. Surfing the web
        4. Doing business online: e-commerce
          1. About the Internet
          2. E-mail and the Internet
          3. Internet e-mail: the two kinds
          4. The World Wide Web and the Internet
          5. HTML and the web
          6. Internet search engines
          7. Intranets and extranets
          8. E-commerce and the Internet
          9. Teleworking and the Internet
        5. Conclusion
      7. 1.7. What Computers Are Used for
        1. It’s a computerized world
        2. Computers: what are they good at?
        3. Work and life in an Information Society
        4. Information Technology: what is it?
          1. Information Technology: here, there and everywhere
          2. Computers in government
          3. Computers in healthcare
          4. Computers in education
          5. Computers in business and administration
          6. Computers in airlines, banking and insurance
          7. Computers in the manufacturing industry
          8. Computers in retailing
          9. Information Technology: for better or worse?
          10. Information rich and information poor
        5. Conclusion
      8. 1.8. Keeping your Information Safe
        1. Information Technology: two words
        2. Frequent file saves and backup copies
        3. Apply usernames, passwords and access rights
        4. Protect against computer viruses
        5. Comply with data protection laws
          1. Save your files as you work with them
          2. Keep backup copies of your files
          3. Apply usernames and passwords
          4. Assign appropriate access rights to network users
          5. Protect against viruses
          6. Guard against loss or theft of portable devices
          7. Control access to paper-based information
          8. Protect the workplace
          9. Protect against power failure
          10. Other people’s data: respect data copyright
          11. Comply with data protection regulations and principles
          12. The EU Data Protection Directive
        6. Conclusion
      9. 1.9. Looking After Number One
        1. Hazards of computer use
          1. Avoid repetitive strain injury (RSI)
          2. Avoid eyesight damage
          3. Avoid posture problems
          4. Prevent accidents with electricity and cables
          5. Look after your environment
        2. Conclusion
    5. 2. Using a Computer and Managing Files
      1. 2.1. First Steps in Windows
        1. Starting up, shutting down
        2. The Windows desktop
        3. Working with the mouse
        4. Windows within Windows
          1. Start your computer
          2. View your computer’s desktop
          3. Move the mouse
          4. View your Start menu
          5. View the sub-menus of your Start menu
          6. Launch Microsoft Word
          7. Launch Microsoft Excel and Notepad
          8. Switch between open applications
          9. Use the four control buttons
          10. Reposition a window with the title bar
          11. Open a desktop window
          12. Change the shape and size of a window
          13. Scroll a window
          14. Right-click to display pop-up menus
          15. Turn off your computer
          16. Restart your computer
          17. When an application ‘hangs’ or ‘freezes’
          18. When Windows ‘hangs’ or ‘freezes’
          19. Get to know dialog boxes
        5. Quit Windows
      2. 2.2. Personal Computer Is Two Words
        1. Personalizing your desktop
        2. Screen savers
        3. Screen resolution
        4. Date/time, volume and regional settings
        5. Windows Help and Support Center
          1. View your computer’s specifications
          2. Change your wallpaper
          3. Change your desktop theme
          4. Change your screen resolution
          5. Change the number of colours displayed
          6. Set the screen saver
          7. Set the time and date
          8. Change your regional settings
          9. Add further keyboard languages
          10. Display the Help and Support Center
          11. Search for help
          12. Using the Help index
          13. Get help from a dialog box
        6. Quit Windows
      3. 2.3. Drives, Folders and Files
        1. How your computer stores information
        2. About drives
        3. About folders
        4. About files
          1. Open My Computer
          2. View your drives
          3. View your C: drive’s properties
          4. Explore folders and files on your C: drive
          5. Change how you view a drive’s contents
          6. Sort folders and files
          7. View a folder’s properties
          8. View a file’s properties
          9. View and amend a folder’s or file’s attributes
          10. Recognize file name extensions and icons
          11. View list of recently used files
          12. Find folders and files
          13. Perform a wildcard search
          14. Perform date-based searches
          15. Perform content-based searches
          16. Create a desktop shortcut icon to an application
          17. Create a desktop shortcut icon to a file
          18. Create a desktop folder with shortcut icons
        5. Quit Windows
      4. 2.4. Using Windows Explorer
        1. From viewing to doing
        2. The panes of Windows Explorer
        3. Working with folders and files
        4. The Windows clipboard
          1. Start Windows Explorer
          2. Change how you view a drive’s contents
          3. Expand and collapse folder views
          4. Create a new folder
          5. Create a sub-folder
          6. Change a folder’s name
          7. Delete a folder
          8. Restore a folder’s files
          9. Create a new file
          10. Name and save a file
          11. Change a file’s name
          12. Delete a file
          13. Restore a file
          14. Copy a folder
          15. Cut and paste (move) a folder
          16. Copy a file
          17. Cut and paste (move) a file
          18. Working with multiple files
          19. Capture a screen image
          20. Compress the files in a folder
          21. Decompress an archive
          22. Install a software application
          23. Uninstall a software application
          24. Scan your computer for viruses
          25. Set up background scanning
        5. Quit Windows
      5. 2.5. Diskettes and Printing
        1. Working with diskettes
        2. Formatting diskettes
        3. The print queue
        4. Menu bars, toolbars and keyboard shortcuts
          1. Format a floppy diskette
          2. Copy a file to a diskette
          3. Save a file to a diskette
          4. Format a Zip disk
          5. Print a file
          6. Preview a file
          7. View the print queue
          8. Pause or resume a print job in the queue
          9. Cancel a print job in the queue
          10. Change the order of jobs in the print queue
          11. Delete all jobs from the print queue
          12. Change the default printer
          13. Using the Print dialog box
          14. Install a new printer
          15. Explore application menu bars
          16. Explore application toolbars
          17. Explore keyboard shortcuts
        5. Quit Windows
    6. 3. Word Processing
      1. 3.1. Your First Steps in Word
        1. About Word Documents
        2. Keys you need to know
        3. Date and time insertion
        4. Help system
          1. Launch Microsoft Word
          2. Hide and display the paragraph marks and other non-printing characters
          3. Type new text
          4. Edit previously typed text
          5. Use the SHIFT key
          6. Press ENTER to type new paragraph marks
          7. Remove a paragraph mark
          8. Insert and remove manual line breaks
          9. Move the cursor with the ARROW keys
          10. Type a horizontal line
          11. Move text to the right with the TAB key
          12. Insert the current date/time
          13. Undo and redo actions
          14. Repeat actions
          15. Work with Insert and Overtype modes
          16. Save and name a document
          17. Save a document with a different name to a diskette
          18. Close a document
          19. Create a new document
          20. Open an existing document
          21. Switch between open documents
          22. Display all commands on menus
          23. Display the Standard and Formatting toolbars on separate rows
          24. Hide and display toolbars
          25. Remove and redisplay toolbar buttons
          26. Working with task panes
          27. Get help
          28. Use the Type a question for help box
          29. Use the Help task pane
          30. Use the Help Table of contents
          31. Get help for a dialog box
        5. Quit Word
      2. 3.2. Working with Text and the Clipboard
        1. Text selection
        2. About text formatting
        3. Fonts and other text effects
        4. Working with the clipboard
          1. Select text in a document
          2. Deselect text in a document
          3. Apply bold format
          4. Apply italic format
          5. Apply underline format
          6. Discover the fonts on your computer
          7. Change text font
          8. Set font size
          9. Change font colour
          10. Apply superscript and subscript text format
          11. Change text case
          12. Insert symbols and special characters
          13. Discover the styles available to your document
          14. Apply a paragraph style
          15. Apply a character style
          16. Use Format Painter
          17. Copy and paste text within a document
          18. Copy and paste text between documents
          19. Cut and paste text
          20. Preview a document
          21. Print a document
          22. Change the magnification view
          23. Other document views
        5. Quit Word
      3. 3.3. Working with Paragraphs
        1. Paragraph-only actions
        2. Alignment: left, right, centred and justified
        3. Indents: in from the margin
        4. Bulleted and numbered lists
          1. Align a paragraph
          2. Apply left and right indents
          3. Apply a hanging indent
          4. Set inter-line spacing
          5. Set inter-paragraph spacing
          6. Apply a first line indent
          7. Apply a bulleted or numbered list
          8. Remove a bulleted or numbered list format
          9. Change the bullet style in a list
          10. Change the number style in a list
          11. Insert and remove manual page breaks
        5. Quit Word
      4. 3.4. Borders, Fills, Graphics and Charts
        1. Decorative borders
        2. Background fills
        3. Clip Art images
          1. Create your sample document
          2. Apply borders to text and paragraphs
          3. Add shading to selected text and paragraphs
          4. Insert a Clip Art image in a document
          5. Insert an image file in a document
          6. Create an Excel chart for inserting into Word
          7. Insert an Excel chart in a Word document
          8. Resize an inserted image or chart
          9. Reposition an inserted image or chart
          10. Delete an inserted image or chart
        4. Quit Word
      5. 3.5. Page Setup, Headers and Footers
        1. Working with page setup
        2. Headers and footers
          1. Set page size
          2. Set page orientation
          3. Set page margins
          4. Specify left/right or common headers and footers
          5. Specify different headers/footers on first pages
          6. Display the header and footer area
          7. Type header and footer text
          8. Format header and footer text
          9. Insert automatic page numbers in headers and footers
          10. Set automatic page numbers options
          11. Insert the document creation date in a header/footer
          12. Insert the document’s file name and location in a header/footer
        3. Quit Word
      6. 3.6. Working with Content
        1. Finding text in your documents
        2. Finding and replacing text
        3. Checking your spelling and grammar
        4. About hyphenation
          1. Find text: basic options
          2. Find text: search options
          3. Find text: format options
          4. Find and replace text
          5. Set your spellcheck options
          6. Correct misspelled words
          7. Perform a spellcheck
          8. Set your dictionary language
          9. Set your grammar checking options
          10. Set automatic hyphenation
        5. Quit Word
      7. 3.7. Tables and Tabs
        1. About tables and tabs
        2. Tables in Word
        3. Tabs in Word
          1. Create a new table: toolbar button
          2. Create a new table: menu command
          3. Insert and edit text and numbers in a table
          4. Select table cells
          5. Insert or delete table rows or columns
          6. Modify column width
          7. Modify row height
          8. Add borders to a table
          9. Add shading to a table
          10. Use the table AutoFormat option
          11. Insert tab stops
          12. Position text with left-aligned tabs
          13. Use multiple tab alignment options
          14. Use tabs with the ruler
        4. Quit Word
      8. 3.8. Mail Merge
        1. About mail merge
        2. Main steps in a mail merge
        3. Mailing labels
          1. Explore the mail merge procedure
          2. Use an existing document as a form letter
          3. Create a new form letter
          4. Create a data source
          5. View a Word data source
          6. Insert merge field codes in a form letter
          7. Preview a mail merge
          8. Perform a mail merge
          9. Merge addresses to labels
        4. Quit Word
      9. 3.9. Word File Formats
        1. Working with other file formats
          1. Work with web (HTML) format
          2. Work with earlier versions of Word
          3. Work with Rich Text format (RTF)
          4. Work with non-Word formats
          5. Work with plain-text formats
          6. Save a document as a template
          7. Open a document based on a saved template
          8. Set the default folder for opening and saving documents
          9. Set the user name for Word documents
        2. Quit Word
    7. 4. Spreadsheets
      1. 4.1. Your First Steps in Excel
        1. Spreadsheet, workbook, worksheet
        2. Worksheet cells
        3. Launch Microsoft Excel
          1. Create a new workbook
          2. Select a cell in a worksheet
          3. Enter text and/or numbers in a cell
          4. Edit the content of a cell
          5. Delete the content of a cell
          6. Undo and redo actions
          7. Repeat actions
          8. Modify basic options
          9. Save and name a new workbook
          10. Save a workbook with a different name to a diskette
          11. Switch between and rename worksheets in a workbook
          12. Add and delete worksheets
          13. Switch between open workbooks
          14. Close a workbook
          15. Open an existing workbook
          16. Display the Standard and Formatting toolbars on separate rows
          17. Display all commands on menus
          18. Hide and display toolbars
          19. Remove and redisplay toolbar buttons
          20. Working with task panes
          21. Change the magnification view
          22. Display different areas of a worksheet
          23. Get help
          24. Use the Type a question for help box
          25. Use the Help task pane
          26. Use the Help Table of Contents
          27. Get help from a dialog box
        4. Quit Excel
      2. 4.2. Calculations with Formulas
        1. Calculations in Excel
        2. Formulas and operators
        3. Formulas and arguments
        4. AutoFill: letting Excel do the work
          1. Create and save your formulas workbook
          2. Add, subtract, multiply and divide numbers
          3. Edit a formula
          4. Use constants in formulas
          5. Combine multiple operators in a single formula
          6. Perform a fixed factor calculation
          7. Recalculate a fixed factor calculation
          8. Insert a date in a cell
          9. Change date display format
          10. AutoFill numbers and text
          11. AutoFill a number series
          12. AutoFill a date
          13. Insert symbols in cells
          14. Select an adjacent cell range
          15. Select a non-adjacent cell range
          16. Select rows or columns
        5. Quit Excel
      3. 4.3. Calculations with Functions
        1. About functions
        2. The SUM function
        3. AutoSum button
        4. The AVERAGE function
        5. The MAX, MIN and COUNT functions
        6. The decision-making IF function
          1. Create and save your functions workbook
          2. Total numbers with the SUM function
          3. Total a vertical list of numbers with the AutoSum button
          4. Total a horizontal list of numbers with the AutoSum button
          5. Find averages with the AVERAGE function
          6. Recalculate function results
          7. Discover the biggest and smallest with the MIN and MAX functions
          8. Count numbers with the COUNT function
          9. Calculate sales commission with the IF function
          10. Display conditional text with the IF function
          11. Enter text across multiple columns
          12. Display the #VALUE! error message
          13. Display the #DIV./0! error message
          14. Display the #REF! error message
          15. Display the ##### error message
        7. Quit Excel
      4. 4.4. Number Styles and Cell Formatting
        1. More than one type of number
        2. Custom number formats and options
        3. Text as numbers
        4. Fonts, borders and background colours
          1. Create and save your numbers-formatting workbook
          2. Apply the Comma number format
          3. Revert to the default General Number format
          4. Apply the Currency number format
          5. Calculate the percentage contribution
          6. Apply the number format called ... Number format
          7. Increase and decease the number of decimal places
          8. Enter a number as text
          9. Regional Settings
          10. Change font, font style, font size and font colour
          11. Underline cell content
          12. Change horizontal alignment
          13. Copying cell formatting from one cell to another
          14. Change borders
          15. Change background colours
          16. Change column width and row height
          17. Align cells vertically
          18. Change cell orientation
          19. Hide and unhide rows and columns
          20. Freeze row and column titles
          21. Wrap content in a cell
        5. Quit Excel
      5. 4.5. Copying, Inserting and Sorting
        1. Copy, cut and paste
        2. Cell references: relative and absolute
        3. Inserting and deleting rows and cells
        4. Sorting: reordering rows by content
          1. Create and save the copy-insert-sort workbook
          2. Copy and paste a cell with drag-and-drop
          3. Copy and paste a cell by right-clicking
          4. Copy and paste adjacent and non-adjacent cell ranges
          5. Copy and paste rows and columns
          6. Copy and paste between worksheets and workbooks
          7. Copying worksheets
          8. Cut and paste cell contents
          9. Copy and paste a calculation: relative cell references
          10. Convert relative cell references to absolute cell references
          11. Copy and paste a calculation: absolute cell references
          12. AutoFill a calculation: absolute cell references
          13. Copy and paste fixed factor calculations: absolute cell references
          14. Insert rows and columns
          15. Remove rows and columns
          16. Insert and delete cells
          17. Perform a simple alphabetical sort
          18. Perform a simple numerical sort
          19. Perform a multiple criteria sort
        5. Quit Excel
      6. 4.6. Proofing, Printing and File Format
        1. Finding and replacing cell content
        2. Headers and footers
        3. Printing options
        4. Other file formats
        5. Importing images, graphs and text
          1. Open the copy-insert-sort workbook
          2. Finding cell content
          3. Replacing cell content
          4. Spellchecking
          5. Set up print options
          6. Insert a header and footer
          7. Preview your worksheet
          8. Print row titles on every page
          9. Print your worksheet
          10. Save a workbook as a template
          11. Open a workbook based on a saved template
          12. Work with earlier versions of Excel
          13. Work with non-Excel formats
          14. Work with text-only formats
          15. Work with HTML (web) format
          16. Import an image or graph
          17. Import text with the Text Wizard
        6. Quit Excel
      7. 4.7. Column Charts
        1. Excel charts
        2. Chart components
          1. Create and save your Column-Charts workbook
          2. Create a column chart
          3. Remove the chart legend
          4. Add a chart title: method 1
          5. Add a chart title: method 2
          6. Edit the chart title
          7. Add data labels to your columns
          8. Format the chart text
          9. Change the chart colours
          10. Reposition and resize the chart
          11. Cut, copy or paste the chart
          12. Change the values in the chart
          13. Rescale the vertical chart axis
          14. Print the chart
        3. Quit Excel
      8. 4.8. Bar, Line, Pie and Comparison Charts
        1. Non-default chart types
        2. Data points and data series
          1. Create and save your Other-Charts workbook
          2. Change from a column to a bar chart
          3. Change from a bar to a line chart
          4. Create a pie chart
          5. Add data labels to pie chart slices
          6. Explode a pie chart slice
          7. Create a two-data series comparison chart
          8. Create a three-data series comparison chart
        3. Quit Excel
    8. 5. Databases
      1. 5.1. Databases and Database Objects
        1. Databases? What are they?
        2. Computer databases
        3. Information – and how it’s viewed
          1. Launch Microsoft Access
          2. Open an Access database
          3. Open the Northwind database
          4. Explore the Database window
          5. Distinguish between actions and the objects
          6. Open a database table
          7. Explore a database table: records and fields
          8. Close a table
          9. Create a new database
          10. Save a database
          11. Copy a database
          12. Delete a database
          13. Hide and display Access toolbars
        4. Quit Access
      2. 5.2. Meet the Table Wizard
        1. Choosing a sample table
        2. Customizing the sample table
        3. Saving and naming your table
          1. Open your Bookworm database
          2. Explore the Table Wizard
          3. Use the Table Wizard to create your sample Books table
        4. Quit Access
      3. 5.3. More About Tables
        1. Entering and editing data in a table
        2. When you can undo, and when you can’t
        3. Columns: hiding, freezing and reordering them
          1. Open your Bookworm database
          2. Adjust column width
          3. Enter data in a table
          4. Enter data in your Books table
          5. Close and reopen your Books table: automatic re-sorting by primary key
          6. Edit a field in a table
          7. Undo actions
          8. Save a record
          9. Copy, cut and paste records
          10. Delete a record
          11. Hide and unhide a column
          12. Freeze and unfreeze a column
          13. Reorder columns
          14. Save table layout changes
          15. Copy a table
          16. Delete a table
          17. Get help
          18. Use the Type a question for help box
          19. Use the Help task pane
          20. Use the Help Table of Contents
          21. Get help from a dialog box
        4. Quit Access
      4. 5.4. Design View: Behind the Scenes
        1. Working in Design view
        2. Fields – more than one type
          1. Open your Bookworm database
          2. Switch between Datasheet and Design view
          3. Reorder columns in Design view
          4. Explore field types and properties
          5. Use Design view to create a sample Authors table
          6. Delete a column from a table
          7. Add a new field to a table in Datasheet view
          8. Add a new field to a table in Design view
          9. Change the data type of a field
          10. View a table’s indexed fields
          11. Index non-primary key fields
          12. Remove an index from a field
        3. Quit Access
      5. 5.5. Protect Good Tables Against Bad Data
        1. Screening for data entry errors
        2. Default values and mandatory fields
        3. Field data types and properties
        4. Applying validation rules
          1. Open your Bookworm database
          2. Set field properties: default values and required fields
          3. Set field properties: text fields
          4. Set field properties: number fields
          5. Set field properties: currency fields
          6. Set field properties: date/time fields
          7. Explore validation rules: comparison operators and literals
          8. Create a validation rule for a number field
          9. Create a validation rule for a date/time field
          10. Apply validation rules to text fields
          11. Explore logical operators in validation rules: AND and OR
          12. Use the AND operator in a date/time field
          13. Use the IN operator with multiple OR conditions
        5. Quit Access
      6. 5.6. Linking Tables in Relationships
        1. People and events, objects and transactions
        2. Entering table data once
        3. Linking tables in relationships
          1. Open your Bookworm database
          2. Explore relationship types
          3. Display tables for linking
          4. Create a one-to-one relationship
          5. Create a one-to-one relationship between two sample tables
          6. Create a one-to-many relationship
          7. Delete a relationship
          8. Protect relationships with relational integrity
        4. Quit Access
      7. 5.7. Sorts, Filters and Queries
        1. Solving the information problem – or moving it?
        2. Sorting: highlighting the relevant
        3. Filtering: hiding the irrelevant
        4. Queries: saved sorts and filters
          1. Open your Bookworm database
          2. Sort records in a table
          3. Return to the unsorted order
          4. Save a sort as a query
          5. Run a query
          6. Save sorts as sample queries for your Books table
          7. Filter records by selection in a table (whole field)
          8. Remove a filter
          9. Filter records by selection in a table (partial field)
          10. Filter records in a table (multiple fields)
          11. Save a filter as a query
          12. Save a filter as a sample query for your Books table
          13. Add, update and delete records in a query
          14. Copy a query
          15. Delete a query
          16. Perform a quick find
        5. Quit Access
      8. 5.8. Building Queries in Design View
        1. Queries and Design view
        2. Working with the design grid
          1. Open your Bookworm database
          2. Switch between Datasheet and Design view of a query
          3. Display saved sort and filter queries in Design view
          4. Construct a new query: your three options
          5. Create a query that contains a multi-column sort
          6. Create a query that contains comparison and logical operators
          7. Create a query that includes only certain columns
          8. Reorder columns in a query
          9. Create a multi-table query
          10. Create a sample multi-table query
        3. Quit Access
      9. 5.9. One Record at a Time: Forms
        1. Tables: beyond datasheet view
        2. About forms
        3. Different views: same information
          1. Open your Bookworm database
          2. Use AutoForm to create a form
          3. View records with a form
          4. Navigate records with a form
          5. Switch between Datasheet, Form and Design view
          6. Use a form to sort records
          7. Use a form to filter by selection
          8. Use a form to perform an advanced filter/sort
          9. Filter by form
          10. Use a form to create new records
          11. Use a form to update records
          12. Use the Form Wizard to create a form
          13. Delete a form
        4. Quit Access
      10. 5.10. Designing Form Layout
        1. Formatting your forms
        2. Form headers and footers
          1. Open your Bookworm database
          2. Switch between Form view and Design view
          3. Work with the Toolbox
          4. Create headers and footers on forms
          5. Change the header and footer vertical height
          6. Hide a form header or footer
          7. Change the form horizontal width
          8. Set the header and footer fill (background) colours
          9. Insert a label container in a header or footer and type text
          10. Edit label text
          11. Format label text
          12. Reposition a label container
          13. Resize a label container
        3. Quit Access
      11. 5.11. Printing and Reports
        1. Printing database objects
        2. From screen prints to reports
        3. Working with AutoReport
          1. Set page size
          2. Set page orientation
          3. Set page margins
          4. Preview a printout
          5. Work with the Print Preview window
          6. Print a table or the results of a query
          7. Print a form
          8. Explore the AutoReport feature
          9. Create a report with AutoReport: columnar
          10. Create a report with AutoReport: tabular
          11. Print a report
          12. Copy a report
          13. Delete a report
        4. Quit Access
      12. 5.12. Reports: Sorting, Grouping, Calculating
        1. About reports
        2. Sorting your records
        3. Grouping your sorted records
        4. Performing calculations on groups
        5. Layout and style options
          1. Explore the Report Wizard
          2. Produce an ungrouped report with the Report Wizard
          3. Produce a grouped report with the Report Wizard
          4. Perform calculations on grouped data within reports
        6. Quit Access
      13. 5.13. Designing a Report Layout
        1. Working in Design view
        2. Information formatting
          1. Switch between Print Preview and Design view
          2. View the bands of a report
          3. Inspect an ungrouped report in Design view
          4. Inspect a grouped report in Design view
          5. Inspect a grouped report with calculations in Design view
          6. Work with the toolbox
          7. Edit header or footer text
          8. Resize a header or footer container
          9. Format header or footer text
          10. Set the header and footer fill (background) colours
          11. Reposition a header or footer
          12. Insert a new header or footer
          13. Remove a header or footer
        3. Quit Access
    9. 6. Presentations
      1. 6.1. Your First Steps in PowerPoint
        1. Presentations and slides
        2. Slide Layouts
        3. Placeholders
          1. Launch Microsoft PowerPoint
          2. Enter text in a title slide
          3. Edit text on a slide
          4. Add a new slide to a presentation: default slide layout
          5. Add a new slide to a presentation: different slide layout
          6. Delete a slide
          7. Move between slides
          8. Change slide layout
          9. Undo and redo actions
          10. Repeat actions
          11. Modifying basic options
          12. Save and name your First-Steps presentation
          13. Save a presentation with a different name to a diskette
          14. Close a presentation
          15. Create a new presentation
          16. Open an existing presentation
          17. Switch between open presentations
          18. Display all commands on menus
          19. Display the Standard and Formatting toolbars on separate rows
          20. Hide and display toolbars
          21. Remove and redisplay toolbar buttons
          22. Change the magnification view
          23. Change pane size in normal view
          24. Get help
          25. Use the Type a question for help box
          26. Use the Help task pane
          27. Use the Help table of Contents
          28. Get online help from a dialog box
        4. Quit PowerPoint
      2. 6.2. Bullet Points and Outlines
        1. Bullet points and bullet levels
        2. Promoting and demoting bullets
        3. Numbering bullets
        4. Working in the Outline pane
          1. Open your First-Steps presentation
          2. Promote and demote bullet points
          3. Change the bullet character
          4. Change the bullet character colour
          5. Use a graphic as a bullet character
          6. Use a special character for a bullet point
          7. Undo your bullet format actions
          8. Numbering bullet points
          9. Change the numbering style
          10. Change line spacing
          11. Change text alignment
          12. Save and close your First-Steps presentation
          13. Create and name your Training presentation
          14. Enter text in the Outline pane
          15. Structure presentation text in the Outline pane
          16. Run your PowerPoint presentation
          17. Hide and Redisplay slides
        5. Quit PowerPoint
      3. 6.3. Copying, Moving and Reordering Slides
        1. Slide Sorter: your presentation in miniature
        2. Copying and importing text
          1. Open your First-Steps and Training presentations
          2. View an entire presentation in Slide Sorter view
          3. Reorder slides in Slide Sorter view
          4. Change magnification in Slide Sorter view
          5. Move a slide in Slide Sorter view
          6. Copy a slide between presentations
          7. Copy and move text
          8. Import text into PowerPoint
          9. Add and edit speaker notes
          10. Controlling page setup
          11. Create handout pages
          12. Print your presentation
        3. Quit PowerPoint
      4. 6.4. Presentation Formatting
        1. Text formatting
        2. Background formatting
        3. Colour schemes
        4. Slide Master
          1. Open your First-Steps and Training presentations
          2. Apply a colour scheme
          3. Customize a colour scheme
          4. Apply a decorative background
          5. Change fonts on every slide
          6. Change text font, font size and font style
          7. Change text to superscript or subscript
          8. Change text colour
          9. Change font case
          10. Format a presentation from the Slide Master
          11. Add a slide footer
          12. Format the slide footer
        5. Quit PowerPoint
      5. 6.5. Working with Graphics and Pictures
        1. Graphics in PowerPoint
        2. AutoShapes
        3. Text boxes
        4. Pictures
        5. Working with objects
        6. Grouping and ungrouping objects
          1. Open your First-Steps and Training presentations
          2. Draw simple graphics
          3. Change the width, style and colour of graphic lines
          4. Insert an AutoShape
          5. Copy and paste graphics
          6. Delete graphics
          7. Reposition graphics
          8. Resize graphics
          9. Align graphics
          10. Insert a text box
          11. Rotate a text box or graphic
          12. Change the stack order of objects
          13. Insert a picture in a slide
          14. Insert a Clip Art image in a slide
          15. Insert a second Clip Art picture
          16. Insert a third Clip Art picture
        7. Quit PowerPoint
      6. 6.6. Tables and Charts
        1. Working with tables
        2. Organization charts
        3. Working with charts
          1. Open your Training presentation
          2. Insert a table
          3. Insert an organization chart
          4. Work with the Organization Chart tools
          5. Add and remove organization chart boxes
          6. Restructure an organization chart
          7. Insert a column chart
          8. Reformat a chart
          9. Change chart type
          10. Insert a pie chart
        4. Quit PowerPoint
      7. 6.7. Transitions and Animations
        1. Slide advance methods
        2. Transitions
        3. Animations
          1. Open your First-Steps and Training presentations
          2. Apply an advance method to a presentation
          3. Apply a transition to a presentation
          4. Apply a preset animation scheme to a presentation
          5. Customize a preset animation
          6. Quit PowerPoint
      8. 6.8. Proofing, Templates and File Formats
        1. Spell-checking
        2. Saving a presentation as a slide show
        3. Other file formats
        4. Design templates
          1. Open your Training presentation
          2. Set your spell-check options
          3. Perform a spell-check
          4. Save a presentation as a PowerPoint show
          5. Work with earlier versions of PowerPoint
          6. Work with HTML (web) format
          7. Set HTML options
          8. Save slides as graphics
          9. Use PowerPoint slides in other applications
          10. Save a presentation as a template
          11. Apply a design template to a presentation
          12. Import spreadsheets
          13. Import an Excel chart
        5. Quit PowerPoint
    10. 7. Information and Communication
      1. 7.1. Exploring the Web
        1. Surf the Web
        2. Your start web page
        3. Visiting websites
        4. Using the Standard toolbar
        5. Getting help
          1. Start Internet Explorer
          2. View your start web page
          3. Visit a website
          4. Explore a website
          5. Explore the Standard toolbar
          6. Move forwards and backwards through a series of web pages
          7. Browsing with the Address Bar
          8. Enter an address in the Address bar
          9. Open multiple web pages
          10. Close an Internet Explorer window
          11. Open a framed web page
          12. Get online help
          13. Use help from dialog boxes
        6. Quit Internet Explorer
      2. 7.2. Saving, Downloading, Printing
        1. Selecting and copying from the web
        2. Downloading from the web
        3. Downloading files and viruses
        4. Respecting copyright
          1. Select and copy text from a web page
          2. Select and copy a web address from a web page
          3. Select and copy an image from a web page
          4. Download images from a web page
          5. Download video and sound files from a web page
          6. Download software from a web page
          7. Save the text of a web page
          8. Download a web page
          9. Set up print options
          10. Display and print header and footer help text options
          11. Print a web page
          12. Preview a printed web page
        5. Quit Internet Explorer
      3. 7.3. Finding Information within Websites
        1. Finding text within a web page
        2. Finding information within a website
        3. Using a site index
        4. Using a website search engine
        5. Using an interactive form
          1. Find text within a web page
          2. Use a website index page
          3. Use a website search engine
          4. Use an interactive form to request a map
          5. Use an interactive form to specify and price a new PC
        6. Quit Internet Explorer
      4. 7.4. Finding Information on the Web
        1. So much information, so little time
        2. Directory websites
        3. Search engines and meta search engines
        4. Phrase searches
        5. Logical searches
          1. Use the Yahoo! web directory site
          2. Search the web with the Google search engine
          3. Use Internet Explorer’s default search engine
          4. Perform a phrase search
          5. Use the plus (+) and minus (−) search operators
          6. Use a meta search engine
          7. Use a natural language search engine
        6. Quit Internet Explorer
      5. 7.5. Mastering Internet Explorer
        1. Working with Favorites
        2. Controlling display elements
        3. About the History list and cache
        4. About cookies
          1. Save a web address in Favorites
          2. Delete a Favorite
          3. Create a folder for your Favorites
          4. Add a new Favorite to a Favorites folder
          5. Revisit a saved web address
          6. Change your start page
          7. Control text size display
          8. Switch web page images off and on
          9. Switch the Address bar on/off
          10. Switch the Favorites, Search and History bars on/off
          11. Change your History settings
          12. Empty Internet Explorer’s cache
          13. Enable and disable cookies
          14. Display and delete your cookies
        5. Quit Internet Explorer
      6. 7.6. Web Fundamentals
        1. Web servers and web browsers
        2. Protocols: the rules of communication
        3. The Internet and the web
        4. The role of the Internet Service Provider (ISP)
        5. IP addresses and domain names
        6. Protection against hackers: passwords and encryption
          1. Connect to an IP address
          2. Reveal the IP address of a domain name
          3. Discover your computer’s IP address
          4. Visit US-registered domains
          5. Visit non-US domains
          6. Analyze a URL
          7. Register at a password-protected website
          8. Use an encrypted connection to a website
          9. Deal with web access failures
          10. Download a file from an FTP site
          11. Participate in newsgroups
          12. Design your own web page
        7. Quit Internet Explorer
      7. 7.7. E-mail with Outlook
        1. About e-mail and Outlook
        2. Navigation Pane, Mail Pane, Message List and Reading Pane
          1. Start Outlook
          2. Set display elements
          3. Explore your mail folders
          4. Open an e-mail folder
          5. Read an e-mail: Reading Pane or separate window
          6. Switch between open e-mails
          7. Resize screen elements
          8. Manage your outgoing e-mail
          9. Manage your incoming e-mail
          10. Send and collect your e-mail
          11. Print an e-mail
          12. Delete an e-mail
          13. Restore a deleted e-mail
          14. Empty the deleted items folder
          15. Set up automatic e-mail deletion
          16. Display and hide Outlook toolbars
          17. Change a folder’s view
          18. Change a folder’s headings
          19. Get help
          20. Use the Type a question for help box
          21. Use the Help task pane
          22. Use the Help Table of Contents
          23. Get help from a dialog box
        3. Quit Outlook
      8. 7.8. Composing and Sending E-mail
        1. Composing an e-mail
        2. Sending an e-mail
        3. Multiple recipients
        4. Signature files
        5. File attachments
          1. Compose and send an e-mail
          2. Copy text into an e-mail
          3. Format text in individual e-mails
          4. Ensure e-mail compatibility
          5. Check your spelling
          6. Request an e-mail receipt
          7. E-mail multiple recipients equally
          8. E-mail one main recipient, with copy to another
          9. E-mail with blind carbon copies
          10. Send an e-mail with an attachment
          11. Delete an attachment from an outgoing e-mail
          12. Set e-mail priority
          13. Flagging e-mail messages
          14. Create your signature file
          15. Create multiple signature files
          16. Edit your signature file
          17. Save an e-mail to the Drafts folder
        6. Quit Outlook
      9. 7.9. Responding to Received E-mail
        1. Actions on your incoming e-mail
        2. File attachments
        3. Mail folders
          1. Forward an e-mail
          2. Reply to sender only
          3. Reply to all recipients
          4. Copy and move the text of an e-mail
          5. Block an e-mail sender
          6. Manage your blocked senders list
          7. Identify incoming e-mails with file attachments
          8. Open an e-mail attachment
          9. Save an e-mail attachment
          10. Create a new mail folder
          11. Transfer e-mails between folders
          12. Delete a mail folder
          13. Marking an e-mail as read or unread
          14. Search for specific e-mails
          15. Sort e-mails in a folder
        4. Quit Outlook
      10. 7.10. Mail Contacts and Security
        1. About Outlook’s Address Book
        2. About Outlook’s Contacts folder
        3. About distribution lists/mailing lists
        4. Digital IDs: envelopes and signatures
          1. Explore your Address Book
          2. Add a entry to your address book
          3. Edit an address book entry
          4. Delete an address book entry
          5. Create a contact directly from e-mails
          6. Using your Address Book to address an e-mail
          7. Create a distribution list
          8. Send an e-mail to a distribution list
          9. Remove members from a distribution list
        5. Quit Outlook
    11. Quick reference guides
      1. Uses of Computers
      2. Keeping your Information Safe
      3. Data Protection
      4. Health and Safety
      5. Computers and Information
      6. Key Hardware Components
      7. Computer Hardware
      8. Computer Software
      9. Computer Networks
      10. The Internet
      11. E-commerce
      12. Teleworking
      13. My Computer Essentials
      14. Windows Vocabulary
      15. Windows Essentials
      16. Keyboard Shortcuts
      17. Word Processing Vocabulary
      18. Word Processing Essentials
      19. What Goes in a Cell?
      20. Spreadsheet Vocabulary
      21. Spreadsheet Essentials
      22. Design View
      23. Database Vocabulary
      24. Database Essentials
      26. Presentation Vocabulary
      27. Presentation Essentials
      28. E-mail Vocabulary
      29. Internet Vocabulary
      30. Information and Communication Essentials