Skagit Valley College logo

Catalog Course Search Details


 Course Title:   MS Excel and Access I

 Title Abbreviation:   MS EXCEL AND ACCESS I

 Department:    OFTEC

 Course #:    134

 Credits:    4

 Variable:     No

 IUs:    4

 CIP:    520204

 EPC:    547

 REV:    2014

 Course Description  

Use Microsoft Excel to create, edit, and format spreadsheets; write formulas and use functions to find numerical solutions; create charts and add graphics to create visual interest; and manage worksheet data. Use Microsoft Access to create, edit, and manage database tables; establish table relationships; filter, query, and sort data; and create forms and reports.



Additional Course Details

Contact Hours (based on 11 week quarter)

Lecture: 44

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

Learning Outcomes

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

  1. Create, enter, and edit data in spreadsheets.
  2. Format worksheets in a uniform, attractive style.
  3. Write formulas using mathematical operators and absolute and mixed cell references.
  4. Find numerical solutions using common mathematical, statistical, financial, date and time, and logical functions.
  5. Create, modify, and format charts.
  6. Create diagrams and use other graphical devices to add visual interest to worksheets.
  7. Manage multiple Excel worksheets.
  8. Create and modify database tables to organize business or personal records.
  9. Modify and manage database tables to ensure that data is accurate and up to date.
  10. Create relationships between Access tables.
  11. Design queries to extract data needed for reporting or decision making.
  12. Design forms and reports to meet communication needs.
  13. Manage the electronic storage of files.
  14. 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


2. Critical Thinking


Outcomes: Students will be able to . . .

8. Mathematical Reasoning


Outcomes: Students will be able to . . .
8.2 Correctly apply logical reasoning and mathematical principles to solve problems.

10. Technology


Outcomes: Students will be able to . . .

Course Contents

  1. Microsoft Excel: Worksheet creation and editing.
  2. Microsoft Excel: Formatting techniques.
  3. Microsoft Excel: Formula-writing concepts.
  4. Microsoft Excel: Common Excel functions.
  5. Microsoft Excel: Chart creation and modification.
  6. Microsoft Excel: Graphic enhancements.
  7. Microsoft Excel: Basic workbook management techniques.
  8. Microsoft Access: Relational database concepts.
  9. Microsoft Access: Table design and creation.
  10. Microsoft Access: Table relationships.
  11. Microsoft Access: Data filtering and sorting.
  12. Microsoft Access: Query design.
  13. Microsoft Access: Basic form design.
  14. Microsoft Access: Basic report design.