V2B Microsoft Office 2010 : Access, Word and Excel to advanced level
Language: French | Duration: 12h 43m | H264 | 15fps 293kbps | 1024×576 | AAC 44.1KHz Mono | 3.14GB

Genre: eLearning

Spend an expert in the use of these three religions software!
This set gives you the key features of Access, Word and Excel are most relevant to advanced use of software. This set is a logical training entitled “Essentials” and allows you to go even further with the software you use every day, whether in professional or private. The trainer James Williamson, whose education has been proven, with you in these formations.

In “Access 2010: Level Development” teaches you how to create index performance and allows you to discover how the macros. Queries related to search for duplicates and unmatched records are also covered in this training and many other topics.
In training “Excel 2010: Level Development”, your instructor presents concepts such as target value, the solver, dynamic linking with external data source, the use of nested IF, the pivot table in relation to Access and more!
Finally, the training “Word 2010: Level Development” you will see how to achieve a targeted mailing your contacts from Outlook, an Access database, an Excel list or a Word table. It is even possible to make editions of envelopes or labels as well as lists of names. A special chapter is dedicated to creating forms and setting up input fields.

Content

Overview of training on Access 2010:
* Presentation of the training
* Index fields
* Small introduction to macros
* More with Forms
* External Insert a photo into a form
* To go further in queries
* Export data
* Administer a Database

Overview of Excel 2010 training:
* Optimization of a result
* Simulation and Decision Making
* Calculations Summary
* Liaison and import
* A concrete example Scoreboard
* A concrete example: optimization of transportation costs

Overview of training on Word 2010:
* Word and long documents
* Insert in Word
* Managing pages
* Finalisation of the document
* Word Mail Merge

Screenshot


Download