Database avec SQL et Access et autres outils bureautiques

Microsoft Excel and Access are great tools for maintaining MIS and perform automated functions. Being an expert I would like to help learn the basics as well as perform advanced operations. For Beginners, In each class I would attempt to teach excel functions. For Advanced, In each class I would attempt to solve their daily problems or better ways to manage and represent data including use of Macros.

EXCEL POWER POINT WORD et ACCESS sont des logiciels inévitables lorsque l'on travail avec un ordinateur je vous ferai découvrir ces logiciels avec des exercices à faire par vous même ,exercices accompagnés de cours appropriés à vos demandes

Office automation plays an essential role in the management of your business or at home this court list is for you yourself to be able to practice computer and office tools like professionals from A to Z ...

Quelque soit votre niveau, débutant ou avec des notions, étudiant ou salarié. Excel n'est pas destiné aux programmeurs ou les mathématiciens, plutôt un MUST LEARN outil pour toute personne qui se prépare pour intégrer le monde professionnel ou qui y est déjà. Il suffit juste la volonté et la rigueur. Je mets a votre disposition des méthodes simple pour apprendre Excel et l'utiliser au quotidien. Structure Excel Formule et fonctions. Tableau croisé dynamique Connexion avec MS ACCESS la mise en forme Les graph(Dynamique et static) les tableau de board. Macro VBA

I will help you master all the features of Microsoft Access software. objectives: --------------- Acquire the essential bases of Microsoft Access software. Structure a relational database. Define queries. Build forms and reports. Create simple macros. Acquire a methodology to design and manage a database. Whatever your basic level, I will adapt to it in order to help you progress. Program ------------------- Module 1: Presentation of Access software Familiarize yourself with Access Find your way around the screen: toolbar, status bar, menus, ruler Methodology for building a database Creation of a database and DBMS Importing data from Excel into Access *** Module 2: Design and organize your database Organize and distribute your data between different tables Create tables, define fields Identify the index primary key Define relationships, ensure referential integrity Import, export and link data. *** Module 3: Relationships Link tables The different types of relationships (one to one, one to many) Referential integrity Join types Create a drop-down list Complex relational diagrams: relay tables, star diagrams, etc. *** Module 4: Query your database with queries Selection queries: choice of fields, sort order, definition of selection criteria Extract data by setting criteria Grouping on a field, on an expression Multitable and cross-analysis queries Action requests: update, add, delete, create a table. *** Module 5: Calculated queries Column calculations Online calculations: formula syntax, use the expression generator Some calculation functions: (True false, Extraction of strings, Upper case, Lower case) *** Module 6: Creating Forms and Entering Data Create an instant form Create an instant table form Manage data: add, delete, modify, search, filter records Modify the form Subforms: creation, integration into a form Editable drop-down lists. *** Module 7: Creating Reports Create a label report Create a report using the wizard Change state Creation of column or tabular reports Sorting and grouping Direct mail report. Printing a report. *** Module 8: Creating Complex Forms Hierarchical organization of forms Create a form and a subform Insert action buttons: search list, command buttons Insert calculations

I have been doing online computer tutoring on topics including database programming such as Oracle Sql,SQL server,MS Access,MS Excel ,jav and HTML I have been volunteering as a computer tutor for couple of years in Schenectady county public library,New York Previously was tutoring as GED math tutor for more than 50 hours tutoring in Literary Newyork Greater capital region,New York I hold bachelors Degree in Information Technology

You are a financial director or boss of your SME, a manager in a large company, or you want additional training to perfect your knowledge. If you spend more than 4 hours a day on your Excel files, if you feel overwhelmed by your next budget, if your reports lack punch, nothing is lost! Hello, My name is Yves. I have more than 25 years of business experience (of all sizes) and have worked in multiple functions (sales, purchasing, planning, supply chain, administration). Today I choose to help business professionals by accompanying them in their project and training them to become more efficient in their tasks. Excel is a fantastic and underutilized tool. I teach Excel at all levels, including VBA programming. I work on PC, but also on Mac, both FR and US version of Excel.