::One Course Source

Sign up for upcoming classes: 03/12/2008 or 06/13/2008

Course Title: MSA-301: Access Level

Length of Course: 1 day

Cost of Class: $195/student

Overview:
This one-day course provides students with advanced features of Microsoft Access.

Prerequisites:
Prior to attending this class, students should have the following experience:

Understanding of the basic concepts involved in working with a personal computer (PC)
Familiarity with the Windows interface
Microsoft Access - Level 1 and Microsoft Access - Level 2, or equivalent knowledge

Objectives:
Upon successful completion of this course, students should be able to:

Customize toolbars and create styles and templates.
Create decision-making functions.
Analyze worksheet data by creating pivot tables.
Compare and contrast workbook files and file links.
Outline and consolidate worksheets and analyze worksheet data by using the Scenario Manager.
Display and protect worksheet data by locking cells.
Record and modify macros by using the Visual Basic Editor.
Create and work with interactive Web documents.

Units:

Unit One Customizing the Work Area
Unit Two Advanced Formula Construction
Unit Three Using Pivot Tables
Unit Four Working with Multiple Worksheets
Unit Five Consolidating and Analyzing Data
Unit Six Using Protection and Display Options
Unit Seven Introduction to Macros
Unit Eight Working with Interactive Excel Web Documents

Contact@OneCourseSource.com \| (619)303-5073 \| Privacy \| Online store