Intro to Microcomputer Applications for Business
(CGS 2100)
Caryl Rahn
Fall Semester 2015
Week 1
Week 2
Week 3
Access Tutorial 2: Building a Database and Defining Table Relationships PowerPoint
Week 4
Access Tutorial 3: Maintaining and Querying a Database PowerPoint
Week 5
Week 6
Access Tutorial 5: Creating Advanced Queries and Enhancing Table Design
Assignment 1 Due 9/28/15
Week 7
Access Tutorial 6: Using Form Tools and Creating Custom Forms PowerPoint
Week 8
Excel Tutorial 1: Getting Started with Excel PowerPoint
Assignment 2 Due 10/12/15
Access Exam 10/12/15
Week 9
Week 10
Excel Tutorial 3: Working with Formulas and Functions PowerPoint
Week 11
Excel Tutorial 4: Working with Charts and Graphics PowerPoint
Week 12
Excel Tutorial 5: Working with Excel Tables, PivotTables, and PivotCharts PowerPoint
Week 13
Excel Tutorial 6: Managing Multiple Worksheets and Workbooks PowerPoint
Assignment 3 Due 11/16/15
Week 14
Excel Tutorial 8: Using Advanced Functions, Conditional Formatting, and Filtering
Week 15
Assignment 4 Due 11/30/15
Excel Exam 12/2/15