Each video will open in its own window. Click the red X to close the window when you are finished viewing the video and you will return to this menu.

You may pause, rewind, or move forward through the videos as needed. Some videos have a brief quiz at the end to test your understanding. The answers will be presented after you respond, but the tests are not counted towards your class grade.

1. Use the Query Wizard
2. Switch Views in the Query Object
3. Build a Query in Design View
4. Add and Move Fields in Query Design View
5. Use Sort and Filter Tools
6. Use AND and OR Queries
7. Create a Calculated Form Control
8. Forms overview
9. Calculated Report Controls
10. Anatomy of an Access Report
11. Create relationships
12. About referential integrity
13. Many-to-many relationships
14. Use the Lookup Wizard
15. Basic queries
16. Complex queries
17. Create a Crosstab Query
18. Understand PivotTables and PivotCharts
19. Create a form with subform
20. Modify Subforms

21. Use Tab Controls
22. Add a Combo Box for data entry
23. Add a Combo Box to locate records
24. Add an Option Group
25. Adding a Command Button
26. Understand Domain Aggregate Functions
27. Access Overview
28. Tables Overview
29. Queries Overview
30. Reports Overview
31. About Switchboards
32. Build Macros
33. Plan and Build a Switchboard (loads slowly; be patient)
34. Learn about Custom Search Forms
35. Create a Custom Search Form: Step 1
36. Create a Custom Search Form: Step 2
37. Create a Custom Search Form: Step 3
38. Create and Complete a Custom Search Form: Step 4

1. Tour the window
2. Select cells and ranges
3. Rules for writing formulas
4. Use AutoSum
5. Use the Fill button
6. Change Page views
7. Write a formula
8. About functions
9. Write a function
10. About relative references
11. Write an absolute reference
12. Create a Data Table
13. Understand the IF function
14. Write an IF function
15. Write a PMT function
16. Understand the VLOOKUP function
17. Write a VLOOKUP function
18. Use Automatic Subtotals
19. Understand and use Advanced Filter
20. Understand and use Database functions
21. Understand and use SUMIF and COUNTIF functions
    

22. Grouping Sheets
23. Understanding 3-D references
24. Writing a 3-D formulas
25. Writing a 3-D function
26. Creating Charts
27. How to organize data into spreadsheet format
28. Using the PROPER and CONCATENATE text functions
29. Use the Insert Function feature
30. Understand and use the AND function
31. Protect worksheets
32. Chart overview interactive activity
33. Create and use Excel tables
34. Create a combination chart
35. Create a Bar of Pie chart
36. Create a pictograph

1. Selecting Text
2. Indenting text
3. Mail merge
4. Use Resume tools
5. Use Word Tables

1. Using the PowerPoint Slide Master
2. Tour the PowerPoint environment

1. Self-paced instruction on basic tasks such as creating folders, zipping and unzipping files, understanding file extensions, and more!
2. Zip files and folders
3. Unzip folders

1. DC Chapter 9: Communications and Networks Part 1
2. DC Chapter 9: Communications and Networks Part 2
3. DC Chapter 10: Databases
4. DC Chapter 12: Information System Development Part 1
5. DC Chapter 12: Information System Development Part 2
6. DC Chapter 13: Programming Languages and Program Development Part 1
7. DC Chapter 13: Programming Languages and Program Development Part 2
8. Tour of Sauk's network
9. Coding in HTML
10. Writing code in VBA for Excel
11. Integrating the Office applications