Easy Learning MS Word 2013 & MS Access 2013 Video Training DVD(DVD)

Description

Duration : 5h 9mIntroduction1m 47sWelcome 1m 7s Using the exercise files 40s1. Getting Started with Word 2013 – 29m 15sLaunching 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 22sInserting 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 5s3. Formatting Text-19m 51sIntroduction 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 3s4. Using Paragraph Formatting-21m 35sChanging 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 44s5. Formatting Pages-24m 36sChanging 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 34s6. Formatting Efficiently with Styles and Themes-18m 41sApplying a theme to a document 3m 38s Applying Quick Styles to text 5m 48s 7. Creating Bulleted and Numbered Lists-15m 59sCreating a bulleted or numbered list 4m 42s Changing the format of a bulleted or numbered list 4m 51s 8. Working with Tables-32m 11sCreating 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 54sIllustrating 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 7sCreating a macro 3m 28s Finding and running a macro 2m 56s 11. Proofing Your Documents-13m 7sChecking spelling and grammar 4m 10s Setting proofing and autocorrect options 4m 31s Using the thesaurus, research, and translation tools 4m 26s12. Reviewing Documents with Others-15m 10sInserting and reviewing comments 3m 23s Tracking changes and showing markup 6m 58s Comparing and combining documents 4m 49s13. Sharing Documents with Others-17m 44sGetting documents ready for sharing 5m 43s Saving documents to SkyDrive 4m 15s Sending documents via email 2m 24s 14. Customizing Word-14m 5sChanging 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 TrainingDuration : 5h 4m Level : BeginnerIntroduction 1m 47sWelcome 1m 5sUsing the exercise files 42s1. Getting Started 23m 43sKey database concepts 4m 21sLaunching Access and the Backstage screen 1m 41sCreating the database file 3m 25sUnderstanding the Trust Center 3m 2sDigging in to Ribbon tabs 3m 39s2. Creating Tables 23m 54sUnderstanding table structure and relationships 4m 18sCreating a table and setting data types 4m 15s3. Setting Field Properties 29m 37sEstablishing relationships and maintaining referential integrity 6m 28sEditing table structure in Design view 3m 58sControlling input with masks 5m 4sSetting the default value 2m 15s4. Organizing Records 11m 3sFormatting columns 2m 52sSorting table data 3m 18sFiltering table data 2m 21sSearching and replacing values 2m 32s5. Using Queries 39m 35sUnderstanding queries 2m 2sCreating queries with the Simple Query Wizard 4m 24sBuilding queries in Design view 4m 58sEstablishing constraints with criteria 4m 14sSpecifying criteria with wildcards 3m 50s6. Working with Specialty Queries 19m 13sUsing update queries 3m 21sUsing make table queries 2m 57sUsing delete queries 2m 48s7. Creating Forms 12m 47sUnderstanding the role of forms 2m 52sGenerating forms from tables 3m 10sAdjusting form elements in Layout view 4m 7sUsing the Form Wizard 2m 38s8. Designing Forms 44m 23sCreating forms in Design view 3m 50sExploring the form property sheet 3m 13s9. Creating Reports 32m 56sIntroducing reports 2m 15sUsing the Report Wizard 5m 9s10. Working with Macros 25m 0sCreating macros 5m 3sEmbedding macros into buttons 7m 50sAttaching data macros to tables 9m 5sLaunching macros at startup 3m 2s11. Integrating Access with the Office Suite 12m 12sExporting tables to Excel 3m 8sEmailing with macros 4m 4s12. Maintaining the Database 27m 24sOrganizing the Navigation pane with custom groups 2m 59sCompacting and repairing the database 1m 20sExamining database object relationships 2m 58s