Add to Wish List
from258.01CNY/ h
Master Microsoft Access software (Beginner / Advanced)
Translated by Google. Click to view original.
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
Extra information
Translated by Google. Click to view original.
Bring your laptop with Microsoft Access software.Location
Online via webcam
At teacher's location: Pannenhuis, Métro Pannenhuis
At student's location: Around Brussels, Belgium
|
Use ⊞+wheel to zoom!
General info
Age: | Children (7-12 years old) Teenagers (13-17 years old) Adults (18-64 years old) Seniors (65+ years old) |
---|---|
Student level: | Beginner Intermediate Advanced |
Duration: | 60 minutes |
The class is taught in: | French, English, Arabic |
About Me
Translated by Google. Click to view original.
I am Anas, computer trainer / consultant.Having graduated in Audit Management Management Audit, I first worked in the field of finance before switching to the field of IT management.
I have a lot of affinities with technology and I like to transmit my know-how.
My strong point is to have the ability to transmit knowledge using practical and concrete examples, far from theoretical and abstract concepts. I prefer the learning method "Learning by doing".
I have already trained hundreds of people in:
* Office (Excel, Access, Word, PPT)
* Digital Marketing: Facebook, Linkedin, Search Engine Optimization, Google Adwords, Google Adsense
* Wordpress
* SAP (Introduction, Finance, Sales & Distribution, Material Management)
Education
Translated by Google. Click to view original.
Master in Management Sciences (Financial Audit Specialty) (UMONS)Special Master in Tax Management (Solvay - ULB)
Cetificat in Digital Marketing (ICHEC)
Microsoft Office Specialist Excel Certification - Expert
SAP Finance certification
Experience / Qualifications
Translated by Google. Click to view original.
IT Consultant / TrainerComputer trainer
Management control
Tax Consultant
Financial auditor
Reviews (12)
Very attentive, really tries to offer a technical solution adapted to our professional needs.
Translated by Google. Click to view original.
Anas is great teacher! He is really patient, helpful and supportive; and he explains everything in a clear way. I definitely recommend him! Thank you very much!
very friendly and good teacher
Anas is an excellent teacher and very patient!
thanks to him
Translated by Google. Click to view original.
I recommended for Excel courses. I learned a lot in just a few courses
Translated by Google. Click to view original.
...
_*IMPORTANT*_
It will depend on how fast you learn, but you should allow at least 3 hours for a quick start.
Here is the proposed program:
I) What is SAP?
* Introduction to SAP (ECC)
* The main functions of SAP
* SAP architecture
* Structure and organizational data
* Overview of SAP functional modules (FI, SD, MM, PP etc.)
II) SAP : Getting Started
* Navigating the SAP system
* Logging in and out
* Presentation of the home screen
* Organization of SAP screen (fields, tabs, tables...)
* Use of the data search functions
* How to navigate in SAP
* Transaction system
* Examples of flows
Accounting on SAP:
- General accounting (G/L accounting)
- Supplier Accounting (Accounts Payable)
- Customer accounting (Accounts Receivable)
- Automatic Payment Program
- Bank accounting (Banking)
- Cost center accounting
>>> What is Excel?
Microsoft Excel is a spreadsheet that allows you to do calculations, analyze data with formulas, tables and graphs.
>>> What about pedagogy?
I favor the learning by doing method
>>> Who am I?
For information, I am consultant / trainer and certified Microsoft Excel Expert.
I have considerable experience in training. Indeed, I have trained hundreds of people whether in groups, or in private.
>>> Location of the training?
The place is to be agreed with the apprentice.
Training can also be organized remotely (Teams, Zoom, Google Meet, Skype...)
>>> Content of the training
I can adapt to your level and your needs in terms of content.
Here is a non-exhaustive example of the subjects taught.
**** Excel Training (Beginner and Intermediate) ****
Part I: Basic Concepts
What is Excel?
Discover the Excel window.
Workbooks, spreadsheets, cells.
Use the toolbars, the menu, the help.
Part II: Working in a spreadsheet
Identify basic concepts
Manage cells: capture and copy
Set up formulas.
Master the modes of referencing cells: absolute, relative.
Insert, delete rows or columns, move fields.
Part III: Formatting a spreadsheet
Format cells: present numbers, text, titles.
Define conditional formatting.
Print the entire sheet or part.
Build the layout: titles, pagination
Part IV: Workbook Management
Save, edit a workbook.
Divide your data over several sheets.
Insert, delete, move, copy a sheet.
Edit multiple sheets simultaneously
Part V: Data Analysis Using Functions
Calculate percentages, establish ratios.
Perform statistics: AVERAGE, MAX, MIN
Apply conditions: SI.
Use functions: NOW, TODAY.
Consolidate multiple sheets of a workbook with the SUM function.
Part VI: Linking spreadsheets
Transfer data from one table to another
Copy / paste with link.
Create summary tables.
Part VII: Illustrate with graphics
Create a chart from a table
Change the type: histogram, curve, sector.
Add or delete a series.
**** Excel Training (Advanced) ****
Part I: Configure Excel Options
Set up Excel options.
Customize the interface.
Part II: Gaining time to present his paintings
Define styles, use themes.
Define conditional formats.
Insert Sparklines charts.
Part III: Creating simple and complex calculation formulas
Master the various modes of referencing: relative, absolute, mixed.
Name cells.
Set up simple and complex conditions: IF, OR, AND.
Calculate statistics: NBVAL, NB, NB.SI.
Use mathematical functions: Sum and SUM.
Retrieve data with search functions: VLOOKUP
Calculate dates, times: DATE(), DAY() and MONTH() ...
Manipulate text: CAPITAL, MINISCULE and CONCATENATE.
Protect formulas, sheets or binders.
Part IV: Consolidation of data
Link multiple cells in a workbook.
Manage connections between workbooks.
Consolidate tables in a workbook.
Consolidate data from multiple workbooks.
Part V: Exploiting Data Lists
Tris multicriteria.
Custom sorting: Numeric, Textual and Chronological.
Extract data: advanced filters.
Delete duplicates.
Part VI: Implementing Pivot Tables / Charts
Create charts / pivot tables
Group the information by period and by slice.
Filter and sort
Segment filters
Show / hide data.
Add ratios and percentages.
Ask a question
Send a message explaining your needs and Anas will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 258.01 CNYAt teacher's location
from 258.01 CNYOnline via webcam
from 351.83 CNYAt student's home
100% Satisfaction Guarantee
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Online reputation
- Instructor since October 2019
- Phone number verified
- Google connected
Availability of a typical week
(GMT -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 258.01 CNYAt teacher's location
from 258.01 CNYOnline via webcam
from 351.83 CNYAt student's home
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Share
You are here
Private lessons
in Brussels
Similar classes
Imane
Introductory programming course for children or beginnersPassionate about the world of programming, I offer courses suitable for beginners of all ages, including children. I am a computer engineer, also with experience in online tutoring with high school and university students, I guided them in understanding their homework and assimilating sometimes complex concepts. In addition, I had the privilege of introducing the basics of programming to young people through fun courses using Python and Scratch software. My goal is to make learning programming accessible, engaging and stimulating, thereby encouraging a lasting passion for this fascinating discipline.
Reza
Systematic Reasoning and Logical Thinking for Computer ScienceYou will learn Systematic Reasoning & Logical Thinking which is a requirement for entering Computer Science program in many universities.
The book “Delftse Foundations of Computation” especially its second chapter will be the main source of our lesson, but other more in-depth books will be also covered if you want to improve even further on logical thinking.
The topics in our lesson include:
• Propositional Logic: Logical operators; Precedence rules; Logical equivalence; Implications in English; Exclusive or; Universal operators; Classifying propositions
• Boolean Algebra: Substitution laws
• Logic Circuits: Logic gates; Combining gates to create circuits; From circuits to propositions; Disjunctive Normal Form; Binary addition.
• Predicate Logic: Predicates; Quantifiers; Tarski’s world and formal structures;
• Deduction: Valid arguments and proofs; Proofs in predicate logic
If you have any additional questions before starting a class, please feel free to ask me. I am here to assist! :)
Mazuba
Introduction to C# and Visual Studio: A Beginner's Guide (Project Based Learning)Discover the power of C#, a language widely used in game development, desktop applications, and enterprise solutions. This class will introduce you to the fundamentals of object-oriented programming and application building.
What You’ll Learn:
C# syntax and basics: Variables, loops, and conditions.
Introduction to IDEs: Working with Visual Studio and debugging tools.
Object-oriented programming (OOP): Classes, objects, and methods.
An overview of building basic applications using C#.
Tristan
Job search, CV creation, cover letter, job interview simulations.Boost your job search with tailor-made support!
Are you looking for a job or would like to land an internship? I offer you a complete service to maximize your chances of success:
- Creating impactful CVs: Highlight your skills and background with a professional design and impactful content.
- Writing cover letters: Stand out with convincing texts tailored to each position.
- Job interview simulations: Prepare to answer key questions and highlight your strengths through personalized coaching sessions.
With more than 10 years of experience in project management, HR management and a mastery of modern tools, I support you at every stage so that you can approach your job search with confidence.
👉 Contact me now to discuss your needs and start building your professional success!
Robert
Excel lessons, at your place, at my place or remotely, at your best convenience!As a Franco-Belgian management teacher, I give Excel lessons with passion!
Whether remotely or face-to-face, I offer many examples and exercises to accompany you.
I travel without problem throughout the region of Brussels and its surroundings, for lessons of at least 2 hours. For France, courses are only given remotely.
Here are some key words that will be covered in my classes:
Scenario analysis, Year, Rounding, Today, Bdnb, Bdnbval, Bdsum, Search, Column, Copy/paste in values, Copy/paste with transposition, Consolidation, Date, Datedif, Determat, Dollar, Right, Righterg, Equiv, Esterror, Estna, Frequency, Filter (simple and advanced), Format of cells, Left, Large.Value, Printing of documents, Index, Indirect, Inversemat, Day, Weekday, Line, Matrix, Max, Maxa, Max.Si, Min , Mina, Mina.If, Formatting of cells and ranges, Month, Average, Average.If, Nb, Nb.If, Nbval, Naming of cells and ranges, No, Small.value, Product, Productmat, Protection of cells, Lookup (Lookup), Lookupv (VLookup), Lookuph (HLookup), If (If), If.Not.Disp, If.Conditions, Iferror, Sum, Sumproduct, Sum.If, Sum.If.Set, Substitute , Pivot tables, Sorting, Cell locking
Do not hesitate to contact me to organize your lessons according to your needs and availability. Together, we will develop your Excel skills in an efficient and personalized way.
Hamza
Maîtrisez Python avec un Expert en Programmation et Data ScienceDécouvrez la puissance de Python avec un formateur expérimenté en informatique !
Je suis Hamza, un développeur passionné et mentor chevronné avec une vaste expérience dans l'enseignement de la programmation. Mon approche pédagogique unique vous permettra d'acquérir rapidement des compétences solides en Python, tout en découvrant ses applications concrètes dans le monde professionnel.
Ce que vous apprendrez :
Fondamentaux de Python (variables, structures de contrôle, fonctions)
Programmation orientée objet avancée
Analyse et visualisation de données avec pandas et matplotlib
Développement d'interfaces graphiques avec PyQt
Projets pratiques inspirés de cas réels en entreprise
Pourquoi me choisir ?
Plus de 5 ans d'expérience en formation et mentorat
Méthode pédagogique adaptée à tous les niveaux
Approche hands-on basée sur des projets concrets
Passion contagieuse pour le code et l'innovation technologique
Que vous soyez débutant cherchant à vous lancer dans la programmation ou professionnel souhaitant monter en compétences, ce cours vous ouvrira de nouvelles perspectives passionnantes dans le monde du développement logiciel et de la data science.
Rejoignez-moi pour un voyage captivant au cœur du langage de programmation le plus polyvalent et demandé du marché !
Réservez maintenant et faites le premier pas vers la maîtrise de Python. Votre carrière en tant que développeur Python commence ici !
Adam
Basic concepts of algorithms and data structures in computer scienceOnline Course: Basic Concepts of Algorithms and Data Structures
Duration :
- 60 minutes: condensed format to introduce fundamental concepts with targeted exercises.
- 90 minutes: extended format to explore concepts in depth, solve complex problems, and include an interactive question-and-answer session.
---
General description
This course is designed for students and professionals who are new to computer science, as well as those who want to solidify their foundation in algorithms and data structures. It provides a clear and practical introduction to the essential tools for solving problems effectively, by learning how to design and analyze algorithms. Whether you are preparing for an exam, a technical interview, or want to improve your programming skills, this course will guide you in understanding theoretical concepts and their practical application.
---
Educational objectives
At the end of the course, participants will be able to:
1. Understand the fundamental concepts of algorithms: sorting, searching, time complexity.
2. Master key data structures: arrays, lists, stacks, queues, trees, and graphs.
3. Solve problems by choosing appropriate data structures and algorithms.
4. Analyze and optimize the performance of algorithms.
---
Course syllabus
1. Introduction (5-10 min)
- Presentation of the objectives and concepts covered.
- Importance of algorithms and data structures in computer science.
2. Fundamental concepts (20-30 min)
- Definitions and roles of algorithms and data structures.
- Temporal and spatial complexity: basic notions (Big O).
- Basic data structures: arrays, lists, and dictionaries.
3. Practical application and examples (30-40 min)
- Simple sorting implementation (insertion sort, bubble sort).
- Search example (linear search, binary search).
- Manipulation of stacks and queues through practical exercises.
- Bonus for the 90 min format: Exploration of trees and graphs (simple example of a route).
4. Q&A and conclusion (5-10 min)
- Review of the concepts covered.
- Tips for continuing to practice and progress.
- Suggestions for personal projects to apply the knowledge acquired.
---
Teaching methodology
- Interactive learning: a combination of theoretical explanations and practical applications.
- Concrete examples: each concept is illustrated by practical cases and guided exercises.
- Adaptation to needs: the courses are adjusted to the level and objectives of each participant, with a focus on the most relevant aspects.
---
Target audience
This course is aimed at:
- Computer science students wishing to strengthen their mastery of the basics before exams or projects.
- Programming beginners who want to understand the essential mechanisms behind problem solving.
- Professionals preparing for technical interviews or seeking to improve their understanding of algorithms.
---
Benefits of this online course
- Personalized support from an experienced trainer.
- Educational materials and practical exercises accessible after the session.
- Flexible hours to fit your schedule.
- Progressive approach to facilitate learning, even for beginners.
Develop your skills in algorithms and data structures today to efficiently solve the complex problems of tomorrow!
---
Brahim
Introduction to NoSQL DataBase MongoDB by PratiqueDo not deal with the manual with terms of reference statements and basic documents that cannot be obtained in order to avoid the MongoDB problem. Please include the connection to one of the MongoDB données base, comment on simple CRUD operations and sujets clés que l'agrégation, l'indexation, la mode des données et les Transaction.
1- Install MongoDB
2- Implement MongoDB
3- Use of documents and collectibles
4 - Leadership Committee
5- Execute CRUD commands (create, read, update, delete) avec mongo shell
6- Type the register in a MongoDB database
7- Reset the base to remonter specific documents depuis mongo shell.
8- Lagrégation
9- Indexing
10- Amending institutions and transactions
Youness
Office Automation Training: Excel, Word, Remote Power Point / Online- I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely.
- For more information, contact me.
- I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely.
- For more information, contact me.
- I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely.
- For more information, contact me.
Hayat
Master the Essential Tools of Microsoft Office: Word, PowerPoint and Excel"Do you want to master Microsoft Office tools?
This course offers you comprehensive training on the three most popular applications in the Microsoft Office suite: Word, PowerPoint and Excel.
Whether you are a beginner or already have some basics, this course is designed to adapt to your level. You will learn how to create documents, dynamic presentations and use spreadsheets for efficient management of your data.
Sessions can be customized to your needs, whether you prefer individual or group learning. With my support, you will quickly become comfortable with these essential tools.
If you have any questions or would like to know more, please do not hesitate to contact me!
Anass
Computer and office training Word Excel and PowerPointHello,
You want to learn the basics of computers or how to use software such as Word, Excel or Powerpoint.
I will give you the skills you need to better understand the features of this software to write, for example, a document.
I will also give you advice on how to make the most of the internet, protect and back up your data, or on the day-to-day use of your computer.
Contact me.
Martial
Graduate teacher gives courses in Physics & Chemistry, Mathematics, many years of experience.I am a dynamic and demanding teacher who gives private lessons in Physics-Chemistry as well as Mathematics.
I graduated from teaching seven years ago, after a masters in physical sciences with honors, and I teach in college and high school since.
I have also been preparing students for the Baccalaureate Science for many years, all of whom have been awarded very good honors.
I also prepare my students for different exams (Matu, Bac, preparation for EPFL, etc...)
I make sure to rework the basics so that the student can progress quickly. It is important to me that my students acquire a solid foundation of knowledge.
I also give effective work methods that will allow him to progress much more quickly and so he can regain self-confidence.
I can go to the student's home or also take the course via Skype.
Nancy
Mathematics, Computer Science and Python Tutor for youMany of students find it difficult to understand the mathematical concepts and programming algorithms. But don't worry as I know how to make that easy for you to understand these concepts.
I have completed mathematics honors and pursuing data science and Artificial Intelligence. So, what all you need is my support to ease your learning.
I can help you in any mathematical and computer science concept. Also, I am very familiar with Python
Salah
Learn MS (Word, Excel and PowerPoint) Microsoft Office / Expand your knowledge of Microsoft office!I offer Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Office sessions
Word is a word processing software developed by Microsoft. It is used to create documents, letters, reports, presentations...
Excel is a spreadsheet software from the Microsoft Office suite developed and distributed by the publisher Microsoft. It is used to create spreadsheets, tables, graphs, etc.
Powerpoint is a presentation software developed by Microsoft. It is part of the Microsoft Office suite. It is used to create presentations, slide shows...
I am waiting for your message.
Ron
American Harvard and Yale Educated Tutor - Click “Request a Booking” to Book a ClassI am an Ivy League educated tutor ready to help you learn computer science to achieve higher exam scores, gain admission to top universities and advance your career.
I encourage students to explore topics they enjoy and strive to make each lesson entertaining. Learning should be fun, so my approach expands students' horizons, increasing their creativity so they realize their potential.
Please click “Request a Booking” to book a class.