Microsoft Office 2007 Common New Features
The Office Button
The Ribbon
Dialog Box Launchers
Screen Tips
The Quick Access Toolbar
The Microsoft Office Window Frame
Contextual Tabs
The Mini Toolbar
Galleries
Live Preview
Enhanced File and Compatibility Features in Office 2007
Microsoft Outlook
Quickly find the information you need with Instant Search
Enable Instant Search
Disable Instant Search
Find a message
Include subfolders in Instant Search
Include the Deleted Items folder in Instant Search
Add more search criteria
Reuse a recent search
Include data files in searches
Choose which data files to include in searches
Color Categories
Assign a color category to a message
Assign a Quick Click category to a message
Set a Quick Click category
Assign a Quick Click category
Attachment previewing
Preview an attachment in the Reading Pane
Preview an attachmentMinimized Navigation Pane
Minimize or expand the Navigation Pane
Task integration on the Calendar
Schedule an in-person meeting
Change a meeting
Make a meeting recurring
Make a meeting private
Easily share information with anyone, anywhere
Send your calendar via e-mailDiscontinued features and modified functionality in Outlook 2007
Microsoft Word 2007
Styles
New Fonts in Word 2007Document Themes
Building Blocks
SmartArt Graphics
Microsoft Excel 2007
Excel Spreadsheet Enhancements
The Enhanced Excel Table
Format Tables
Conditional Formatting
Enhanced Sorting
Enhanced Filter Options
Microsoft PowerPoint 2007
PowerPoint Themes and Quick Styles
SmartArt Graphics
New and improved Effects and Text Styles
Table and Chart Enhancements
Slide Libraries
Most organizations maintain and manage large amounts of information. One of
the most efficient and powerful information management computer applications is
the relational database. Information can be stored, linked, and managed using a
single relational database application and its associated tools. In this course,
you will be introduced to the concept of the relational database by using the
Microsoft® Office Access 2003 relational database application and its
information management tools.
Prerequisites: To ensure the successful completion of Microsoft® Office
Access 2003: Level 1, we recommend completion of one of the following Element K
courses, or equivalent knowledge from another source:
Windows 2000: Introduction
Windows XP: Introduction
Windows XP Professional: Level 1
Windows XP Professional: Level 2
Upon successful completion of this course, students will be able to:
examine the Microsoft® Office Access 2003 database application.
manage the data in a database.
examine existing table relationships.
query the database.
design simple forms.
create and modify Access reports.
Topic 1A: Understand Relational Databases
Topic 1B: Examine the Access Environment
Topic 1C: Open the Database Environment
Topic 1D: Examine an Access Table
Topic 2A: Examine an Access Form
Topic 2B: Add and Delete Records
Topic 2C: Sort Records
Topic 2D: Display Recordsets
Topic 2E: Update Records
Topic 2F: Run a Report
Topic 3A: Identify Table Relationships
Topic 3B: Identify Primary and Foreign Keys in the Relationships Window
Topic 3C: Work with Subdatasheets
Topic 4A: Create a Select Query
Topic 4B: Add Criteria to a Query
Topic 4C: Add a Calculated Field to a Query
Topic 4D: Perform a Calculation on a Record Grouping
Topic 5A: Examine Form Design Guidelines
Topic 5B: Create a Form Using AutoForm
Topic 5C: Create a Form Using the Form Wizard
Topic 5D: Modify the Design of a Form
Topic 6A: Create an AutoReport
Topic 6B: Create a Report by Using the Wizard
Topic 6C: Examine a Report in Design View
Topic 6D: Add a Calculated Field to a Report
Topic 6E: Modify the Format Properties of a Control
Topic 6F: AutoFormat a Report
Topic 6G: Adjust the Width of a Report
As you begin this course, you should have the basic skills you need to work
with a Microsoft® Office Access 2003 databases. This includes working with
Access tables, relationships, queries, forms, and reports. But thus far you have
been focusing on essential database user skills only. In this course you will
consider how to design and create a new Access database, how to customize
database components, and how to share Access data with other applications.
Prerequisites: To ensure the successful completion of Microsoft Access
2003: Level 2, we recommend completion of the following courses, or equivalent
knowledge (basic familiarity with Access tables, relationships, queries, forms,
and reports) from another source:
Microsoft Access 2003: Level 1
Upon successful completion of this course, students will be able to:
follow the steps required to properly design a simple database.
create a new database with related tables.
control data entry by modifying the design of a table to streamline data entry and maintain data integrity.
find and retrieve desired data by using filters and joins between tables and within a single table.
create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.
enhance the appearance, data entry, and data access capabilities of your forms.
customize reports to better organize the displayed information and produce specific print layouts such as mailing labels.
use Access data in other applications, including Microsoft Word and Excel.
Topic 1A: Design a Relational Database
Topic 1B: Identify Database Purpose
Topic 1C: Review Existing Data
Topic 1D: Determine Fields
Topic 1E: Group Fields into Tables
Topic 1F: Normalize the Data
Topic 1G: Designate Primary and Foreign Keys
Topic 2A: Create a New Database
Topic 2B: Create a Table Using a Wizard
Topic 2C: Create Tables in Design View
Topic 2D: Create Relationships between Tables
Topic 3A: Restrict Data Entry with Field Properties
Topic 3B: Create an Input Mask
Topic 3C: Create a Lookup Field
Topic 4A: Find Data with Filters
Topic 4B: Create Query Joins
Topic 4C: Join Unrelated Tables
Topic 4D: Relate Data Within a Table
Topic 5A: Set Select Query Properties
Topic 5B: Create Parameter Queries
Topic 5C: Create Action Queries
Topic 6A: Enhance the Appearance of a Form
Topic 6B: Restrict Data Entry in Forms
Topic 6C: Add Command Buttons
Topic 6D: Create a Subform
Topic 7A: Organize Report Information
Topic 7B: Set Report Control Properties
Topic 7C: Control Report Pagination
Topic 7D: Summarize Information
Topic 7E: Add a Subreport to an Existing Report
Topic 7F: Create Mailing Labels
Topic 8A: Publish Access Data as a Word Document
Topic 8B: Analyze Access Data in Excel
Topic 8C: Export Data to a Text File
Topic 8D: Merge Access Data with a Word Document
Your training in and use of Microsoft® Office Access 2003 has provided you
with a solid foundation in the basic and intermediate skills for working in
Microsoft® Office Access 2003. You're now ready to extend your knowledge into
some of the more specialized and advanced capabilities.
Prerequisites: To ensure the successful completion of Microsoft® Office
Access 2003: Level 3, we recommend completion of the following Element K
courses, or equivalent knowledge (familiarity with basic and intermediate
features of Access tables, relationships, queries, forms, and reports) from
another source:
Microsoft® Office Access 2003: Level 1
Microsoft® Office Access 2003: Level 2
Upon successful completion of this course, students will be able to:
restructure an existing set of data to improve the design of a database.
use a variety of techniques to summarize and present data with queries.
create and revise basic Access macros.
create macros that improve data entry efficiency and integrity.
improve the effectiveness of data entry in forms.
improve the effectiveness of data displayed in reports.
maintain an Access database by using various utility tools.
Topic 1A: Import Data
Topic 1B: Analyze Tables
Topic 1C: Create a Junction Table
Topic 1D: Improve Table Structure
Topic 2A: Create Unmatched and Duplicates Queries
Topic 2B: Group and Summarize Records Using the Criteria Field
Topic 2C: Summarize Data with a Crosstab Query
Topic 2D: Create a PivotTable and a PivotChart
Topic 2E: Display a Graphical Summary on a Form
Topic 3A: Create a Macro
Topic 3B: Attach a Macro to a Command Button
Topic 3C: Restrict Records Using a Where Condition
Topic 4A: Require Data Entry with a Macro
Topic 4B: Display a Message Box with a Macro
Topic 4C: Automate Data Entry
Topic 5A: Change the Display of Data Conditionally
Topic 5B: Display a Calendar on a Form
Topic 5C: Organize Information with Tab Pages
Topic 6A: Cancel Printing of a Blank Report
Topic 6B: Include a Chart in a Report
Topic 6C: Arrange Data in Columns
Topic 6D: Create a Report Snapshot
Topic 7A: Link Tables to External Data Sources
Topic 7B: Back Up a Database
Topic 7C: Compact and Repair a Database
Topic 7D: Protect a Database with a Password
Topic 7E: Determine Object Dependency
Topic 7F: Document a Database
Topic 7G: Analyze the Performance of a Database
Microsoft® Office Access 2003: Level 4
Course Description
In previous levels, you were introduced to advanced topics that
dealt with local database management. In this course, you will learn remote
database management, how to exchange data with XML and other type applications,
and how to automate your business processes by using VBA code.
Prerequisites: To ensure the successful completion of Access 2003: Level
4, we recommend completion of the following Element K courses, or equivalent
knowledge from another source:
Windows 2000: Introduction, Windows XP: Introduction, or Windows XP: Level 1 and
Windows XP: Level 2 and Access 2003: Level 1, Access 2003: Level 2, and Access
2003: Level 3
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
develop a data access page.
develop a data access page, a PivotTable, and a PivotChart.
import XML data and export Access data.
use VBA to automate a business process.
create and modify a database switchboard, and set and modify your startup options.
distribute a database and add security features to it.
Course Content
Lesson 1: Making Your Data Available on the Web
Topic 1A: Create a Data Access Page by Using the Wizard
Topic 1B: Improve the Presentation of the Data Access Page
Topic 1C: Viewing Data Access Pages with the Browser
Topic 1D: Edit Data Using the Data Access Page
Topic 1E: Group Records in the Data Access Page
Lesson 2: Developing a Data Access Page in Design View
Topic 2A: Create a Data Access Page in Design View
Topic 2B: Incorporate a ComboBox in the Data Access Page
Topic 2C: Test the New Record Function of the Data Access Page
Topic 2D: Develop a PivotTable with the Office PivotTable Tool
Topic 2E: Develop a PivotChart
Lesson 3: Integrating Access into Your Business
Topic 3A: Import XML Data into an Access Database
Topic 3B: Export Access Data to XML Format
Topic 3C: Share Data with Other Office Applications
Lesson 4: Automating a Business Process with VBA
Topic 4A: Create a Standard Module
Topic 4B: Develop Code
Topic 4C: Call a Procedure from a Form
Topic 4D: Run the Procedure
Lesson 5: Creating a Switchboard and Setting the Startup Options
Topic 5A: Create a Database Switchboard
Topic 5B: Modify a Database Switchboard
Topic 5C: Set the Startup Options
Topic 5D: Modify the Startup Options
Lesson 6: Distributing and Securing the Database
Topic 6A: Split a Database
Topic 6B: Implement Security
Topic 6C: Set Passwords
Topic 6D: Encode and Decode a Database
Topic 6E: Convert an Access Database to an MDE File
Appendix A: Microsoft Office Specialist Program
|
Prerequisites: To ensure your success, we recommend you first take the following Element K course or have equivalent knowledge:
Microsoft Office Windows XP: Introduction
Upon successful completion of this course, students will be able to:
create a basic worksheet.
modify a worksheet.
perform calculations.
format a worksheet.
develop a workbook.
print the contents of a workbook.
customize the layout of the Excel window.
Lesson 1: Getting Started with Excel
Topic 1A: An Overview of Excel
Topic 1B: Navigate in Excel
Topic 1C: Select Data
Topic 1D: Enter Data
Topic 1E: Save a Workbook
Topic 1F: Obtain Help
Lesson 2: Modifying a Worksheet
Topic 2A: Move and Copy Data Between Cells
Topic 2B: Fill Cells with Series of Data
Topic 2C: Edit Cell Data
Topic 2D: Insert and Delete Cells, Columns, and Rows
Topic 2E: Find, Replace, and Go To Cell Data
Topic 2F: Spell Check a Worksheet
Lesson 3: Performing Calculations
Topic 3A: Create Basic Formulas
Topic 3B: Calculate with Functions
Topic 3C: Copy Formulas and Functions
Topic 3D: Create an Absolute Reference
Lesson 4: Formatting a Worksheet
Topic 4A: Change Font Size and Type
Topic 4B: Add Borders and Color to Cells
Topic 4C: Change Column Width and Row Height
Topic 4D: Merge Cells
Topic 4E: Apply Number Formats
Topic 4F: Create a Custom Number Format
Topic 4G: Align Cell Contents
Topic 4H: Find and Replace Formats
Topic 4I: Apply an AutoFormat
Topic 4J: Apply Styles
Lesson 5: Developing a Workbook
Topic 5A: Format Worksheet Tabs
Topic 5B: Reposition Worksheets in a Workbook
Topic 5C: Insert and Delete Worksheets
Topic 5D: Copy and Paste Worksheets
Topic 5E: Copy a Workbook
Lesson 6: Printing Workbook Contents
Topic 6A: Set a Print Title
Topic 6B: Create a Header and a Footer
Topic 6C: Set Page Margins
Topic 6D: Change Page Orientation
Topic 6E: Insert and Remove Page Breaks
Topic 6F: Print a Range
Lesson 7: Customizing Layout
Topic 7A: Split a Worksheet
Topic 7B: Arrange Worksheets
Topic 7C: Freeze and Unfreeze Rows and Columns
Topic 7D: Hide and Unhide Worksheets
Appendix A: Microsoft Office Specialist Program
|
Prerequisites: To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel 2003. Students can obtain this level of skill by taking the following Element K course:
Microsoft Excel 2003: Level 1
Upon successful completion of this course, students will be able to:
create and apply templates.
create and modify charts.
work with graphic objects.
calculate with advanced formulas.
sort and filter data.
use Excel with the Web.
Lesson 1: Creating and Applying Templates
Topic 1A: Create a Workbook from a Template
Topic 1B: Create a Custom Template
Topic 1C: Working with Comments
Topic 1D: Create a Hyperlink
Topic 1E: Use Web-based Research Tools
Lesson 2: Creating and Modifying Charts
Topic 2A: Create a Chart
Topic 2B: Format Chart Items
Topic 2C: Change the Chart Type
Topic 2D: Create a Diagram
Lesson 3: Working with Graphic Objects
Topic 3A: Insert Graphics
Topic 3B: Create AutoShapes
Topic 3C: Format Graphic Objects
Topic 3D: Change the Order of Graphic Objects
Topic 3E: Group Graphic Objects
Topic 3F: Move, Copy, and Resize Graphic Objects
Lesson 4: Calculating with Advanced Formulas
Topic 4A: Create and Apply a Name for a Range of Cells
Topic 4B: Calculate Across Worksheets
Topic 4C: Calculate with Date and Time Functions
Topic 4D: Calculate with Financial Functions
Topic 4E: Calculate with Statistical Functions
Topic 4F: Calculate with Lookup and Reference Functions
Topic 4G: Calculate with Logical Functions
Lesson 5: Sorting and Filtering Data
Topic 5A: Sort Data Lists
Topic 5B: Filter Data Lists
Topic 5C: Create and Apply Advanced Filters
Topic 5D: Calculate with Database Functions
Topic 5E: Add Subtotals to a Worksheet
Lesson 6: Using Excel with the Web
Topic 6A: Export Excel Data
Topic 6B: Publish a Worksheet to the Web
Topic 6C: Import Data from the Web
Topic 6D: Create a Web Query
Appendix A: Microsoft Office Specialist Program
|
Prerequisites: To ensure your success, we recommend you first take the following Element K courses or have equivalent knowledge:
Microsoft® Office Excel 2003: Level 1
Microsoft® Office Excel 2003: Level 2
Performance-based Objectives
Upon successful completion of this course, students will be able to:
Customize workbooks.
Collaborate with others using workbooks.
Audit worksheets.
Analyze data.
Work with multiple workbooks.
Import and export data.
Structure workbooks with XML.
Lesson 1: Streamlining Workflow
Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Customize Access to Excel Commands
Topic 1D: Apply Conditional Formatting
Topic 1E: Add Data Validation Criteria
Topic 1F: Update a Workbook's Properties
Topic 1G: Modify Excel's Default Settings
Lesson 2: Collaborating with Others
Topic 2A: Protect Files
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Adjust Macro Settings
Topic 2G: Administer Digital Signatures
Lesson 3: Auditing Worksheets
Topic 3A: Trace Cell Precedents
Topic 3B: Trace Cell Dependents
Topic 3C: Locate Errors in Formulas
Topic 3D: Locate Invalid Data and Formulas
Topic 3E: Watch and Evaluate Formulas
Topic 3F: Group and Outline Data
Lesson 4: Analyzing Data
Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Develop a PivotTable© Report
Topic 4E: Develop a PivotChart© Report
Topic 4F: Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links
Lesson 6: Importing and Exporting Data
Topic 6A: Export to Microsoft Word
Topic 6B: Import a Word Table
Topic 6C: Import Text Files
Lesson 7: Structuring XML Workbooks
Topic 7A: Develop XML Maps
Topic 7B: Import, Add, and Export XML Data
Topic 7C: Manage XML Workbooks
Topic 7D: Apply XML View Options
Upon successful completion of this course, students will be able to:
create a Web site that includes new and existing Web pages.
add images to Web pages.
add links to Web pages.
add and format tables.
format a Web page.
design layouts for your Web pages.
use Navigation view to structure a Web site.
publish a FrontPage web.
Lesson 1: Creating a Web
Topic 1A: Overview of Web Development
Topic 1B: Create a New Web Site
Topic 1C: Create and Format Web Page Text
Topic 1D: Create Pages
Topic 1E: Import Web Pages
Lesson 2: Adding Images
Topic 2A: Add a Picture to a Web Page
Topic 2B: Edit a Picture
Topic 2C: Add a New Drawing
Topic 2D: Add a Photo Gallery
Topic 2E: Modify a Photo Gallery
Lesson 3: Creating Links
Topic 3A: Add Hyperlinks
Topic 3B: Add Bookmark Links
Topic 3C: Link from an Image
Lesson 4: Adding Tables
Topic 4A: Insert a Table
Topic 4B: Set Table Properties
Topic 4C: Set Cell Properties
Topic 4D: Edit a Table's Structure
Topic 4E: Split Tables
Topic 4F: AutoFormat a Table
Lesson 5: Formatting a Web Page
Topic 5A: Apply a Theme
Topic 5B: Customize a Theme
Topic 5C: Create and Format with Styles
Topic 5D: Set the Background
Topic 5E: Test in Multiple Browsers
Lesson 6: Designing Your Web Pages
Topic 6A: Design a Web Page Layout
Topic 6B: Lay Out a Web Page with Tables
Topic 6C: Create and Apply a Dynamic Web Template
Lesson 7: Structuring a Web Site with Navigation View
Topic 7A: Create a Navigation Structure
Topic 7B: Modify a Navigation Structure
Topic 7C: Remove a Web Page from a Web's Navigation Structure
Lesson 8: Publishing a Web
Topic 8A: Prepare Your Web Site for Publishing
Topic 8B: Publish Your Web
Topic 8C: Publish a Web Site from One Location to Another
Upon successful completion of this course, students will be able to:
use frames to display several pages of Web content within a single browser window.
add user navigation components to your site, including search, image maps, and a table of contents.
create Web forms and save collected data to a file and a database.
add dynamic content to Web pages.
manage workgroup-based development of FrontPage webs.
maintain a site with FrontPage tools.
Lesson 1: Laying Out a Page with Frames
Topic 1A: Create Frames Pages
Topic 1B: Add Links to Frames Pages
Topic 1C: Modify Frames
Topic 1D: Create an Inline Frame
Lesson 2: Adding User Navigation Components
Topic 2A: Add Search Capabilities
Topic 2B: Create an Image Map
Topic 2C: Insert a Link Bar
Topic 2D: Create a Table of Contents
Lesson 3: Working with Forms
Topic 3A: Create a Form
Topic 3B: Modify Field Properties
Topic 3C: Send Form Data to a File
Topic 3D: Send Form Data to a Database
Lesson 4: Displaying Dynamic Content
Topic 4A: Share Content Between Pages
Topic 4B: Add an Interactive Button
Topic 4C: Swap Images
Topic 4D: Display Database Information on a Page
Topic 4E: Insert Redirect Meta Tags
Topic 4F: Add a Chart
Lesson 5: Managing Workgroup Development
Topic 5A: Manage Tasks
Topic 5B: Manage Files with Source Control
Topic 5C: Manage a File's Review Status
Topic 5D: Secure a Web
Lesson 6: Maintaining a Site
Topic 6A: Manage Web Folders
Topic 6B: Manage Web Files
Topic 6C: Correct Broken Hyperlinks
Topic 6D: Analyze a Web's Usage
Topic 6E: Display a Top 10 List for Visitors
Topic 6F: Change Default Documents
Upon successful completion of this course, students will be able to:
explore the types of applications you can build, how the user interface can be used, and how to create Flash movies.
create and manipulate graphics in your Flash document.
add text and Flash components to your Flash document.
animate graphics using different techniques.
add interactivity to your Flash document using buttons.
work with movie clips.
add audio to a movie.
add video to a movie for creating dynamic animations in Flash.
publish Flash documents.
Topic 1A: Examine Rich Internet Applications
Topic 1B: Explore the Adobe Flash CS3 Environment
Topic 1C:
Produce a Flash
Application File
Topic 2A: Import Graphics
Topic 2B: Create Vector Graphics
Topic 2C: Modify Vector Graphics
Topic 2D: Organize Content with Layers
Topic 2E: Modify Colors
Topic 2F: Convert Graphics to Symbols
Topic 2G: Create
a Mask Effect
Topic 3A: Add Text to a Flash Document
Topic 3B: Set Font Options
Topic 3C: Add Input Text Using Flash Components
Topic 3D: Apply
a Skin to a
Component
Topic 4A: Create a Frame-by-Frame Animation
Topic 4B: Create a Motion Tween Animation
Topic 4C: Create a Complex Motion Tween
Topic 4D: Control the Timeline with ActionScript
Topic 4E: Create a Shape Tween Animation
Topic 4F: Animate Using Timeline Effects
Topic 5A: Create Buttons
Topic 5B: Control Movies with Button Behaviors
Topic 5C: Create
Navigation Systems
Topic 6A: Add Interactivity with Movie Clips
Topic 6B: Create a Flash Slide Presentation
Topic 6C: Apply
Effects to Movie
Clips
Topic 7A: Import Audio
Topic 7B: Control Sound Playback
Topic 7C: Add
Sounds with
Behaviors
Topic 8A: Encode a Video Object
Topic 8B: Create
a Video Object
Topic 9A: Publish a Flash Document
Topic 9B: Detect the Flash Player Version
|
Prerequisites: To ensure the successful completion of Adobe Dreamweaver CS3: Level 1, the student should have an understanding of how to use Microsoft Windows 2000 or Windows XP operating systems.
Upon successful completion of this course, students will be able to:
prepare to use the Dreamweaver environment.
create a website.
add design elements to web pages.
work with links.
work with frames.
upload a website.
Topic 1A: Examine the Basic Concepts of Web Designing
Topic 1B: Explore the Dreamweaver Environment
Topic 1C:
Customize the
Workspace
Topic 2A: Define a Website
Topic 2B: Create a Web Page
Topic 2C: Format a Web Page
Topic 2D: Organize Files and Folders
Topic 2E: Create
Templates
Topic 3A: Insert Images
Topic 3B: Insert Tables
Topic 3C: Create
Repeating Region
Templates
Topic 4A: Create Hyperlinks
Topic 4B: Create Email Links
Topic 4C: Create Image Maps
Topic 4D: Create
Anchors
Topic 5A: Create Framesets
Topic 5B:
Enhance Frames
Topic 6A: Ensure Accessibility
Topic 6B: Upload
Files onto a Site
|
Prerequisites: Before taking this course, students should have completed the Adobe® Dreamweaver® CS3: Level 1 course or possess equivalent knowledge.
Upon successful completion of this course, students will be able to:
work in Code view using the coding features of Dreamweaver.
format content using style sheets.
create an effective user-navigation interface.
work with AP elements to enhance the layout and positioning of elements on a web page.
automate tasks.
create forms.
author a web page using XML-based data.
Lesson 1: Working in Code View
Topic 1A: Use Coding Tools
Topic 1B: Search for and Replace Code
Topic 1C: Use Design Notes and Comments
Lesson 2: Formatting with Style Sheets
Topic 2A: Create CSS Styles
Topic 2B: Apply External Styles to Multiple Pages
Topic 2C: Redefine Style Sheets
Lesson 3: Creating an Effective User-Navigation Interface
Topic 3A: Create Rollovers
Topic 3B: Create a Navigation Bar
Topic 3C: Add Flash Buttons and Text to a Page
Topic 3D: Use the Spry User Interface Widgets
Topic 3E: Add Spry Effects
Lesson 4: Working with AP Elements
Topic 4A: Create AP Elements
Topic 4B: Control AP Elements Dynamically
Topic 4C: Insert Rich Media Objects into an AP Element
Lesson 5: Automating Tasks
Topic 5A: Add Library Items from Site Pages
Topic 5B: Place Library Items onto Site Pages
Topic 5C: Use Snippets
Topic 5D: Replay Actions Using the History Panel
Lesson 6: Creating Forms
Topic 6A: Set Up Forms
Topic 6B: Add Form Elements
Topic 6C: Validate Forms
Lesson 7: Authoring with XML-Based Data
Topic 7A: Integrate XML-Based Data
Topic 7B: Display XML Data Using Spry
Appendix A: Integrating Other Applications with Dreamweaver
Supplemental Lesson Integrating Other Applications with Dreamweaver
Topic 1A: Import Word Documents into Dreamweaver
Topic 1B: Import Excel Worksheets into Dreamweaver
Topic 1C: Explore the Adobe Bridge Environment
Topic 1D: Apply Metadata and Keywords to Assets in Adobe Bridge
Topic 1E: Integrate Photoshop Images in Dreamweaver
Topic 1F: Preview Web Pages in Device Central
Appendix B: Adobe® Certified Expert (ACE) Program
|
Prerequisites: Before taking this course, the student should complete the following Element K courses, or have equivalent knowledge:
Adobe® Dreamweaver® CS3: Level 1
Adobe® Dreamweaver® CS3: Level 2
HTML 4.01 Web Authoring
Microsoft® Office Access: Level 1
Upon successful completion of this course, students will be able to:
establish database connectivity.
work with recordsets.
create interactive page elements.
administer database records.
create a user authentication system.
administer websites.
Topic 1A: Connect to a Server Using a Server Technology
Topic 1B: Identify the Components of a Database-Driven Site
Topic 1C: Create
a Connection to a
Database
Topic 2A: Create Recordsets
Topic 2B: Display Records
Topic 2C: Page
Through Recordsets
Topic 3A: Create Master and Detail Pages
Topic 3B: Create Search and Results Pages
Topic 3C: Use
Dynamic Form
Elements
Topic 4A: Insert Records
Topic 4B: Edit Records
Topic 4C: Delete
Records
Topic 5A: Create a User Registration Form
Topic 5B: Secure
Web Pages
Topic 6A: Transfer Files to Servers
Topic 6B: Manage
Websites
|
Lesson 1:
The Fireworks Environment Topic 1A: An Overview of Fireworks Task 1A-1:
Previewing a Web Page in Fireworks Topic 1B: Vector and Bitmap Graphics Topic
1C: Fireworks Environment Elements Task 1C-1: Exploring a Fireworks Document
Task 1C-2: Accessing and Arranging Fireworks Panels Topic 1D: Navigating in
Fireworks Task 1D-1: Zooming and Navigating Task 1D-2: Resizing the Fireworks
Window Task 1D-3: Navigating Using Shortcuts
Lesson 2:
Creating Vector Graphics Topic 2A: Drawing Tools Task 2A-1: Drawing with the
Pencil Tool Task 2A-2: Drawing Straight Segments with the Pencil Tool Task 2A-3:
Drawing Line Segments with the Line Tool Topic 2B: Object Drawing Tools Task
2B-1: Rectangle Tool Task 2B-2: The Ellipse Tool Task 2B-3: Polygon Tool Topic
2C: Modifying Vector Graphics Task 2C-1: Using the Stroke Panel Task 2C-2:
Editing Fills Task 2C-3: Gradient Fills Task 2C-4: Applying Pattern Fills
Lesson 3:
Transforming Vector Images and Effects Topic 3A: Combining Shapes Task 3A-1:
Combining Vector Shapes Task 3A-2: Expanding Strokes Topic 3B: Arranging and
Transforming Task 3B-1: Aligning Objects Task 3B-2: Adjusting the Stacking Order
Task 3B-3: Using Layers Task 3B-4: Scaling Objects Task 3B-5: Skewing and
Distorting Objects Task 3B-6: Knife Tool Task 3B-7: Grouping Task 3B-8: Using
Rulers, Grids, and Guides Topic 3C: Applying Effects Task 3C-1: Applying Glow
Task 3C-2: Applying a Drop Shadow
Lesson 4:
Bitmap Images Topic 4A: Bitmap Basics Task 4A-1: Importing Bitmaps Task 4A-2:
Enlarging Bitmap Images Task 4A-3: Cropping Bitmap Images Topic 4B: Editing
Bitmap Images Task 4B-1: Bitmap Mode Task 4B-2: Creating Selections Task 4B-3:
Painting Bitmap Images Topic 4C: Effects with Bitmap Images Task 4C-1: Applying
Effects to Bitmap Images Topic 4D: Effects with Bitmap Images Task 4D-1: Vector
and Bitmap Graphics
Lesson 5:
Using Text Topic 5A: Creating Text Task 5A-1: Adding Text Task 5A-2: Applying
Effects to Text Topic 5B: Merging Text and Graphics Task 5B-1: Combining Text
with Vectors Task 5B-2: Converting Text to Paths Topic 5C: Merging Text and
Graphics Task 5C-1: Adding Text
Lesson 6:
Optimizing Graphics for the Web Topic 6A: Web Graphic File Formats Topic 6B:
Optimizing Images Task 6B-1: Optimizing Photographic Images Task 6B-2:
Optimizing Flat Color Graphics
Lesson 7:
Hotspot Links Topic 7A: Creating Hotspots Task 7A-1: Adding Hotspots Topic 7B:
Assigning Links to Hotspots Task 7B-1: Assigning Links
Lesson 8:
Slicing and Rollovers Topic 8A: Slicing Task 8A-1: Slicing and Optimizing Topic
8B: Rollovers Task 8B-1: Creating Drag and Drop Rollovers Task 8B-2: Using Live
Effects in Rollovers Task 8B-3: Custom Rollovers Task 8B-4: Creating Disjoint
Rollovers Task 8B-5: Exporting Task 8B-6: Using Fireworks Files in Dreamweaver
Lesson 1:
Vector Paths Topic 1A: Vector Path Concepts Topic 1B: Drawing and Editing Rough
Paths Task 1B-1: Using the Pencil Tool Task 1B-2: Simplifying and Reshaping
Paths Topic 1C: Creating Paths Precisely with the Pen Tool Task 1C-1: Creating
Straight Segments Task 1C-2: Creating Curved Segments Task 1C-3: Creating
Multiple Segment Paths Task 1C-4: Creating Sharp Corners Task 1C-5: Combining
Straight and Curved Segments Task 1C-6: Editing Paths Task 1C-7: Adding and
Editing Anchor Points Topic 1D: Text and Paths Task 1D-1: Wrapping Text on a
Path Task 1D-2: Converting Text to Paths
Lesson 2:
Image Effects Topic 2A: Improving Sharpness and Contrast Task 2A-1: Unsharp
Masking Task 2A-2: Using Levels to Adjust Contrast Task 2A-3: Using Curves to
Adjust Contrast Topic 2B: Editing Images Task 2B-1: Using the Rubber Stamp Tool
Task 2B-2: Cropping Image Areas Topic 2C: Patterns Task 2C-1: Using Patterns
Topic 2D: Masking Task 2D-1: Creating Mask Groups Topic 2E: Saving Effects and
Styles Task 2E-1: Saving and Applying Multiple Effects Task 2E-2: Creating and
Applying Styles
Lesson 3:
Advanced Rollovers and Slicing Topic 3A: Triggering Rollovers from Polygonal
Areas Task 3A-1: Preparing Slices for Rollover Effects Task 3A-2: Creating and
Preparing Frames Task 3A-3: Creating Rollover Behaviors for Hotspots Topic 3B:
Pop-Up Menus Task 3B-1: Creating Pop-Up Menus Topic 3C: Behaviors Task 3C-1:
Creating and Editing Behaviors Topic 3D: Nav Bars Task 3D-1: Creating a
Multi-State Nav Bar Task 3D-2: Custom-Naming Slices and Assigning URLs Task
3D-3: Creating a Down State Button
Lesson 4:
Symbols, Instances, and Animation Topic 4A: Button Symbols Task 4A-1: Creating
Button Symbols Task 4A-2: Editing Button Symbols Topic 4B: Graphic Symbols Task
4B-1: Creating Graphic Symbols Task 4B-2: Updating Instances in Multiple Files
Topic 4C: Creating Animation Task 4C-1: Creating an Animation Symbol Task 4C-2:
Tweening Instances of Graphic Symbols Task 4C-3: Preparing Animation for Export
Lesson 5:
Exporting Pages for a Website Topic 5A: Text Slices Task 5A-1: Creating HTML
Text Slices Topic 5B: HTML Export Options Task 5B-1: Exporting to HTML and
Images
Lesson 1:
Overview of HTML Overview Introduction to HTML Creating an HTML
document
Lesson 2:
Formatting text with HTML Paragraph formatting with HTML Character
formatting with HTML Comparing procedural and descriptive formatting
Lesson 3:
Adding local and remote links Adding local links Adding remote links
Adding internal links with the named anchor tag
Lesson 4:
Adding graphics and sound Linking to and embedding graphics Linking to
multimedia files
Lesson 5:
Creating lists in HTML Creating lists Creating nested lists
Lesson 6:
Creating tables in HTML Creating and modifying tables Creating
advanced table elements
Lesson 7:
Setting body and background attributes Setting backgrounds and text
colors
Lesson 8:
Web page design guidelines Web page style considerations
Lesson 9:
Adding links to other Internet services Links to non-Web Internet
services
Lesson 1:
Advanced tables
A. Creating nested tables B. Using tables for page layout
Lesson 2:
Graphics
A. Incorporating graphics into a document B. Creating and using imagemaps
Lesson 3:
Creating forms
A. Introduction to forms
Lesson 4:
Advanced forms
A. Using advanced input types B. Setting input type attributes C. Creating a
text area D. Creating form list boxes
Lesson 5:
Frames
A. Overview of frames B. Creating frames C. Applying frame attributes D. Using
nested framesets
Lesson 6:
Dynamic and interactive documents
A. Interactive Web pages B. JavaScript in HTML documents C. Java in HTML
documents
Lesson 7:
Cascading Style Sheets (CSS-1)
A. Introduction to style sheets (CSS-1) B. Working with style sheet properties
and selectors C. Linked style sheets
Prerequisites: This course assumes that you are able to use Windows to manage information on your computer and that you have an intermediate knowledge of Outlook. The following courses (or equivalent knowledge thereof) are required: Either Windows XP: Introduction or Windows 2000: Introduction Windows XP Professional: Levels 1 & 2 (if using Windows XP) Microsoft® Office Outlook® 2003: Levels 1 & 2 Microsoft® Office Word 2003: Level 1
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
Communicate using MSN Messenger.
Personalize your mail by using stationery and signatures.
Organize Outlook items by grouping, creating Search Folders, setting rules, and applying conditional formatting.
Use contacts to share, link, and communicate information.
Save and archive mail.
Create a custom form.
Set up your computer for offline and remote use.
Course Content
Lesson 1: Communicating Using MSN Messenger
Topic 1A: Obtain a Hotmail Account
Topic 1B: Add Contacts
Topic 1C: Send and Receive Instant Messages
Topic 1D: Attach a File
Topic 1E: Change MSN Messenger Status
Topic 1F: Change MSN Messenger Options
Lesson 2: Personalizing Your Mail
Topic 2A: Use Stationery
Topic 2B: Create Custom Stationery
Topic 2C: Create Signatures
Topic 2D: Modify Signatures
Lesson 3: Organizing Outlook Items
Topic 3A: Group Items
Topic 3B: Create Search Folders
Topic 3C: Create Rules
Topic 3D: Apply Conditional Formatting
Lesson 4: Working with Contacts
Topic 4A: Forward Contacts
Topic 4B: Create a vCard from a Contact
Topic 4C: Export Contacts
Topic 4D: Perform a Mail Merge
Topic 4E: Link Items to a Contact
Lesson 5: Saving and Archiving Mail
Topic 5A: Save Messages in Alternate Formats
Topic 5B: Archive Messages
Topic 5C: Protect Personal Folders
Lesson 6: Creating a Custom Form
Topic 6A: Add Form Fields
Topic 6B: Save a Form
Topic 6C: Test a Form
Lesson 7: Working Offline and Remotely
Topic 7A: Create an Offline Folder File
Topic 7B: Make a Folder Available Offline
Topic 7C: Create a Send/Receive Group
Topic 7D: Download Messages
|
|
Prerequisites: Students must be familiar with Microsoft Windows XP, 2000 or
Vista, and a word processing software such as Microsoft Word.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
explore the FrameMaker user interface.
create a new layout.
edit a FrameMaker document.
format documents.
create lists.
control formatting and text flow.
create page layouts from master pages.
output FrameMaker documents in different formats.
Topic 1A: Explore the FrameMaker Interface
Topic 1B: Customize the User Interface
Topic 1C: Manage Multiple Documents
Topic 2A: Create a New Document
Topic 2B: Add Content to Pages
Topic 2C: Create a New Document from a Template
Topic 3A: Edit Text
Topic 3B: Check Spelling Using the Spell Checker
Topic 3C: Replace Text Using the Find/Change Utility
Topic 3D: Track Text Edits
Topic 4A: Apply Character Formatting
Topic 4B: Apply Paragraph Formatting
Topic 4C: Set Tabs in Paragraphs
Topic 5A: Create Lists from Default Formats
Topic 5B: Create Custom List Formats
Topic 5C: Create a Nested Sequential List
Topic 6A: Apply Selective Formatting
Topic 6B: Set Page Breaks
Topic 6C: Control Widows and Orphans
Topic 7A: Create Headers and Footers
Topic 7B: Resize a Text Frame
Topic 7C: Create Side Headings
Topic 8A: Print a Document
Topic 8B: Create a PDF File from a FrameMaker Document
Topic 8C: Create an HTML File from a FrameMaker Document
Topic 8D: Create an XML File from a FrameMaker Document
Prerequisites: To ensure your success, we recommend that you first take the following Element K course or have equivalent knowledge: Adobe® FrameMaker® 8.0: Level 1
Upon successful completion of this course, students will be able to:
organize information using tables.
work with graphics.
work with anchored frames.
create master pages.
set up multi-column layouts.
build and output a FrameMaker document.
Topic 1A: Create a Table
Topic 1B: Modify Table Structure and Data
Topic 1C: Enhance Table Appearance
Topic 1D: Format Table Structure and Data
Topic 1E: Customize a Table Format
Topic 2A: Draw Simple Lines and Shapes
Topic 2B: Create an Equation
Topic 2C: Format Objects
Topic 2D: Import Graphics
Topic 2E: Modify Graphics
Topic 3A: Create Anchored Frames
Topic 3B: Work with Anchored Text Frames
Topic 3C: Work with Reference Frames and Graphics
Topic 4A: Import an Existing Document
Topic 4B: Create Custom Master Pages
Topic 4C: Work with Multiple Text Frames
Topic 4D: Work with Variables
Topic 4E: Apply Custom Master Pages
Topic 5A: Create Columns
Topic 5B: Create Flow Tags
Topic 5C: Add a Disconnected Page
Topic 6A: Create Cross-References
Topic 6B: Create Generated Files
Topic 6C: Create an Index
Topic 6D: Create a Book
Topic 6E: Prepare a Document for Printing
Topic 1A: Explore a Structured Document
Topic 1B: Work with Elements
Topic 1C: Manage Conditional Tags
Topic 1D: Enhance Structured Documents
Topic 1E: Validate Structured Documents