Content of Excel Tutorial 4 in Microsoft Office 2000 Professional

4. Excel Tutorial 4 (Cast Iron Concepts) - Excel charts
   1. Placing charts
   2. Planning a chart
   3. Using Chart Wizard - column chart on a worksheet
   4. Moving and resizing a chart
   5. Updating and modifying a chart
      1. Editing chart text
      2. Adding data labels
      3. Adding border and color to a chart title
   6. Previewing and printing a chart on a worksheet
   7. Creating a chart in a chart sheet
   8. Pie chart
      1. Adding 3D effects
      2. Exploding a slice of a pie chart
      3. Formatting chart labels
      4. Adding a texture fill to a chart background
   9. Printing a chart from a chart sheet
   10. Bar chart again
   11. Adding pictures for the bars in a bar chart

Content of Access (database) Tutorials in Microsoft Office 2000 Professional

1. Tutorial 1 (Valle Coffee)
   1. Starting Access
   2. Opening an existing database
   3. Database Window - Tables, Queries, Forms, Reports, Pages, Macros and Modules
   4. Opening a table (datasheet), navigating on the datasheet
   5. Printing a table
   6. Exiting Access
   7. Creating and Printing a Query
   8. Creating and Printing a Form
   9. Online Help
   10. Creating, previewing and printing a Report
   11. Compacting and repairing a database
2. Tutorial 2 (Valle Coffee, continued)
   1. Designing a database
   2. Designing Access tables
      1. Data types and field sizes
   3. Creating a new table
      1. Defining fields
      2. Specifying a key
      3. Saving the table structure
   4. Adding records to a table
   5. Saving a database (what is being saved?)
   6. Modifying the structure of an Access table
      1. Deleting, moving, adding fields
      2. Changing format
   7. Copying records from another Access database
   8. Updating a database
      1. Deleting and changing records
3. Tutorial 3, querying a database (Valle Coffee, continued)
   1. Queries
      1. Query window
      2. Creating and running a query
   2. Database relationships
      1. Defining a relationship or join - one-to-many
   3. Sorting data (records) in a query - toolbar Vs Query Design View
   4. Filtering data (records)
      1. Filter by selection
   5. Defining record selection criteria for Queries
      1. (Changing a datasheet's appearance)
      2. Comparison operators
      3. Using multiple selection criteria
         1. And, or
   6. Creating a calculated field (cannot be done in a table or datasheet, only in a Query)
      1. Aggregate functions
      2. Record group calculations