Search This Blog

Sunday, October 20, 2013

Learn MS Word 2013 & MS Access 2013 Video Training DVD Rs 350/-





Duration : 5h 9m



Released : Jan 29, 2013

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  
  • Opening and editing PDF documents 3m 5s  
  • Printing documents 3m 56s  


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  
  • Creating your own Quick Styles 5m 15s  
  • Restricting formatting to a selection of styles 4m 0s  


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  
  • Creating levels in a list 2m 40s  
  • Creating a multilevel list with styles 3m 46s  


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  
  • Sorting data in a table 2m 27s  
  • Merging and splitting cells 2m 55s  
  • Converting a table to text 2m 28s  
  • Inserting an Excel table 5m 41s  


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  
  • Illustrating with WordArt 4m 32s  
  • Inserting online video into a document 2m 30s  
  • Diagraming with SmartArt 6m 49s  
  • Inserting screenshots 2m 34s  
  • Inserting a chart 5m 57s  


10. Using Macros and Building Blocks-19m 7s



  • Creating a macro 3m 28s  
  • Finding and running a macro 2m 56s  
  • Editing a macro 2m 28s  
  • What are building blocks? 4m 58s  
  • Creating and saving Quick Parts 5m 17s  


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  
  • Password protecting a document 1m 49s  
  • Restricting editing for part or all of a document 3m 33s  


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  
  • Conclusion24s
  • What's next? 24s  

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
Using the Navigation pane 3m 36s
Using the Quick Access Toolbar 1m 14s
Signing in to Microsoft Live 50s
Taking backups 47s
Accessing help 1m 8s

2. Creating Tables 23m 54s
Understanding table structure and relationships 4m 18s
Creating a table and setting data types 4m 15s
Entering data 4m 0s
Understanding primary and foreign keys 6m 24s
Importing tables 4m 57s

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
Establishing validation rules 3m 21s
Creating lookup fields 4m 29s
Setting additional field properties 4m 2s

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
Leveraging multiple criteria with AND and OR statements 4m 32s
Filtering with mathematical comparisons 2m 20s
Creating flexible queries with parameter requests 3m 45s
Building expressions 5m 23s
Obtaining summary statistics 4m 7s

6. Working with Specialty Queries 19m 13s
Using update queries 3m 21s
Using make table queries 2m 57s
Using delete queries 2m 48s
Using append queries 2m 49s
Getting a different look with crosstab queries 2m 58s
Creating a union query in SQL view 4m 20s

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
Setting data sources 5m 39s
Adding components with form controls 6m 8s
Understanding input boxes 3m 31s
Recording navigation 2m 36s
Adding buttons 4m 18s
Assigning tab order 4m 5s
Checking out the More Forms options 7m 27s
Creating a navigation form 3m 36s

9. Creating Reports 32m 56s
Introducing reports 2m 15s
Using the Report Wizard 5m 9s
Creating a report in Design view 5m 20s
Grouping and sorting records 4m 5s
Creating calculated totals 3m 32s
Applying conditional formatting rules 5m 19s
Creating labels 4m 18s
Adjusting print settings 2m 58s

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
Linking to data in an Outlook database 2m 18s
Setting up labels and mail-merge documents in Word 2m 42s

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
Documenting your work 4m 41s
Printing the blueprint of your database with the Database Documenter 2m 40s
Splitting a database into front and back ends 2m 34s
Protecting the database with a password 2m 55s
Creating custom Ribbon tabs 3m 35s
Setting startup options and custom icons

======================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 
======================================================================

Term

Shipping Banner
Payment mode : CASH ON DELIVERY , Prepaid ,Buying via ebay or ShopClues or Snapdeal


Payments :
Credit Card , Debit Card , Net Banking , EMI , Cash on Delivery

Shipping : By Courier through all over India


You can get with in two days

Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia  Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available



Place your Order On

For more details

Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDVDs

No comments:

Post a Comment