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

Course Technology – 2011, 1216 p. in color
ISBN: 1439078548, 9781439078549Introduce 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: ADVANCED 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.
First came across Shelly Cashman Series in 1998. I used their MS-Access book for my University Class and instantly became a fan. Key feature of this series is a Project based learning. All their titles that i studied had real life Projects and screen by screen instructions on how to complete Projects and acquire necessary skills.
Microsoft Office 2010. I am currently studying for Microsoft Office Certification; i do have Microsoft Office 2010 for Dummies, Teach Yourself Visually Office 2010 by Kate Shoup and Microsoft Office Word 2010/ Microsoft Office Excel 2010 (QuickSteps Series) by John Cronan. Compared to all these titles this one is way better in all categories.
No other book give you sample data to practice with, but with this one you can download sample data files for practice.
There are three books in this series:
Microsoft Office 2010 Introductory
Microsoft Office 2010 Advanced
Microsoft Office 2010 Post AdvancedMicrosoft Word 2010.
Creating a Document with a Title Page, Lists, Tables, and a Watermark.
Objectives.Project – Sales Proposal.Overview.Creating a Title Page.
To Border a Paragraph.
To Change Left and Right Paragraph Indent.
SmartArt Graphics.
To Insert a SmartArt Graphic.
To Delete Shapes and Add Text to Shapes in a SmartArt Graphic.
To Change Colors of a SmartArt Graphic.
To Apply a SmartArt Style.
To Format Characters and Modify Character Spacing Using the Font Dialog Box.
Inserting an Existing Document in an Open Document.
Sections.
To Insert a Next Page Section Break.
To Insert a Word Document in an Open Document.
To Print Specific Pages in a Document.
To Delete a Page Break.
To Change Theme Fonts.
Creating Headers and Footers.
To Insert a Formatted Header Different from the Previous Header.
To Format Page Numbers to Start at a Different Number.
Editing and Formatting Lists.
To Sort Paragraphs.
To Use the Format Painter Button.
To Customize Bullets in a List.
To Create a Multilevel Numbered List.
Editing and Formatting Tables.
To Show Gridlines.
To Change Column Width.
To Hide White Space.
To Change Row Height.
To Shade a Table Cell.
To Select Nonadjacent Items.
To Change Cell Spacing.
To Delete a Column.
To Sort a Table.
To Split Cells.
To Move a Cell Boundary.
To Distribute Columns.
To Display Text in a Cell Vertically.
To Border a Table.
To Sum Columns in a Table.
Creating a Watermark.
To Create a Watermark.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Using a Template to Create a Resume and Sharing a Finished Document.
Objectives.Project – Resume.Overview.Using a Template to Create a Resume.
To Create a New Document from a Sample Template.
To Change the Document Theme.
Resume Template.
To Modify Text in a Content Control.
To Format a Content Control.
To Replace Placeholder Text.
To Delete a Content Control.
To Move Table Rows.
To Use AutoComplete.
To Enter a Line Break.
To Indent a Paragraph.
To Insert a Building Block Using the Quick Parts Gallery.
To Copy and Paste a Table Item.
To Customize Theme Fonts.
To Create a Quick Style.
To Reveal Formatting.
To Modify a Style Using the Styles Dialog Box.
Online Templates.
Sharing a Document with Others.
PDF.
To Save a Word Document as a PDF Document and View the PDF Document in Adobe Reader.
XPS.
To Save a Word Document as a XPS Document and View the XPS Document in the XPS Viewer.
To Run the Compatibility Checker.
To Save a Word 2010 Document in an Earlier Word Format.
File Types.
To Send a Document Using E-Mail.
Creating a Web Page from a Word Document.
To Save a Word Document as a Web Page.
Saving to the Web.
Formatting and Testing a Web Page.
To Format Text as a Hyperlink.
To Add a Background Color.
To Add a Pattern Fill Effect to a Background.
To Test a Web Page in a Web Browser.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Generating Form Letters, Mailing Labels, and a Directory.
Objectives.Project – Form Letters, Mailing Labels, and a Directory.Overview.Identifying the Main Document for Form Letters.
To Identify the Main Document for the Form
Letter Using the Mail Merge Task Pane.
To Create a Folder while Saving.
Creating a Data Source.
To Create a New Data Source.
To Save a Data Source when Prompted by Word.
Editing Records in the Data Source.
Composing the Main Document for the Form Letters.
To Enter the Date.
Merge Fields.
To View Merged Data in the Main Document.
To Edit the AddressBlock Merge Field.
To Edit the GreetingLine Merge Field.
To Insert a Merge Field in the Main Document.
IF Fields.
To Insert an IF Field in the Main Document.
To Display a Field Code.
Opening a Main Document.
Merging the Data Source with the Main Document
to Generate Form Letters.
To Preview the Merged Letters.
To Merge the Form Letters to a New Document.
Correcting Errors in Merged Documents.
To Merge the Form Letters to the Printer.
To Select Records to Merge.
To Remove a Merge Condition.
To Sort the Data Records in a Data Source.
To Find and Display Data.
Displaying Data Source Records in the Main Document.
Addressing and Printing Mailing Labels and Envelopes.
To Address and Print Mailing Labels Using an Existing Data Source.
Merging All Data Records to a Directory.
To Change Page Orientation.
To Merge to a Directory.
To Convert Text to a Table.
To Sort a Table by Multiple Columns.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Creating a Newsletter with a Pull-Quote and Graphics.
Objectives.Project – Newsletter.Overview.Desktop Publishing Terminology.
To Set Custom Margins.
Creating the Nameplate.
To Insert WordArt.
To Change the WordArt Fill Color.
To Change the WordArt Shape.
To Set Custom Tab Stops Using the Tabs Dialog Box.
To Border One Edge of a Paragraph.
To Crop a Graphic.
To Use the Selection Pane.
To Rotate a Graphic.
Formatting the First Page of the Body of the Newsletter.
Columns.
To Insert a Continuous Section Break.
To Change the Number of Columns.
To Justify a Paragraph.
To Insert a File in a Column of the Newsletter.
To Increase Column Width and Place a Vertical Rule between Columns.
To Hyphenate a Document.
To Format a Character as a Drop Cap.
To Insert a Next Page Section Break.
To Insert a Column Break.
Creating a Pull-Quote.
To Insert a Text Box.
To Split the Window.
To Copy and Paste Using Split Windows.
To Position a Text Box.
Formatting the Second Page of the Newsletter.
To Change Column Formatting.
To Balance Columns.
Modifying and Formatting a SmartArt Graphic.
To Change the Layout of a SmartArt Graphic.
To Add Text to a SmartArt Graphic through the Text Pane.
To Adjust a Shape's Size.
Copying and Pasting.
To Copy a SmartArt Graphic Using the Office Clipboard.
To Switch from One Open Document to Another.
To Paste from the Office Clipboard.
To Layer the SmartArt Graphic in Front of Text.
Finishing the Newsletter.
To Add an Art Page Border.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Microsoft PowerPoint 2010.
Working with Information Graphics.
Objectives.Project – Presentation with SmartArt, a Chart, and a Table.Overview.Creating and Formatting a SmartArt Graphic.
To Insert a SmartArt Graphic.
Text Pane.
To Enter Text in a SmartArt Graphic.
To Format Text Pane Characters.
To Insert a Picture from a File into a SmartArt Graphic.
To Apply a SmartArt Style.
To Change SmartArt Color.
To Resize a SmartArt Graphic.
To Convert Text to a SmartArt Graphic.
To Bold SmartArt Graphic Text.
Adding a Chart to a Slide and Formatting.
Microsoft Excel and Microsoft Graph.
To Insert a Chart.
To Replace Sample Data.
To Apply a Chart Style.
To Change the Shape Outline Weight.
To Change the Shape Outline Color.
To Change a Chart Layout.
To Resize a Chart.
To Change the Title and Legend Font Size.
To Separate a Pie Slice.
To Rotate a Chart.
Adding a Table to a Slide and Formatting.
Tables.
To Insert an Empty Table.
To Enter Data in a Table.
To Insert a Symbol.
To Apply a Table Style.
To Add Borders to a Table.
To Add an Effect to a Table.
To Resize a Table.
To Add an Image to a Table.
To Merge Cells.
To Display Text in a Cell Vertically.
To Align Text in Cells.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Collaborating on and Delivering a Presentation
Objectives.Project – Presentation with Comments, Inserted Slides, and Protection.Overview.Collaborating on a Presentation.
To Merge a Presentation.
To Print Comments.
To Preview Presentation Changes.
To Review and Delete Comments.
To Review, Accept, and Reject Presentation Changes.
To Review, Accept, and Reject Slide Changes.
To Reject a Slide Revision.
To Insert a Comment.
To Edit a Comment.
To End the Review.
Reusing Slides from an Existing Presentation.
To Reuse Slides from an Existing Presentation.
To Capture Part of a Screen Using Screen Clipping.
To Add a Footer with Fixed Information.
To Clear Formatting and Apply an Artistic Effect.
Setting Slide Size and Slide Show Resolution.
To Set Slide Size.
To Select Slide Show Resolution.
Saving and Packaging a Presentation.
To Save a File as a PowerPoint Show.
To Save a Slide as an Image.
To Package a Presentation for Storage on a CD or DVD.
To Save a File in a Previous PowerPoint Format.
Protecting and Securing a Presentation.
To Identify Presentation Features Not Supported by Previous Versions.
To Remove Inappropriate Information.
To Set a Password.
To Mark a Presentation as Final.
To Create a Digital Signature and Add It to a Document.
Using Presentation Tools to Navigate.
Delivering and Navigating a Presentation
Using the Slide Show Toolbar.
To Highlight Items on a Slide.
To Change Ink Color.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Navigating Presentations Using Hyperlinks and Action Buttons.
Objectives.Project – Presentation with Action Buttons, Hyperlinks, and Formatted Bullet Characters.Overview.Creating a Presentation from a Microsoft Word 2010 Outline.
Converting Documents for Use in PowerPoint.
To Open a Microsoft Word Outline as a Presentation.
Adding Hyperlinks and Action Buttons.
To Add a Hyperlink to a Picture.
To Add a Hyperlink to a Paragraph.
Action Buttons.
To Insert an Action Button.
To Change an Action Button Fill Color.
To Copy an Action Button.
To Edit an Action Button Action Setting.
To Hyperlink to Another PowerPoint File.
To Hyperlink to a Microsoft Word File.
Positioning Slide Elements.
Aligning and Distributing Objects.
To Display the Drawing Guides.
To Position a Picture Using Guides.
To Display the Rulers.
To Align Pictures.
To Distribute Pictures.
Hiding a Slide.
To Hide a Slide.
Modifying Placeholder Text Settings.
To Center Placeholder Text.
To Align Placeholder Text.
To Change Paragraph Line Spacing.
To Create Columns in a Placeholder.
To Adjust Column Spacing.
To Enter a Line Break.
Modifying Bullets.
To Change a Bullet Character to a Picture.
To Change a Bullet Character to a Symbol.
To Format a Bullet Size.
To Format a Bullet Color.
To Change a Bullet Character to a Number.
To Format a Numbered List.
To Remove Bullet Characters.
Running a Slide Show with Hyperlinks and Action Buttons.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Creating a Self-Running Presentation Containing Animation.
Objectives.Project – Presentation with Adjusted Pictures, Animated Content, and Slide Timings.Overview.Adjusting and Cropping a Picture.
To Remove a Background.
To Refine Background Removal.
To Crop a Picture.
To Compress a Picture.
Animating Slide Content.
Custom Animations.
To Animate a Picture Using an Entrance Effect.
To Change Animation Direction.
To Animate a Picture Using an Emphasis Effect.
To Animate a Picture Using an Exit Effect.
To Preview an Animation Sequence.
To Modify Entrance Animation Timing.
To Animate Title Text Placeholder Paragraphs.
To Change Animation Order.
To Rename Slide Objects.
To Insert a Text Box and Format Text.
To Animate a Text Box Using an Entrance Effect.
To Animate a Text Box by Applying a Motion Path.
To Adjust a Motion Path.
To Associate a Sound with an Animation.
To Draw a Custom Motion Path.
To Use the Animation Painter to Animate a Clip.
To Animate a SmartArt Graphic.
To Change a SmartArt Graphic Animation Sequence.
To Animate a Chart.
To Animate a List.
To Dim Text after Animation.
To Create Credits.
Preparing for a Self-Running Presentation.
To Rehearse Timings.
To Adjust Timings Manually.
To Modify a Transition Effect.
To Create a Self-Running Presentation.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.
Microsoft ExcelMicrosoft Excel 2010.
Financial Functions, Data Tables, and Amortization Schedules.
Objectives.Project – Loan Payment Calculator with Data Table and Amortization Schedule.Overview.Adding Custom Borders to a Range and Creating Cell Names.
To Add Custom Borders to a Range.
To Create Names Based on Row Titles.
More about Cell Names.
To Enter the Loan Amount Formula Using Names.
To Enter the PMT Function.
Other Financial Functions.
Using a Data Table to Analyze Worksheet Data.
To Create a Percent Series Using the Fill Handle.
To Define a Range as a Data Table.
More about Data Tables.
Adding a Pointer to the Data Table Using Conditional Formatting.
To Add a Pointer to the Data Table.
Creating an Amortization Schedule.
To Copy the Formulas to Fill the Amortization Schedule.
Printing Sections of the Worksheet.
To Set Up a Worksheet to Print.
More about Print Options.
To Set the Print Area.
To Name and Print Sections of a Worksheet.
Protecting and Hiding Worksheets and Workbooks.
To Protect a Worksheet.
More about Worksheet Protection.
To Hide and Unhide a Sheet.
To Hide and Unhide a Workbook.
Formula Checking.
More about Background Formula Checking.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Creating, Sorting, and Querying a Table.
Objectives.Project – Kenson College Scholarship Fundraiser Table.Overview.To Format a Range as a Table.
To Modify a Table Quick Style.
To Enter Records into a Table.
Adding Computational Fields to the Table.
To Add New Fields to a Table.
Adding a Lookup Table.
To Use the VLOOKUP Function to Determine Letter Grades.
Conditional Formatting.
To Add a Conditional Formatting Rule with an Icon Set.
Working with Tables in Excel.
To Use the Total Row Check Box.
To Print the Table.
Sorting a Table.
To Sort a Table in Ascending Sequence by Name Using the Sort & Filter Button.
To Sort a Table Using the Sort Command on an AutoFilter Menu.
To Sort a Table on Multiple Fields Using the Custom Sort Command.
Querying a Table Using AutoFilter.
To Query a Table Using AutoFilter.
More about AutoFilter.
To Show All Records in a Table.
To Enter Custom Criteria Using AutoFilter.
Using a Criteria Range on the Worksheet.
To Create a Criteria Range on the Worksheet.
To Query a Table Using the Advanced Filter Dialog Box.
Extracting Records.
To Create an Extract Range and Extract Records.
More about the Criteria Range.
A Blank Row in the Criteria Range.
Using Multiple Comparison Criteria with the Same Field.
Comparison Criteria in Different Rows and Below Different Fields.
Using Database Functions.
More about Using Database Functions.
Other Database Functions.
Using the SUMIF, COUNTIF, MATCH, and INDEX Functions.
Displaying Automatic Subtotals in a Table.
To Display Automatic Subtotals in a Table.
To Zoom Out on a Subtotaled Table and Use the Outline Feature.
To Remove Automatic Subtotals from a Table.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Working with Multiple Worksheets and Workbooks.
Objectives.Project – Consolidated Expenditures Worksheet.Overview.Creating the Consolidated Worksheet.
To Enter Sample Data in the Consolidated
Worksheet Using the Fill Handle.
The ROUND Function and Entering Formulas in the Template.
To Enter Formulas and Determine Totals in the Consolidated Worksheet.
Formatting the Consolidated Worksheet.
To Assign a Currency Style Using the Format Cells Dialog Box.
Format Codes.
To Create and Assign a Custom Format Code and a Comma Style Format.
Cell Styles.
To Create a New Style.
To Apply a New Style.
More About Using Styles.
Working with Multiple Worksheets.
To Add a Worksheet to a Workbook.
To Copy the Contents of a Worksheet to Other Worksheets in a Workbook.
To Drill an Entry through Worksheets.
Referencing Cells in Other Sheets in a Workbook.
To Enter and Copy 3-D References Using the Paste Gallery.
More About Pasting.
Adding a Header and Footer, Changing the Margins, and Printing the Workbook.
To Change Margins and Center the Printout Horizontally.
To Add a Header and Footer.
Selecting and Deselecting Sheets.
To Insert and Remove a Page Break.
To Hide Page Breaks.
Consolidating Data by Linking Workbooks.
To Search for and Open Workbooks.
To Create a Workspace File.
To Consolidate Data by Linking Workbooks.
Updating Links.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Creating Templates, Importing Data, and Working with SmartArt, Images, and Screen Shots.
Objectives.Project – YouBuild Computers Sales Analysis.Overview.Creating Templates.
To Save the Template.
Using Templates.
To Open a Template and Save It as a Workbook.
Importing Data.
Importing Text Files.
To Import Data from a Text File into a Worksheet.
Importing Data from a Database.
To Import Data from an Access Table into a Worksheet.
Importing Web Page Data.
To Import Data from a Web Page into a
Worksheet.
Importing Word Data.
To Copy and Transpose Data from a Word Document to a Worksheet.
To Convert Text to Columns.
Replicating Formulas after Importing.
To Replicate Formulas.
Using the Find and Replace Commands.
To Find a String.
Working with the Find and Replace Dialog Box.
To Replace a String with Another String.
Inserting a Clustered Cone Chart.
To Insert the Clustered Cone Chart.
To Add a Chart Title Using the WordArt Tool.
Working with SmartArt Graphics.
To Insert a Picture Strips SmartArt Graphic.
To Add Shapes in the Picture Strips SmartArt Graphic.
To Add Text to Shapes in the Picture Strips SmartArt Graphic.
To Add Pictures to Shapes in the Picture Strips SmartArt Graphic.
To Add an Effect to the Picture Strips SmartArt Graphic.
Using Images on a Worksheet.
To Insert and Modify an Image in the Worksheet.
Using Screen Shots on a Worksheet.
To Insert a Screen Shot on a Worksheet.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.
Microsoft AccessMicrosoft Access 2010.
Creating Reports and Forms.
Objectives.Project – Reports and Forms.Overview.Report Creation.
Using Layout View in a Report.
Understanding Report Sections.
To Group and Sort in a Report.
Grouping and Sorting Options.
Understanding Report Controls.
To Add Totals and Subtotals.
To Remove the Group, Sort, and Total Pane.
To Conditionally Format Controls.
To Filter Records in a Report.
To Clear a Report Filter.
The Arrange and Page Setup Tabs.
Multitable Reports.
To Create a Report that Involves Multiple Tables.
Creating a Report in Layout View.
Using Themes.
Live Preview for Themes.
To Create a Summary Report.
Form Creation.
To Use the Form Wizard to Create a Form.
Understanding Form Sections.
Understanding Form Controls.
Using Layout View in a Form.
To Place Controls in a Control Layout.
To Add a Date.
To Change the Format of a Control.
To Move a Control.
To Move Controls in a Control Layout.
To Add a Field.
To Filter and Sort Using a Form.
The Arrange Tab.
Mailing Labels.
To Create Labels.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Multitable Forms.
Objectives.Project – Multitable Forms.Overview.Adding Special Fields.
To Add Fields with New Data Types to a Table.
To Use the Input Mask Wizard.
Adding Fields in Datasheet View.
Updating the New Fields.
To Enter Data Using an Input Mask.
To Enter Data in Yes/No Fields.
To Enter Data in Date/Time Fields.
To Enter Data in Memo Fields.
To Change the Row and Column Size.
Undoing Changes to Row Height and Column Width.
To Enter Data in OLE Object Fields.
Bitmap Image.
To Enter Data in Attachment Fields.
Viewing Pictures and Attachments in Datasheet View.
Multitable Form Techniques.
To Create a Form in Design View.
To Add a Control for a Field to the Form Design.
To Add Controls for Additional Fields.
To Align Controls on the Left.
To Align Controls on the Top and Adjust Vertical Spacing.
To Move the Field List.
To Add Controls for the Remaining Fields.
To Use a Shortcut Menu to Change the Fill/Back Color.
To Add a Title.
To Place a Subform.
To View the Form.
To Modify a Subform.
To Change a Label.
Size Mode for Pictures.
To Change Special Effects and Colors.
To Modify the Appearance of a Form Title.
To Change a Tab Stop.
Changing the Tab Order.
To Use the Form.
Navigation in the Form.
Object Dependencies.
To View Object Dependencies.
Date/Time, Memo, and Yes/No Fields in Queries.
To Use Date/Time, Memo, and Yes/No Fields in a Query.
Datasheets in Forms.
Creating a Simple Form with a Datasheet.
Creating a Form with a Datasheet in Layout View.
Creating a Multitable Form Based on the Many Table.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Advanced Report Techniques.
Objectives.Project – Advanced Report Techniques.Overview.Additional Tables.
To Create the New Tables.
Linking versus Importing.
The Linked Table Manager.
To Relate Several Tables.
Creating Reports in Design View.
To Create an Additional Query for the Report.
To Create an Initial Report in Design View.
To Add Fields to the Report in Design View.
To Change Labels.
Using Other Tools in the Controls Group.
To Add Text Boxes.
To View the Report in Print Preview.
To Format a Control.
To Group Controls.
To Modify Grouped Controls.
To Modify Multiple Controls That Are Not Grouped.
Undoing and Saving.
To Add a Subreport.
To Open the Subreport in Design View.
Print Layout Issues.
To Modify the Controls in the Subreport.
To Change the Can Grow Property.
To Change the Appearance of the Controls in the Subreport.
To Resize the Subreport and the Report in Design View.
To Modify Section Properties.
To Add a Title, Page Number, and Date.
To Remove the Alternate Color.
To Add and Move Fields in a Report.
To Add the Remaining Fields.
To Resize the Detail Section.
Totals and Subtotals.
To Add Totals and Subtotals.
Grouping and Sorting Options.
To Remove the Color from the Report Header.
To Assign a Conditional Value.
Obtaining Help on Functions.
Page Setup Tab.
Fine-Tuning a Report.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Using SQL.
Objectives.Project – Using SQL.Overview.SQL Background.
To Change the Font Size.
SQL Queries.
To Create a New SQL Query.
SQL Commands.
To Include Only Certain Fields.
To Prepare to Enter a New SQL Query.
To Include All Fields.
To Use a Criterion Involving a Numeric Field.
Simple Criteria.
To Use a Comparison Operator.
To Use a Criterion Involving a Text Field.
To Use a Wildcard.
Compound Criteria.
To Use a Compound Criterion Involving AND.
To Use a Compound Criterion Involving OR.
To Use NOT in a Criterion.
To Use a Computed Field.
Sorting.
To Sort the Results on a Single Field.
To Sort the Results on Multiple Fields.
To Sort the Results in Descending Order.
To Omit Duplicates When Sorting.
To Use a Built-In Function.
To Assign a Name to the Results of a Function.
To Use Multiple Functions in the Same Command.
Grouping.
To Use Grouping.
Grouping Requirements.
To Restrict the Groups that Appear.
Joining Tables.
Qualifying Fields.
To Join Tables.
To Restrict the Records in a Join.
Aliases.
To Join a Table to Itself.
Subqueries.
To Use a Subquery.
Using an IN Clause.
Comparison with Access-Generated SQL.
Updating Data through SQL.
To Use an INSERT Command.
To Use an UPDATE Command.
To Use a DELETE Command.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.Microsoft Outlook 2010.
Managing Contacts and Personal Contact Information with Outlook.
Objectives.Project – Contact List with Groups.Overview.Contacts Window.
Creating a Contact List.
To Create a New Contact.
To Create a Contact from an E-Mail Message.
To Create a Contact from an Existing Contact.
To Edit a Contact.
To Add an Attachment to a Contact.
To Change an Attachment to a Contact.
To Remove an Attachment to a Contact.
Viewing and Sorting Your Contact List.
To Change the Current View.
To Sort Contacts.
Using Search to Find a Contact.
To Find a Contact by Searching for an E-Mail Address.
To Refine a Search.
To Find a Contact from any Outlook Folder.
Create and Edit a Contact Group.
To Create a Contact Group from Existing Contacts.
To Create a Contact Group from an Existing E-Mail Message.
To Add a Name to a Contact Group.
To Remove a Name in a Contact Group.
Printing Your Contacts.
To Preview a Contact List.
To Print the Contact List.Learn It Online.
Apply Your Knowledge.
Extend Your Knowledge.
Make It Right.
In the Lab.
Cases and Places.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.
Word Advanced Capstone Project.
PowerPoint Advanced Capstone Project.
Excel Advanced Capstone Project.
Access Advanced Capstone Project.Quick Reference Summary.
Photo Credits.