Trusted teacher

Hello there, Thank you for clicking here! During my last couple of years I have taught different students who passed their ICDL/ECDL exams with flying colors. During these classes I'll give you everything you need to pass your exams even if you never used any of these programs, I am a certified ICDL instructor. Even if you dont need to take any ICDL/ECDL exams, maybe you just want to be comfortable using these programs. I mainly specialize in Excel, Word, PowerPoint, Access and advanced, if you need other modules it can be arranged as well such as Security, Online Collaboration and other ones as well.

Trusted teacher

Master Microsoft Access with personalized online classes! Boost your data management skills and learn how to design databases, create queries, and generate reports with one-on-one guidance. Flexible scheduling, practical exercises, and tailored lessons to fit your goals.

Trusted teacher

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 schemas: relay tables, star schemas, 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

Trusted teacher

With extensive experience in creating databases for the management of different areas of activity. In addition, mastery of the integration of Access with other office automation tools. The courses are dedicated to students and professionals.

Trusted teacher

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 ...

Trusted teacher

EXCEL POWER POINT WORD and ACCESS are inevitable software when working with a computer. I will introduce you to this software with exercises to do by yourself, exercises accompanied by courses appropriate to your requests.