Зарегистрироваться
Восстановить пароль
FAQ по входу

Shoup K. Office 2010 Simplified

  • Файл формата pdf
  • размером 46,30 МБ
  • Добавлен пользователем , дата добавления неизвестна
  • Описание отредактировано
Shoup K. Office 2010 Simplified
Wiley Publishing, Inc., 2010. - 416 p.
ISBN: 0470571942
A clear, visual way to learn Office 2010 quickly and easily.
If you're looking for a way to get up to speed quickly on the newest version of MS Office, these 400 pages of step-by-step instructions and full-color screen shots make it easy. Office 2010 has new features and tools to master, and whether you're upgrading from an earlier version or encountering the Office applications for the first time, you'll appreciate this simplified approach.
This easy-to-follow guide covers Word, Excel, PowerPoint, Outlook, and Publisher. MS Office holds more than 90 percent of the market for Windows-based productivity suites.
More than 90 percent of Windows users use MS Office.
This guide covers all the Office applications: Word, Excel, PowerPoint, Outlook, and Publisher.
Designed for people who learn best visually, with step-by-step instructions illustrated with full-color screen shots throughout.
Revamped interior design makes it even easier to find and understand information.
Teaches dozens of common Office tasks.
Office 2010 Simplified makes this technology easy to understand, even for those who are completely new to computers.
Introduction to Computers.
Objectives.
What Is a Computer?
The Components of a Computer.
Personal Computers and Mobile Devices.
Desktop Computers.
Notebook Computers.
Mobile Devices.
Input Devices.
Keyboard.
Mouse and Other Pointing Devices.
System Unit.
Processor.
Memory.
Output Devices.
Printers.
Display Devices.
Storage Devices.
Hard Disks.
Flash Memory Storage.
Optical Discs.
Cloud Storage.
Communications Devices.
Computer Software.
System Software.
Application Software.
Networks and the Internet.
The Internet.
The World Wide Web.
Searching the Web.
Computer Viruses and Other Malware.
Buyer's Guide: How to Purchase Computers and Mobile Devices.
How to Purchase a Desktop Computer.
How to Purchase a Notebook Computer.
How to Purchase a Smart Phone.
How to Purchase a Portable Media Player.
How to Purchase a Digital Camera.
Learn It Online.
Case Studies.
Photo Credits.
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 Help Table of Contents.
Obtaining 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.
Creating a Research Paper with Citations.
Objectives.
Project – Research Paper.
Overview.
MLA Documentation Style.
Changing Document Settings.
Styles.
To Modify a Style.
Adjusting Line and Paragraph Spacing.
To Change Line Spacing.
To Remove Space after a Paragraph.
To Update a Style to Match a Selection.
Headers and Footers.
To Switch to the Header.
To Right-Align a Paragraph.
To Insert a Page Number.
To Close the Header.
Typing the Research Paper Text.
To Click and Type.
Shortcut Keys.
To Display the Rulers.
To First-Line Indent Paragraphs.
To AutoCorrect as You Type.
To Use the AutoCorrect Options Button.
To Create an AutoCorrect Entry.
The AutoCorrect Dialog Box.
Citations.
To Change the Bibliography Style.
To Insert a Citation and Create Its Source.
To Edit a Citation.
Footnotes.
To Insert a Footnote Reference Mark.
To Insert a Citation Placeholder.
Footnote Text Style.
To Modify a Style Using a Shortcut Menu.
To Edit a Source.
Working with Footnotes and Endnotes.
To Count Words.
Automatic Page Breaks.
Creating an Alphabetical Works Cited Page.
To Page Break Manually.
To Apply a Style.
To Create the Bibliographical List.
To Modify a Source and Update the Bibliographical List.
To Convert a Field to Regular Text.
Proofing and Revising the Research Paper.
To Scroll Page by Page through a Document.
Copying, Cutting, and Pasting.
To Copy and Paste.
To Display the Paste Options Menu.
To Find Text.
To Replace Text.
Find and Replace Dialog Box.
To Go to a Page.
To Find and Insert a Synonym.
To Check Spelling and Grammar at Once.
The Main and Custom Dictionaries.
To Use the Research Task Pane to Look Up Information.
Research Task Pane Options.
To Print Document Properties.
To Preview the Document and Then Print It.
Chapter Summary.
Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.
Creating a Business Letter with a Letterhead and Table
Objectives.
Project – Business Letter With a Letterhead and Table.
Overview.
To Change Margin Settings.
Creating a Letterhead.
To Insert a Shape.
To Apply a Shape Style.
To Add Text to a Shape.
To Use the Grow Font Button to Increase Font Size.
Floating versus Inline Objects.
To Change an Object's Text Wrapping.
To Insert Clip Art.
To Resize a Graphic to a Percent of the Original.
To Change the Color of a Graphic.
To Set a Transparent Color in a Graphic.
To Adjust the Brightness and Contrast of a Graphic.
To Change the Border Color on a Graphic.
To Move a Graphic.
To Use Paste Options.
To Flip a Graphic.
To Insert a Symbol from the Symbol Dialog Box.
To Insert a Symbol from the Symbol Gallery.
To Bottom Border a Paragraph.
To Clear Formatting.
AutoFormat as You Type.
To Convert a Hyperlink to Regular Text.
Creating a Business Letter.
To Create a New File from an Existing File.
To Apply a Quick Style.
Using Tab Stops to Align Text.
To Set Custom Tab Stops.
To Insert the Current Date in a Document.
To Create a Building Block.
To Modify a Building Block.
To Insert a Building Block.
Building Blocks versus AutoCorrect.
To Insert a Nonbreaking Space.
Tables.
To Insert an Empty Table.
To Enter Data in a Table.
To Apply a Table Style.
To Resize Table Columns to Fit Table Contents.
Selecting Table Contents.
To Align Data in Cells.
To Center a Table.
To Insert a Row in a Table.
Deleting Table Data.
To Merge Cells.
To Bullet a List as You Type.
Addressing and Printing Envelopes and Mailing Labels.
To Address and Print an Envelope.
Envelopes and Labels.
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.
Enhancing a Presentation with Pictures, Shapes, and WordArt.
Objectives.
Project – Presentation with Pictures, Shapes, and WordArt.
Overview.
Starting PowerPoint.
Creating Slides and Changing Font Colors and Background Style.
Presentation Template Color Scheme.
To Change the Presentation Theme Colors.
Inserting and Formatting Pictures in a Presentation.
To Insert a Picture.
To Insert a Picture into a Slide without a Content Placeholder.
To Correct a Picture.
To Apply a Picture Style.
To Apply Picture Effects.
To Add a Picture Border.
To Change a Picture Border Color.
To Resize a Graphic by Entering Exact Measurements.
Formatting Slide Backgrounds.
To Insert a Texture Fill.
To Insert a Picture to Create a Background.
To Format the Background Picture Fill Transparency.
To Format the Background Texture Fill Transparency.
To Choose a Background Style.
Formatting Title and Content Text.
To Change the Subtitle and Caption Font.
To Shadow Text.
Format Painter.
To Format Text Using the Format Painter.
Adding and Formatting a Shape.
To Add a Shape.
To Resize a Shape.
To Copy and Paste a Shape.
To Add Other Shapes.
To Apply a Shape Style.
To Add Formatted Text to a Shape.
Using WordArt.
To Insert WordArt.
To Change the WordArt Shape.
To Apply a WordArt Text Fill.
To Change the Weight of the WordArt Outline.
To Change the Color of the WordArt Outline.
Chapter Summary.
Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.
Reusing a Presentation and Adding Media.
Objectives.
Project – Presentation with Video, Audio, and Pictures with Effects.
Overview.
Starting PowerPoint.
Inserting Pictures and Adding Effects.
Adjusting Picture Colors.
To Color a Picture.
To Add an Artistic Effect to a Picture.
To Change the Stacking Order.
Modifying Placeholders and Deleting a Slide.
To Resize a Placeholder.
To Move a Placeholder.
To Align Paragraph Text.
To Delete a Slide.
Changing Views.
To Change Views.
Copying and Modifying a Clip.
To Copy a Clip from One Slide to Another.
To Zoom a Slide.
To Ungroup a Clip.
To Change the Color of a Clip Object.
To Delete a Clip Object.
To Regroup Objects.
Adding Media to Slides.
To Insert a Video File.
To Trim a Video File.
To Add Video Options.
To Insert an Audio File.
To Add Audio Options.
To Add a Video Style.
To Resize a Video.
To Insert a Movie Clip.
Reviewing and Revising Individual Slides.
Replace Dialog Box.
To Find and Replace Text.
To Find and Insert a Synonym.
To Add Notes.
Checking Spelling.
To Check Spelling.
To Insert a Slide Number.
To Preview and Print a Handout.
To Print Speaker Notes.
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.
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. 49 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.
Formulas, Functions, and Formatting.
Objectives.
Project – Worksheet with Formulas and Functions.
Overview.
Entering the Titles and Numbers into the Worksheet.
Entering Formulas.
To Enter a Formula Using the Keyboard.
Arithmetic Operations.
Order of Operations.
To Enter Formulas Using Point Mode.
To Copy Formulas Using the Fill Handle.
Option Buttons.
Using the AVERAGE, MAX, and MIN Functions.
To Determine the Average of a Range of Numbers Using the Keyboard and Mouse.
To Determine the Highest Number in a Range of Numbers Using the Insert Function Box.
To Determine the Lowest Number in a Range of Numbers Using the Sum Menu.
To Copy a Range of Cells Across Columns to an Adjacent Range Using the Fill Handle.
Verifying Formulas Using Range Finder.
To Verify a Formula Using Range Finder.
Formatting the Worksheet.
To Change the Workbook Theme.
To Change the Background Color and Apply a Box Border to the Worksheet Title and Subtitle.
To Format Dates and Center Data in Cells.
Formatting Numbers Using the Ribbon.
To Apply an Accounting Number Format and Comma Style Format Using the Ribbon.
To Apply a Currency Style Format with a Floating Dollar Sign Using the Format Cells Dialog Box.
To Apply a Percent Style Format and Use the Increase Decimal Button.
Conditional Formatting.
To Apply Conditional Formatting.
Conditional Formatting Operators.
Changing the Widths of Columns and Heights of Rows.
To Change the Widths of Columns.
To Change the Heights of Rows.
Checking Spelling.
To Check Spelling on the Worksheet.
Additional Spell Checker Considerations.
Preparing to Print the Worksheet.
To Change the Worksheet's Margins, Header, and Orientation in Page Layout View.
Printing the Worksheet.
To Print a Section of the Worksheet.
Displaying and Printing the Formulas Version of the Worksheet.
To Display the Formulas in the Worksheet and Fit the
Printout on One Page.
Chapter Summary.
Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.
What-If Analysis, Charting, and Working with Large Worksheets.
Objectives.
Project – Financial Projection Worksheet with What-If Analysis and Chart.
Overview.
Rotating Text and Using the Fill Handle to Create a Series.
To Rotate Text and Use the Fill Handle to Create a Series of Month Names.
Using the Auto Fill Options Menu.
To Increase Column Widths.
To Enter Row Titles.
Destination Area.
To Copy a Range of Cells to a Nonadjacent Destination Area.
Using the Paste Options Menu.
Using Drag and Drop to Move or Copy Cells.
Using Cut and Paste to Move Cells.
Inserting and Deleting Cells in a Worksheet.
To Insert a Row.
Inserting Columns.
Inserting Single Cells or a Range of Cells.
Deleting Columns and Rows.
To Enter Numbers with Format Symbols.
To Freeze Column and Row Titles.
To Enter and Format the System Date.
Absolute versus Relative Addressing.
To Enter a Formula Containing Absolute Cell References.
Making Decisions – The IF Function.
To Enter an IF Function.
To Copy Formulas with Absolute Cell References Using the Fill Handle.
Nested Forms of the IF Function.
Adding and Formatting Sparkline Charts.
To Add a Sparkline Chart to the Worksheet.
To Format and Copy the Sparkline Chart.
Formatting the Worksheet.
To Assign Formats to Nonadjacent Ranges.
To Format the Worksheet Titles.
To Copy a Cell's Format Using the Format Painter Button.
Adding a 3-D Pie Chart to the Workbook.
To Draw a 3-D Pie Chart on a Separate Chart Sheet.
To Insert a Chart Title and Data Labels.
To Rotate the 3-D Pie Chart.
To Apply a 3-D Format to the Pie Chart.
To Explode the 3-D Pie Chart and Change the Color of a Slice.
Renaming and Reordering the Sheets and Coloring their Tabs.
To Reorder the Sheet Tabs.
Changing the View of the Worksheet.
To Shrink and Magnify the View of a Worksheet or Chart.
To Split a Window into Panes.
What-If Analysis.
To Analyze Data in a Worksheet by Changing Values.
To Goal Seek.
Goal Seeking.
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.
Querying a Database.
Objectives.
Project – Querying a Database.
Overview.
Creating Queries.
To Create a Query in Design View.
To Add Fields to the Design Grid.
Determining Criteria.
To Use Text Data in a Criterion.
Using Saved Queries.
To Use a Wildcard.
To Use Criteria for a Field Not Included in the Results.
Creating a Parameter Query.
To Create and View a Parameter Query.
To Use a Parameter Query.
To Use a Number in a Criterion.
To Use a Comparison Operator in a Criterion.
Using Compound Criteria.
To Use a Compound Criterion Involving AND.
To Use a Compound Criterion Involving OR.
Special Criteria.
Sorting.
To Clear the Design Grid.
To Sort Data in a Query.
To Omit Duplicates.
To Sort on Multiple Keys.
To Create a Top-Values Query.
Joining Tables.
To Join Tables.
To Change Join Properties.
To Create a Report Involving a Join.
Creating a Form for a Query.
To Create a Form for a Query.
Using a Form.
Exporting Data from Access to Other Applications.
To Export Data to Excel.
Text Files.
Adding Criteria to a Join Query.
To Restrict the Records in a Join.
Calculations.
To Use a Calculated Field in a Query.
To Change a Caption.
To Calculate Statistics.
To Use Criteria in Calculating Statistics.
To Use Grouping.
Crosstab Queries.
To Create a Crosstab Query.
To Customize the Navigation Pane.
Referential Integrity.
To Specify Referential Integrity.
Effect of Referential Integrity.
To Use a Subdatasheet.
Handling Data Inconsistency.
Ordering Records.
To Use the Ascending Button to Order Records.
Chapter Summary.
Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.
Microsoft Outlook 2010.
Managing E-Mail Messages with Outlook.
Objectives.
Project – Composing and Sending E-Mail Messages.
Overview.
Outlook Account Settings.
To Open an Outlook Data File.
Composing and Sending E-Mail Messages.
To Compose and Send an E-Mail Message.
To Send an E-Mail Message.
How E-Mail Messages Travel from Sender to Receiver.
Working with Incoming Messages.
To Read an E-Mail Message in the Reading Pane.
To Open an E-Mail Message in a Window.
To Close an E-Mail Message.
To Print an E-Mail Message.
Responding to E-Mail Messages.
To Reply to an E-Mail Message.
To Forward an E-Mail Message.
Message Formats.
To Change the Message Format and Send the Message.
To Delete an E-Mail Message.
Spelling and Grammar Check.
To Check the Spelling of a Correctly Typed Word.
To Check the Spelling of Misspelled Text.
Saving and Closing an E-Mail Message.
To Save and Close an E-Mail Message without Sending It.
Opening and Modifying a Saved E-Mail Message.
To Open a Saved E-Mail Message.
To Include a Courtesy Copy Recipient in an E-Mail Message.
To Attach a File to an E-Mail Message.
To Set Message Importance for a Single E-Mail Message and Send the Message.
File Attachments.
To Preview and Save an Attachment.
Using Outlook Folders to Organize the Inbox.
To Create a New Folder in the Inbox Folder.
To Move an E-Mail Message to a Folder.
Chapter Summary.
Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.
Managing Calendars.
Objectives.
Project – Appointments, Events, and Meetings in Calendar.
Overview.
Calendar Window.
Calendar Items.
To Create a Personal Folder.
To Display a Personal Calendar.
To Remove the Default Calendar from the Appointment Area.
Viewing the Calendar.
To Go to a Specific Date.
To Display the Calendar in Work Week View.
To Display the Calendar in Week View.
To Display the Calendar in Month View.
To Display the Calendar in Schedule View.
Creating and Editing Appointments.
Creating Appointments in the Appointment Area.
To Display One Calendar in Day View.
To Create a One-Time Appointment Using the Appointment Area.
Creating Appointments Using the Appointment Window.
To Create a One-Time Appointment Using the Appointment Window.
Setting Appointment Options.
To Change the Status of an Appointment.
To Set a Reminder for the Appointment.
To Save the Appointment.
Creating Recurring Appointments.
To Set Recurrence Options for an Appointment.
Using Natural Language Phrasing.
To Enter an Appointment Date and Time Using Natural Language Phrases.
Editing Appointments.
To Move an Appointment to a Different Time on the Same Day.
To Move an Appointment to a Different Date.
To Move an Appointment to a Different Month.
To Delete a Single Occurrence of a Recurring Appointment.
Creating and Editing Events.
To Create a One-Time Event in the Appointment Window.
To Move a One-Time Event to a New Date and Change the Event Status.
To Delete a One-Time Event.
To Create a Recurring Event Using the Appointment Window.
To Move a Recurring Event to a Different Day.
Creating and Editing Meetings.
To View School Calendar in Overlay Mode.
To Create and Send a Meeting Request.
To Change the Time of a Meeting and Send an Update.
To Reply to a Meeting Request.
To Cancel a Meeting.
Printing Calendars in Different Views.
To Print the Calendar in Weekly Calendar Style.
To Change the Current View to List View.
Exporting and Importing Folders.
To Export a Subfolder to a USB Flash Drive.
To Delete a Personal Subfolder.
Chapter Summary.
Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.
Appendices:
A 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.
Capstone Project: Wee Ones Day Care
Word Capstone Project.
PowerPoint Capstone Project.
Excel Capstone Project.
Access Capstone Project.
Quick Reference Summary.
  • Чтобы скачать этот файл зарегистрируйтесь и/или войдите на сайт используя форму сверху.
  • Регистрация