 |
|
Microsoft® Office Word 2007 Exam 77-601
1. Creating and Customizing Documents
1.1. Create and format documents
1.2. Lay out documents
1.3. Make documents and content easier to find
1.4. Personalize Office Word 2007.
2. Formatting Content
2.1. Format text and paragraphs
2.2. Manipulate text
2.3. Control pagination
3. Working with Visual Content
3.1. Insert illustrations
3.2. Format illustrations
3.3. Format text graphically
3.4. Insert and modify text boxes
4. Organizing Content
4.1. Structure content by using Quick Parts
4.2. Use tables and lists to organize content
4.3. Modify tables
4.4. Insert and format references and captions
4.5. Merge documents and data sources
5. Reviewing Documents
5.1. Navigate documents.
5.2. Compare and merge document versions
5.3. Manage tracked changes
5.4. Insert, modify, and delete comments
6. Sharing and Securing Content
6.1. Prepare documents for sharing
6.2. Control document access
6.3. Attach digital signatures
Microsoft® Office Excel® 2007 Exam 77-602
1. Creating and Manipulating Data
1.1. Insert data by using AutoFill
1.2. Ensure data integrity
1.3. Modify cell contents and formats
1.4. Change Worksheet Views
1.5. Manage worksheets
2. Formatting Data and Content
2.1. Format worksheets
2.2. Insert and modify rows and columns
2.3. Format cells and cell content
2.4. Format data as a table
3. Creating and Modifying Formulas
3.1. Reference data in formulas
3.2. Summarize data using a formula.
3.3. Summarize data using subtotals.
3.4. Conditionally summarize data by using a formula
3.5. Look up data by using a formula.
3.6. Use conditional logic in a formula.
3.7. Format or modify text by using formulas.
3.8. Display and print formulas.
4. Presenting Data Visually
4.1. Create and format charts
4.2. Modify charts
4.3. Apply conditional formatting
4.4. Insert and modify illustrations
4.5. Outline data
4.6. Sort and filter data
5. Collaborating and Securing Data
5.1. Manage changes to workbooks
5.2. Protect and share workbooks
5.3. Prepare workbooks for distribution
5.4. Save workbooks
5.5. Set print options for printing data, worksheets, and workbooks
Microsoft® Office Access 2007 Exam 77-605
1. Structuring a Database
1.1. Define data needs and types
1.2. Define and print table relationships
1.3. Add, set, change, or remove primary keys
1.4. Split databases
2. Creating and Formatting Database Elements
2.1. Create databases
2.2. Create tables
2.3. Modify tables
2.4. Create fields and modify field properties
2.5. Create forms
2.6. Create reports
2.7. Modify the design of reports and forms
3. Entering and Modifying Data
3.1. Enter, edit, and delete records
3.2. Navigate among records
3.3. Find and replace data
3.4. Attach documents to and detach from records
3.5. Import data
4. Creating and modifying queries
4.1. Create queries
4.2. Modify queries
5. Presenting and Sharing Data
5.1. Sort data
5.2. Filter data
5.3. Create and modify charts
5.4. Export data
5.5. Save database objects as other file types
5.6. Print database objects
6. Managing and Maintaining Databases
6.1. Perform routine database operations
6.2. Manage Databases
Microsoft® Office PowerPoint® 2007 Exam 77-603
1. Creating and Formatting Presentations
1.1. Create new presentations
1.2. Customize slide masters.
1.3. Add elements to slide masters
1.4. Create and change presentation elements
1.5. Arrange slides
2. Creating and Formatting Slide Content
2.1. Insert and format text boxes.
2.2. Manipulate text.
2.3. Add and link existing content to presentations
2.4. Apply, customize, modify, and remove animations
3. Working With Visual Content
3.1. Create SmartArt diagrams
3.2. Modify SmartArt diagrams.
3.3. Insert illustrations and shapes.
3.4. Modify illustrations
3.5. Arrange illustrations and other content
3.6. Insert and modify charts
3.7. Insert and modify tables
4. Collaborating on and Delivering Presentations
4.1. Review presentations
4.2. Protect presentations.
4.3. Secure and Share Presentations
4.4. Prepare printed materials
4.5. Prepare for and rehearse presentation delivery
Microsoft® Office Outlook® 2007 Exam 77-604:
1. Managing Messaging
1.1. Create and send an e-mail message
1.2. Create and manage your signature and automated messages
1.3. Manage e-mail message attachments
1.4. Configure e-mail message sensitivity and importance settings
1.5. Configure e-mail message security settings
1.6. Configure e-mail message delivery options
1.7. View e-mail messages
2. Managing Scheduling
2.1. Create appointments, meetings, and events
2.2. Send meeting requests
2.3. Update, cancel, and respond to meeting requests
2.4. Customize calendar settings
2.5. Share your Calendar with others
2.6. View other calendars
3. Managing Tasks
3.1. Create, modify, and mark tasks as complete
3.2. Accept, decline, assign, update, and respond to tasks
4. Managing Contacts and Personal Contact Information
4.1. Create and modify contacts
4.2. Edit and use an electronic business card
4.3. Create and modify distribution lists
4.4. Create a secondary address book
5. Organizing Information
5.1. Categorize Office Outlook 2007 items by color
5.2. Create and manage Office Outlook 2007 data files
5.3. Organize mail folders
5.4. Locate Office Outlook 2007 items by using the search feature
5.5. Create, modify and remove rules to manage e-mail messages
5.6. Customize your Office Outlook 2007 Experience
|
