Mastering Microsoft Made Easy DVD-ROM Self-Study Training CourseProduct Name: Mastering Microsoft Office Made EasyManufacturer: TeachUcomp, Inc.Versions Covered:2013 through 2007Course Length:42 HoursVideo Lessons:786Instruction Manuals: 15 (PDF)Included Courses: Access, Excel, OneNote, Outlook, PowerPoint, Publisher, and WordLearn Microsoft Office 2013 through 2007 with this comprehensive course from TeachUcomp, Inc. Mastering Microsoft Office Made Easy features 786 video lessons with over 42 hours of introductory through advanced instruction. You get our complete courses in Access, Excel, OneNote, Outlook, PowerPoint, Publisher, and Word. Watch, listen and learn as your expert instructors guide you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our fifteen printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises. This complete Microsoft Office course covers the same curriculum as our classroom trainings and was designed to provide a solid foundation in Office.Whether you are completely new to Microsoft Office or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply insert the DVD-ROM into your computer to launch the easy-to-use interface, click to launch a video lesson or open one of the manuals and you’re on your way to mastering Office.Microsoft Access TopicsGetting Acquainted with Access1. Creating a New Database - 20132. Creating a New Database - 2010:20073. Overview of a Database4. The Access Interface5. Touch Mode6. Viewing Database Objects in the Navigation Bar7. Opening and Closing Databases - 20138. Opening and Closing Databases - 2010:2007Creating Relational Database Tables1. The "Flat File" Method of Data Storage2. The Relational Model of Data Storage3. Tips for Creating a Relational Database4. Creating Relational Database Tables5. Assigning a Primary Key to a TableUsing Tables1. Using Datasheet View2. Navigating in Datasheet View3. Adding Records in Database View4. Editing and Deleting Records in Datasheet View5. Inserting New Fields6. Renaming Fields7. Deleting FieldsField Properties1. Setting Field Properties2. The 'Field Size' Property3. The 'Format' Property for Date/Time Fields4. The 'Format' Property for Logical Fields5. Setting Default Values for Fields6. Setting Input Masks7. Setting Up Validation Rules and Responses8. Requiring Field Input9. Allowing Zero Length EntriesJoining Tables in a Database1. The Relationships Window2. Enforcing Referential Integrity3. Creating Lookup FieldsIndexing Tables1. Indexes2. Creating Indexes3. Deleting IndexesQueries1. Using the Simple Query Wizard2. Designing Queries3. Joining Tables in a Query4. Adding Criteria to the QBE Grid5. Running A Query6. How is Using the QBE Grid Writing SQL Code?7. Sorting Query Results8. Hiding Fields in a Query9. Using Comparison Operators10. Using 'AND' and 'OR' ConditionsAdvanced Queries1. Using the 'BETWEEN...AND' Condition2. Using Wildcard Characters in Criteria3. Creating a Calculated Field4. Creating 'Top Value' Queries5. Function Queries6. Parameter QueriesAdvanced Query Types1. Make-Table Queries2. Update Queries3. Append Queries4. Delete Queries5. Crosstab Queries6. The 'Find Duplicates' Query7. The 'Find Unmatched' QueryCreating Forms1. Forms Overview2. The Form Wizard3. Creating AutoForms4. Using Forms5. Form and Report Layout View6. Form and Report Design View7. Viewing the Ruler and Gridlines8. The 'Snap to Grid' Feature9. Creating a Form in Design ViewForm & Report Controls1. Selecting Controls2. Deleting Controls3. Moving and Resizing Controls4. Sizing Controls 'To Fit'5. 'Nudging' Controls6. Aligning, Spacing and Sizing Controls7. Formatting Controls8. Viewing Control PropertiesUsing Controls1. The Controls Group2. Adding Label Controls3. Adding Logos and Image Controls4. Adding Line and Rectangle Controls5. Adding Combo Box Controls6. Adding List Box Controls7. Setting Tab OrderSubforms1. Creating Subforms2. Using the Subform/Subreport ControlReports1. Using the Report Wizard2. Using Basic Reports3. Creating a Report in Design View4. Sorting and Grouping Data in Reports5. Creating Calculated FieldsSubreports1. Creating SubreportsCharting Data1. Using ChartsMacros in Access 20071. Creating and Using Macros2. Macro Actions3. Assigning Macros to a Command Button4. Conditional Macros and Option Groups5. Using Group Names in Macros6. Creating Autoexec MacrosMacros in Access 2013:20101. Creating a Standalone Macro2. Assigning Macros to a Command Button3. Using Program Flow with Macros4. Creating Autoexec Macros5. Creating Data MacrosSwitchboard and Navigation Forms1. Creating a Switchboard Form2. Creating a Navigation Form - 2013:20103. Controlling Startup Behavior - 20074. Controlling Startup Behavior - 2013:2010Advanced Features1. Getting External Data2. Exporting Data3. Setting a Database Password - 20074. Setting a Database Password - 2013:20105. Using HelpMicrosoft Excel TopicsGetting Acquainted with Excel1. About Excel2. The Excel Environment- 20133. The Excel Environment- 20104. The Excel Environment- 20075. The Title Bar6. The Ribbon7. The "File" Tab and Backstage View8. The Microsoft Office Button- 2007 Only9. Scroll Bars10. The Quick Access Toolbar11. Touch Mode12. The Formula Bar13. The Workbook Window14. The Status Bar15. The Workbook View Buttons16. The Zoom Slider17. The Mini Toolbar18. Keyboard ShortcutsFile Management 1. Creating New Workbooks- 20132. Creating New Workbooks- 20103. Creating New Workbooks- 20074. Saving Workbooks- 20135. Saving Workbooks- 20106. Saving Workbooks- 20077. Closing Workbooks- 20138. Closing Workbooks- 2010 and 20079. Opening Workbooks- 201310. Opening Workbooks- 201011. Opening Workbooks- 200712. Recovering Unsaved Workbooks13. Using the "Window" Command Group14. Switching to Full Screen View15. Working With Excel File FormatsData Entry1. Selecting Cells2. Entering Text into Cells3. Entering Numbers into Cells4. AutoComplete5. Pick from Drop-Down List6. Flash Fill- 2013 Only7. Selecting Ranges8. Ranged Data Entry9. Using AutoFillCreating Formulas1. Ranged Formula Syntax2. Simple Formula Syntax3. Writing Formulas4. Using AutoSum5. Inserting Functions6. Editing a Range7. Formula AutoCorrect8. AutoCalculate9. Function Compatibility- 2013 OnlyCopying & Pasting Formulas1. Relative References and Absolute References2. Cutting, Copying, and Pasting Data3. AutoFilling Cells4. The Undo Button5. The Redo ButtonColumns & Rows1. Selecting Columns & Rows2. Adjusting Column Width and Row Height3. Hiding and Unhiding Columns and Rows4. Inserting and Deleting Columns and RowsFormatting Worksheets1. Formatting Cells2. The Format Cells Dialog Box3. Clearing All Formatting from Cells4. Copying All Formatting from Cells to Another AreaWorksheet Tools1. Inserting and Deleting Worksheets2. Selecting Multiple Worksheets3. Navigating Worksheets- 2013 Only4. Navigating Worksheets- 2010:20075. Renaming Worksheets6. Coloring Worksheet Tabs7. Copying or Moving WorksheetsSetting Worksheet Layout1. Using Page Break Preview2. Using the Page Layout View3. The Page Setup Dialog BoxPrinting Spreadsheets1. Previewing and Printing Worksheets- 2013:20102. Using Print Preview- 2007 Only3. Printing Worksheets- 2007 OnlyHelping Yourself1. Using Excel HelpCreating 3D Formulas1. Creating 3D Formulas2. 3D Formula Syntax3. Creating 3D Range ReferencesNamed Ranges1. Naming Ranges2. Creating Names from Headings3. Moving to a Named Range4. Using Named Ranges in Formulas5. Naming 3D Ranges6. Managing Named RangesConditional Formatting and Cell Styles1. Conditional Formatting2. Finding Cells with Conditional Formatting3. Clearing Conditional Formatting4. Using Table and Cell StylesPaste Special1. Using Paste Special2. Pasting Linked FormulasSharing Workbooks1. Sharing Workbooks2. Highlighting Changes3. Reviewing Changes4. Using Comments5. Compare and Merge WorkbooksAuditing Worksheets1. Auditing Worksheets2. Tracing Precedent and Dependent Cells3. Tracing Errors4. Error Checking5. Using the Watch Window6. Cell ValidationOutlining Worksheets1. Using Outlines2. Applying and Removing OutlinesConsolidating Worksheets1. Consolidating DataTables1. Creating a Table2. Adding an Editing Records3. Inserting Records and Fields4. Deleting Records and FieldsSorting Data1. Sorting Data2. Custom Sort OrdersFiltering Data1. Using AutoFilters2. Using the Top 10 AutoFilter3. Using a Custom AutoFilter4. Creating Advanced Filters5. Applying Multiple Criteria6. Using Complex Criteria7. Copying Filter Results to a New Location8. Using Database FunctionsUsing What-If Analysis1. Using Data Tables2. Using Scenario Manager3. Using Goal SeekTable-Related Functions1. The Hlookup and Vlookup Functions2. Using the IF, AND, and OR FunctionsSparklines1. Inserting and Deleting Sparklines2. Modifying SparklinesCreating Charts In Excel 20131. Creating Charts2. Selecting Charts and Chart Elements3. Adding Chart Elements4. Moving and Resizing Charts5. Changing the Chart Type6. Changing the Data Range7. Switching Column and Row Data8. Choosing a Chart Layout9. Choosing a Chart Style10. Changing Color Schemes11. Printing Charts12. Deleting ChartsData Models1. Creating a Data Model from External Relational Data2. Creating a Data Model from Excel Tables3. Relating Tables in a Data Model4. Managing a Data ModelPivotTables and PivotCharts- 20131. Creating Recommended PivotTables2. Manually Creating a PivotTable3. Creating a PivotChart4. Man
