Shelly G.B., Vermaat M.E. Microsoft Office 2010: Essential

Course Technology, 2010. — 408 p. — ISBN: 0538748702, 9780538748704.Introduce your students to the new generation of Microsoft Office with the new generation of Shelly Cashman Series books! For the past three decades, the Shelly Cashman Series has effectively introduced computer skills to millions of students. With Office 2010, we're continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today's students. In Microsoft Office 2010: ESSENTIAL you'll find features that are specifically designed to engage students, improve retention, and prepare them for future success. Our trademark step-by-step, screen-by-screen approach now encourages students to expand their understanding of the Office 2010 software through experimentation, exploration, and planning ahead. Brand new end of chapter exercises prepare students to become more capable software users by requiring them to use critical thinking and problem-solving skills to create real-life documents.Office 2010 and Windows 7: Essential Concepts and Skills.
Objectives.
Office 2010 and Windows 7.
Overview.
Introduction to the Windows 7 Operating System.
Using a Mouse.
Scrolling.
Shortcut Keys.
Starting Windows 7.
To Log On to the Computer.
The Windows 7 Desktop.
Introduction to Microsoft Office 2010.
Microsoft Office 2010 Programs.
Microsoft Office 2010 Suites.
Starting and Using a Program.
Word.
To Start a Program Using the Start Menu.
To Maximize a Window.
The Word Document Window, Ribbon, and Elements Common to Office Programs.
To Display a Different Tab on the Ribbon.
To Minimize, Display, and Restore the Ribbon.
To Display and Use a Shortcut Menu.
To Customize the Quick Access Toolbar.
To Enter Text in a Document.
Saving and Organizing Files.
Organizing Files and Folders.
To Create a Folder.
Folder Windows.
To Create a Folder within a Folder.
To Expand a Folder, Scroll through Folder
Contents, and Collapse a Folder.
To Switch from One Program to Another.
To Save a File in a Folder.
Navigating in Dialog Boxes.
To Minimize and Restore a Window.
Screen Resolution.
To Change the Screen Resolution.
To Quit an Office Program with One Document Open.
Additional Microsoft Office Programs.
PowerPoint.
To Start a Program Using the Search Box.
The PowerPoint Window and Ribbon.
To Enter Content in a Title Slide.
To Create a New Office Document from the Backstage View.
To Close an Office File Using the Backstage View.
To Open a Recent Office File Using the Backstage View.
Excel.
To Create a New Blank Office Document from Windows Explorer.
To Start a Program from Windows Explorer and Open a File.
Unique Features of Excel.
To Enter a Worksheet Title.
To Save an Existing Office Document with the Same File Name.
Access.
Unique Elements in Access.
To Create an Access Database.
To Open an Existing Office File.
Other Office Programs.
Outlook.
Publisher.
OneNote.
Moving, Renaming, and Deleting Files.
To Rename a File.
To Move a File.
To Delete a File.
Microsoft Office and Windows Help.
To Open the Help Window in an Office Program.
Moving and Resizing Windows.
To Move a Window by Dragging.
To Resize a Window by Dragging.
Using Office Help.
To Obtain Help Using the 'Type words to search for' Text Box.
To Obtain Help Using the Help Links.
To Obtain Help Using the HelpObtaining Help while Working in an Office Program.
Using Windows Help and Support.
To Start Windows Help and Support.
Chapter Summary.
Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Microsoft Word 2010.
Creating, Formatting, and Editing a Word Document with Pictures
Objectives.Project – Flyer with Pictures.
Overview.
Entering Text.
To Type Text.
To Display Formatting Marks.
To Insert a Blank Line.
Wordwrap.
To Wordwrap Text as You Type.
Spelling and Grammar Check.
To Check Spelling and Grammar as You Type.
Navigating a Document.
Formatting Paragraphs and Characters.
To Center a Paragraph.
Formatting Single versus Multiple Paragraphs and Characters.
To Select a Line.
To Change the Font Size of Selected Text.
To Change the Font of Selected Text.
To Change the Case of Selected Text.
To Apply a Text Effect to Selected Text.
To Shade a Paragraph.
To Select Multiple Lines.
To Bullet a List of Paragraphs.
To Undo and Redo an Action.
To Italicize Text.
To Color Text.
To Use the Mini Toolbar to Format Text.
To Select a Group of Words.
To Underline Text.
To Bold Text.
To Change Theme Colors.
Selecting Text.
Inserting and Formatting Pictures in a Word Document.
To Insert a Picture.
To Zoom the Document.
To Resize a Graphic.
To Resize a Graphic by Entering Exact Measurements.
To Apply a Picture Style.
To Apply Picture Effects.
Enhancing the Page.
To View One Page.
To Add a Page Border.
To Change Spacing before and after a Paragraph.
Correcting Errors and Revising a Document.
Types of Changes Made to Documents.
To Insert Text in an Existing Document.
Deleting Text from a Document.
To Delete Text.
To Move Text.
Changing Document Properties.
To Change Document Properties.
Printing a Document.
To Print a Document.
Chapter Summary.
Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Microsoft PowerPoint 2010.
Creating and Editing a Presentation with Clip Art
Objectives.Project – Presentation with Bulleted Lists and Clip Art.
Overview.
Choosing a Document Theme.
To Choose a Document Theme.
Creating a Title Slide.
To Enter the Presentation Title.
Correcting a Mistake When Typing.
Paragraphs.
To Enter the Presentation Subtitle Paragraph.
Formatting Characters in a Presentation.
Fonts and Font Styles.
To Select a Paragraph.
To Italicize Text.
To Increase Font Size.
To Select a Word.
To Change the Text Color.
Adding a New Slide to a Presentation.
To Add a New Text Slide with a Bulleted List.
Creating a Text Slide with a Multi-Level Bulleted List.
To Enter a Slide Title.
To Select a Text Placeholder.
To Type a Multi-Level Bulleted List.
To Select a Group of Words.
To Bold Text.
Adding New Slides and Changing the Slide Layouts.
To Add a Slide with the Title Only Layout.
To Add a New Slide and Enter a Slide Title and Headings.
PowerPoint Views.
To Move to Another Slide in Normal View.
Inserting Clip Art and Photographs into Slides.
The Clip Art Task Pane.
To Insert a Clip from the Clip Organizer into the Title Slide.
To Insert a Clip from the Clip Organizer into a Content Placeholder.
Photographs and the Clip Organizer.
Resizing Clip Art and Photographs.
To Resize Clip Art.
To Move Clips.
Ending a Slide Show with a Closing Slide.
To Duplicate a Slide.
To Arrange a Slide.
Making Changes to Slide Text Content.
Replacing Text in an Existing Slide.
Deleting Text.
To Delete Text in a Placeholder.
Adding a Transition.
To Add a Transition between Slides.
Changing Document Properties.
To Change Document Properties.
Viewing the Presentation in Slide Show View.
To Start Slide Show View.
To Move Manually through Slides in a Slide Show.
Printing a Presentation.
To Print a Presentation.
Chapter Summary.
Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Microsoft Excel 2010.
Creating a Worksheet and an Embedded Chart.
Objectives.Project – Worksheet with an Embedded Chart.
Overview.
Selecting a Cell.
Entering Text.
To Enter the Worksheet Titles.
AutoCorrect.
To Enter Column Titles.
To Enter Row Titles.
Entering Numbers.
To Enter Numbers.
Calculating a Sum.
To Sum a Column of Numbers.
Using the Fill Handle to Copy a Cell to Adjacent Cells.
To Copy a Cell to Adjacent Cells in a Row.
To Determine Multiple Totals at the
Same Time.
Formatting the Worksheet.
Font, Style, Size, and Color.
To Change a Cell Style.
To Change the Font.
To Bold a Cell.
To Increase the Font Size of a Cell Entry.
To Change the Font Color of a Cell Entry.
To Center Cell Entries Across Columns by
Merging Cells.
To Format Column Titles and the Total Row.
To Format Numbers in the Worksheet.
To Adjust the Column Width.
Using the Name Box to Select a Cell.
To Use the Name Box to Select a Cell.
Other Ways to Select Cells.
Adding a Clustered Cylinder Chart to the
Worksheet.
To Add a Clustered Cylinder Chart to the Worksheet.
Changing the Worksheet Names.
To Change the Worksheet Names.
Changing Document Properties.
To Change Document Properties.
To Save an Existing Workbook with the Same File Name.
Previewing and Printing a Worksheet.
To Preview and Print a Worksheet in
Landscape Orientation.
Starting Excel and Opening a Workbook.
AutoCalculate.
To Use the AutoCalculate Area to Determine a Maximum.
Correcting Errors.
Correcting Errors While You Are Typing Data into a Cell.
Correcting Errors After Entering Data into a Cell.
Undoing the Last Cell Entry.
Clearing a Cell or Range of Cells.
Clearing the Entire Worksheet.
Chapter Summary.
Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Microsoft Access 2010.
Databases and Database Objects: An Introduction.
Objectives.Project – Database Creation.
Overview.
Designing a Database.
Database Requirements.
Naming Tables and Fields.
Identifying the Tables.
Determining the Primary Keys.
Determining Additional Fields.
Determining and Implementing Relationships Between the Tables.
Determining Data Types for the Fields.
Identifying and Removing Redundancy.
Creating a Database.
The Access Window.
Navigation Pane and Access Work Area.
Creating a Table.
To Modify the Primary Key.
To Define the Remaining Fields in a Table.
Making Changes to the Structure.
To Save a Table.
To View the Table in Design View.
Checking the Structure in Design View.
To Close the Table.
To Add Records to a Table.
Making Changes to the Data.
Starting Access and Opening a Database.
To Add Additional Records to a Table.
To Resize Columns in a Datasheet.
Previewing and Printing the Contents of a Table.
To Preview and Print the Contents of a Table.
Creating Additional Tables.
To Create a Table in Design View.
Correcting Errors in the Structure.
Importing Data from Other Applications to Access.
To Import an Excel Worksheet.
Additional Database Objects.
To Use the Simple Query Wizard to Create a Query.
Using Queries.
To Use a Criterion in a Query.
Creating and Using Forms.
To Create a Form.
Using a Form.
Creating and Printing Reports.
To Create a Report.
Using Layout View in a Report.
To Modify Column Headings and Resize Columns.
To Add Totals to a Report.
Database Properties.
To Change Database Properties.
Special Database Operations.
Backup and Recovery.
Compacting and Repairing a Database.
Additional Operations.
Chapter Summary.
Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Appendices:
Project Planning Guidelines.
Using Project Planning Guidelines.
Determine the Project's Purpose.
Analyze Your Audience.
Gather Possible Content.
Determine What Content to Present to Your Audience.Publishing Office 2010 Web Pages Online.
Using an Office Program to Publish Office
Web Pages.Saving to the Web Using Windows Live SkyDrive.To Save a File to Windows Live SkyDrive.
Web Apps.
To Download a File from Windows Live SkyDrive.
Collaboration.Quick Reference Summary.