Duration : 5h 9m Introduction1m 47s Welcome 1m 7s Using the exercise files 40s 1. Getting Started with Word 2013 - 29m 15s Launching Word and touring the interface 5m 37s Opening, closing, and reading documents 4m 32s Using the new bookmark feature 2m 19s Creating new documents with templates 6m 5s Saving documents 3m 41s 2. Editing Text-18m 22s Inserting new text 2m 19s Selecting text with the mouse or keyboard 2m 45s Rearranging text with Cut, Copy, and Paste 4m 0s Finding and replacing text 6m 13s Undoing and redoing actions 3m 5s 3. Formatting Text-19m 51s Introduction to fonts 5m 44s Choosing the right font and font style 6m 37s Changing text case 2m 27s Adding pizzazz with special text effects 5m 3s 4. Using Paragraph Formatting-21m 35s Changing paragraph alignment and justification 3m 32s Adjusting line spacing 5m 39s Keeping text together across page breaks 3m 29s Applying paragraph shading and borders 3m 11s Using tab stops and indents 5m 44s 5. Formatting Pages-24m 36s Changing page size, margins, and orientation 6m 44s Using headers, footers, and page numbers 7m 24s Organizing a document with sections 4m 54s Adding page backgrounds, borders, and watermarks 5m 34s 6. Formatting Efficiently with Styles and Themes-18m 41s Applying a theme to a document 3m 38s Applying Quick Styles to text 5m 48s 7. Creating Bulleted and Numbered Lists-15m 59s Creating a bulleted or numbered list 4m 42s Changing the format of a bulleted or numbered list 4m 51s 8. Working with Tables-32m 11s Creating new tables from scratch 4m 43s Converting existing text to a table 2m 7s Formatting table appearance 5m 17s Using Quick Tables 2m 45s Adding and removing columns and rows 3m 48s 9. Illustrating Your Documents-47m 54s Illustrating with pictures, shapes, and clip art 4m 37s Positioning and cropping graphics 6m 24s Using a table to organize text and graphics 5m 6s Applying special effects to graphics 4m 4s Adjusting photos in a document 5m 21s 10. Using Macros and Building Blocks-19m 7s Creating a macro 3m 28s Finding and running a macro 2m 56s 11. Proofing Your Documents-13m 7s Checking spelling and grammar 4m 10s Setting proofing and autocorrect options 4m 31s Using the thesaurus, research, and translation tools 4m 26s 12. Reviewing Documents with Others-15m 10s Inserting and reviewing comments 3m 23s Tracking changes and showing markup 6m 58s Comparing and combining documents 4m 49s 13. Sharing Documents with Others-17m 44s Getting documents ready for sharing 5m 43s Saving documents to SkyDrive 4m 15s Sending documents via email 2m 24s 14. Customizing Word-14m 5s Changing general settings 2m 42s Changing advanced settings 4m 24s Customizing the Ribbon 4m 17s Customizing the Quick Access Toolbar 2m 42s Microsoft Access 2013 Essential Training Duration : 5h 4m Level : Beginner Introduction 1m 47s Welcome 1m 5s Using the exercise files 42s 1. Getting Started 23m 43s Key database concepts 4m 21s Launching Access and the Backstage screen 1m 41s Creating the database file 3m 25s Understanding the Trust Center 3m 2s Digging in to Ribbon tabs 3m 39s 2. Creating Tables 23m 54s Understanding table structure and relationships 4m 18s Creating a table and setting data types 4m 15s 3. Setting Field Properties 29m 37s Establishing relationships and maintaining referential integrity 6m 28s Editing table structure in Design view 3m 58s Controlling input with masks 5m 4s Setting the default value 2m 15s 4. Organizing Records 11m 3s Formatting columns 2m 52s Sorting table data 3m 18s Filtering table data 2m 21s Searching and replacing values 2m 32s 5. Using Queries 39m 35s Understanding queries 2m 2s Creating queries with the Simple Query Wizard 4m 24s Building queries in Design view 4m 58s Establishing constraints with criteria 4m 14s Specifying criteria with wildcards 3m 50s 6. Working with Specialty Queries 19m 13s Using update queries 3m 21s Using make table queries 2m 57s Using delete queries 2m 48s 7. Creating Forms 12m 47s Understanding the role of forms 2m 52s Generating forms from tables 3m 10s Adjusting form elements in Layout view 4m 7s Using the Form Wizard 2m 38s 8. Designing Forms 44m 23s Creating forms in Design view 3m 50s Exploring the form property sheet 3m 13s 9. Creating Reports 32m 56s Introducing reports 2m 15s Using the Report Wizard 5m 9s 10. Working with Macros 25m 0s Creating macros 5m 3s Embedding macros into buttons 7m 50s Attaching data macros to tables 9m 5s Launching macros at startup 3m 2s 11. Integrating Access with the Office Suite 12m 12s Exporting tables to Excel 3m 8s Emailing with macros 4m 4s 12. Maintaining the Database 27m 24s Organizing the Navigation pane with custom groups 2m 59s Compacting and repairing the database 1m 20s Examining database object relationships 2m 58s