Skagit Valley College

Catalog Course Search Details

 Course Title:   MS Excel and Access II

 Title Abbreviation:   MS EXCEL and ACCESS II

 Department:    OBT

 Course #:    135

 Credits:    5

 Variable:     No

 IUs:    5

 CIP:    520302

 EPC:    547

 REV:    2021


 Course Description  

Use Microsoft Excel for PCs to apply advanced formatting techniques to spreadsheets and charts, write complex formulas and use advanced functions, use What-if Analysis tools, manage and analyze worksheet data, and automate tasks with templates and macros. Use Microsoft Access for PCs to design a relational database, enhance the design of tables, use advanced query and filter techniques, and design custom forms and reports.

 Prerequisite  

Prerequisite: OBT 134 with a "D" or higher.

Additional Course Details

Contact Hours (based on 11 week quarter)

Lecture: 55

Lab: 0

Other: 0

Systems: 0

Clinical: 0


Intent: Distribution Requirement(s) Status:  

Vocational Preparatory Required for ATA degree, Required for certificate  

Equivalencies At Other Institutions

Other Institution Equivalencies Table
Institution Course # Remarks
N/A

Learning Outcomes

After completing this course, the student will be able to:

  1. Apply advanced formatting techniques to create attractive worksheets and charts.
  2. Write formulas using advanced mathematical, statistical, financial, logical, lookup, and nested functions to find numerical information.
  3. Use range names, 3-D References, and links to manage and summarize data located in multiple worksheets.
  4. Create, sort, and filter Excel tables to arrange data into logical groupings.
  5. Create PivotTables and PivotCharts to arrange data into meaningful reports and charts.
  6. Use Excel�s What-If Analysis tools for planning and decision-making.
  7. Automate Excel tasks with macros and create templates to improve efficiency.
  8. Enhance the design of Access tables to improve the organization of business or personal records.
  9. Use advanced query techniques to locate data for reporting or decision making.
  10. Design custom Access forms and reports to meet specific communication needs.
  11. Manage the electronic storage of files.
  12. Analyze workplace scenarios requiring number-based solutions or the analysis and reporting of data and apply appropriate strategies to arrive at solutions using Excel and Access.

General Education Learning Values & Outcomes

Revised August 2008 and affects outlines for 2008 year 1 and later.

Course Contents

  1. MS Excel: Advanced spreadsheet and chart formatting.
  2. MS Excel: Advanced functions.
  3. MS Excel: Nested formulas.
  4. MS Excel: PivotTables and PivotCharts.
  5. MS Excel: Tables.
  6. MS Excel: What-if Analysis tools (Scenario Manger, Goal Seek, Data Tables).
  7. MS Excel: Workbook management techniques.
  8. MS Excel: Macros and templates.
  9. MS Access: Relationship database design concepts.
  10. MS Access: Advanced table design and query techniques.
  11. MS Access: Form design and customization.
  12. MS Access: Report design and customization.