WOW! ACCESS EXCEL WORD POWERPOINT ONENOTE PUBLISHER Training Tutorial - 42 HRS

Mastering Microsoft Office Made EasyMastering Microsoft Made Easy DVD-ROM Self-Study Training Course Product Name: Mastering Microsoft Office Made Easy Manufacturer: TeachUcomp, Inc. Versions Covered: 2013 through 2007 Course Length: 42 Hours Video Lessons: 786 Instruction Manuals: 15 (PDF) Included Courses: Access, Excel, OneNote, Outlook, PowerPoint, Publisher, and Word Learn 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 Topics Getting Acquainted with Access 1. Creating a New Database - 2013 2. Creating a New Database - 2010:2007 3. Overview of a Database 4. The Access Interface 5. Touch Mode 6. Viewing Database Objects in the Navigation Bar 7. Opening and Closing Databases - 2013 8. Opening and Closing Databases - 2010:2007 Creating Relational Database Tables 1. The "Flat File" Method of Data Storage 2. The Relational Model of Data Storage 3. Tips for Creating a Relational Database 4. Creating Relational Database Tables 5. Assigning a Primary Key to a Table Using Tables 1. Using Datasheet View 2. Navigating in Datasheet View 3. Adding Records in Database View 4. Editing and Deleting Records in Datasheet View 5. Inserting New Fields 6. Renaming Fields 7. Deleting Fields Field Properties 1. Setting Field Properties 2. The 'Field Size' Property 3. The 'Format' Property for Date/Time Fields 4. The 'Format' Property for Logical Fields 5. Setting Default Values for Fields 6. Setting Input Masks 7. Setting Up Validation Rules and Responses 8. Requiring Field Input 9. Allowing Zero Length Entries Joining Tables in a Database 1. The Relationships Window 2. Enforcing Referential Integrity 3. Creating Lookup Fields Indexing Tables 1. Indexes 2. Creating Indexes 3. Deleting Indexes Queries 1. Using the Simple Query Wizard 2. Designing Queries 3. Joining Tables in a Query 4. Adding Criteria to the QBE Grid 5. Running A Query 6. How is Using the QBE Grid Writing SQL Code? 7. Sorting Query Results 8. Hiding Fields in a Query 9. Using Comparison Operators 10. Using 'AND' and 'OR' Conditions Advanced Queries 1. Using the 'BETWEEN...AND' Condition 2. Using Wildcard Characters in Criteria 3. Creating a Calculated Field 4. Creating 'Top Value' Queries 5. Function Queries 6. Parameter Queries Advanced Query Types 1. Make-Table Queries 2. Update Queries 3. Append Queries 4. Delete Queries 5. Crosstab Queries 6. The 'Find Duplicates' Query 7. The 'Find Unmatched' Query Creating Forms 1. Forms Overview 2. The Form Wizard 3. Creating AutoForms 4. Using Forms 5. Form and Report Layout View 6. Form and Report Design View 7. Viewing the Ruler and Gridlines 8. The 'Snap to Grid' Feature 9. Creating a Form in Design View Form & Report Controls 1. Selecting Controls 2. Deleting Controls 3. Moving and Resizing Controls 4. Sizing Controls 'To Fit' 5. 'Nudging' Controls 6. Aligning, Spacing and Sizing Controls 7. Formatting Controls 8. Viewing Control Properties Using Controls 1. The Controls Group 2. Adding Label Controls 3. Adding Logos and Image Controls 4. Adding Line and Rectangle Controls 5. Adding Combo Box Controls 6. Adding List Box Controls 7. Setting Tab Order Subforms 1. Creating Subforms 2. Using the Subform/Subreport Control Reports 1. Using the Report Wizard 2. Using Basic Reports 3. Creating a Report in Design View 4. Sorting and Grouping Data in Reports 5. Creating Calculated Fields Subreports 1. Creating Subreports Charting Data 1. Using Charts Macros in Access 2007 1. Creating and Using Macros 2. Macro Actions 3. Assigning Macros to a Command Button 4. Conditional Macros and Option Groups 5. Using Group Names in Macros 6. Creating Autoexec Macros Macros in Access 2013:2010 1. Creating a Standalone Macro 2. Assigning Macros to a Command Button 3. Using Program Flow with Macros 4. Creating Autoexec Macros 5. Creating Data Macros Switchboard and Navigation Forms 1. Creating a Switchboard Form 2. Creating a Navigation Form - 2013:2010 3. Controlling Startup Behavior - 2007 4. Controlling Startup Behavior - 2013:2010 Advanced Features 1. Getting External Data 2. Exporting Data 3. Setting a Database Password - 2007 4. Setting a Database Password - 2013:2010 5. Using Help Microsoft Excel Topics Getting Acquainted with Excel 1. About Excel 2. The Excel Environment- 2013 3. The Excel Environment- 2010 4. The Excel Environment- 2007 5. The Title Bar 6. The Ribbon 7. The "File" Tab and Backstage View 8. The Microsoft Office Button- 2007 Only 9. Scroll Bars 10. The Quick Access Toolbar 11. Touch Mode 12. The Formula Bar 13. The Workbook Window 14. The Status Bar 15. The Workbook View Buttons 16. The Zoom Slider 17. The Mini Toolbar 18. Keyboard Shortcuts File Management 1. Creating New Workbooks- 2013 2. Creating New Workbooks- 2010 3. Creating New Workbooks- 2007 4. Saving Workbooks- 2013 5. Saving Workbooks- 2010 6. Saving Workbooks- 2007 7. Closing Workbooks- 2013 8. Closing Workbooks- 2010 and 2007 9. Opening Workbooks- 2013 10. Opening Workbooks- 2010 11. Opening Workbooks- 2007 12. Recovering Unsaved Workbooks 13. Using the "Window" Command Group 14. Switching to Full Screen View 15. Working With Excel File Formats Data Entry 1. Selecting Cells 2. Entering Text into Cells 3. Entering Numbers into Cells 4. AutoComplete 5. Pick from Drop-Down List 6. Flash Fill- 2013 Only 7. Selecting Ranges 8. Ranged Data Entry 9. Using AutoFill Creating Formulas 1. Ranged Formula Syntax 2. Simple Formula Syntax 3. Writing Formulas 4. Using AutoSum 5. Inserting Functions 6. Editing a Range 7. Formula AutoCorrect 8. AutoCalculate 9. Function Compatibility- 2013 Only Copying & Pasting Formulas 1. Relative References and Absolute References 2. Cutting, Copying, and Pasting Data 3. AutoFilling Cells 4. The Undo Button 5. The Redo Button Columns & Rows 1. Selecting Columns & Rows 2. Adjusting Column Width and Row Height 3. Hiding and Unhiding Columns and Rows 4. Inserting and Deleting Columns and Rows Formatting Worksheets 1. Formatting Cells 2. The Format Cells Dialog Box 3. Clearing All Formatting from Cells 4. Copying All Formatting from Cells to Another Area Worksheet Tools 1. Inserting and Deleting Worksheets 2. Selecting Multiple Worksheets 3. Navigating Worksheets- 2013 Only 4. Navigating Worksheets- 2010:2007 5. Renaming Worksheets 6. Coloring Worksheet Tabs 7. Copying or Moving Worksheets Setting Worksheet Layout 1. Using Page Break Preview 2. Using the Page Layout View 3. The Page Setup Dialog Box Printing Spreadsheets 1. Previewing and Printing Worksheets- 2013:2010 2. Using Print Preview- 2007 Only 3. Printing Worksheets- 2007 Only Helping Yourself 1. Using Excel Help Creating 3D Formulas 1. Creating 3D Formulas 2. 3D Formula Syntax 3. Creating 3D Range References Named Ranges 1. Naming Ranges 2. Creating Names from Headings 3. Moving to a Named Range 4. Using Named Ranges in Formulas 5. Naming 3D Ranges 6. Managing Named Ranges Conditional Formatting and Cell Styles 1. Conditional Formatting 2. Finding Cells with Conditional Formatting 3. Clearing Conditional Formatting 4. Using Table and Cell Styles Paste Special