Translated by GoogleSee original

Master Microsoft Access software (Beginner / Advanced)

From 33 € /h

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

Bring your laptop with Microsoft Access software.

Location

Use Ctrl + wheel to zoom!

At student's location :

Around Brussels, Belgium

At teacher's location :

Pannenhuis, Métro Pannenhuis

Online from Belgium

About Me

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

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

IT Consultant / Trainer
Computer trainer
Management control
Tax Consultant
Financial auditor

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

Skills

Computer science

Microsoft access

Reviews

Availability of a typical week

(GMT -05:00)

New York

At teacher's location and via webcam

At student's home

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

SAP Introduction Training (hands-on training) / Remote training

53 € /h

_*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 end-user (SAP Finance end-user)

53 € /h

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

Renaud

5.0

(23)

Trainer for 10 years, I offer to support you in your learning of Illustrator software by working on concrete examples.

My experience as a trainer allowed me to sharpen my teaching techniques. I adapt to the level of the student to help him master the tools offered by this software.

Zidene

5.0

(23)

Graduate computer engineer offers an individualized pedagogy, professional training, assistance with the preparation of interrogations or exams. My goal is to advance the student without overburdening him. I give practical tests after each lesson and periodically provide progress reports.
Here is the list of courses I propose:
- Programming: JAVA, J2EE, C, C ++
- Web: HTML, PHP, CSS, JAVASCRIPT
- Data base
- Operating systems: Windows, Linux ...
- Software ...

Maria

5.0

(23)

Hello everyone !

Use 2 fingers to type a document or something else? this keystroke will consume you a lot of time!
The typing course that I propose will allow you to acquire a certain speed of typing without looking at the keyboard, because your fingers will recognize, by default, their places on the keyboard.
Do not waste time, learn to type quickly for your use!

Hela

5.0

(23)

I adapt my learning method according to subject and student. Some prefer to understand the whole theory before starting the exercises, others prefer to practice to better understand the theoretical part.
I strongly encourage the student because the state of mind and morale have a direct influence on school results.
I am an understandable person and I always try to take each one in his own way, to give remarks that facilitate the work, to give the tips and tricks necessary to have a good note.
I do exercises and exams corrected.
I always try to do my best to make the student fast able to handle his homework.

Himank

5.0

(23)

Currently, I am working at the MaaS department in Denso Corporation, Shinagawa, Tokyo.
I have done my masters from the Indian Institute of Technology Hyderabad India recently.
I can teach any subject of Computer Engineering. I will give you class from very basic to advanced level.

I have cracked Graduate Aptitude Teset (GATE) in India and score AIR 1456 among 100000 students. I have in-depth knowledge of Computer Science subjects.

I can teach you coding, Science and Math if you wish to learn new things contact me.

This class is for those who really want to use to learn computer subjects like Computer Networks and Algorithms in a more innovative manner.

I can help you in deciding on your final year project in Computer Science Domain as well.

I little bit know Nihon-Go as well.

Robert

5.0

(23)

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.

Valnor

5.0

(23)

💻 Learn IT easily with tailor-made support! 🚀
Do you want to improve your computer skills or discover the basics to better navigate the digital world? I offer courses adapted to all levels, whether you are a beginner or looking to improve.
🌟 Why choose me?
• Adapted teaching: I explain concepts in a simple and clear manner, even for novices.
• Personalized courses: Each session is designed according to your needs and objectives.
• Hands-on learning: Immediately apply what you learn.
📘 Areas covered:
• Introduction to computers (using the computer, browsing the internet, security).
• Office software (Word, Excel, PowerPoint).
• Introduction to programming (Python, HTML/CSS).
• Basics of data management and analysis with tools like Power BI.
🕒 Flexible hours: Classes available on weekdays or weekends, depending on your schedule.
📍 Modalities: In person or online, according to your preferences.
👉 Contact me now to start your adventure in the digital world!

Salomé

5.0

(23)

A 34-year-old university graduate, business engineer, with 12 years of professional experience, offers her teaching services.

Lessons (1 hour online only) - 1.5 or 2 hours depending on the subject/level/location
Educational and organized teacher with excellent revision and organizational techniques
Microsoft Office - Excel/Word/PowerPoint - email - typing - ...

Educational and patient with a good methodology adapted to each student

97% success rate with regular monitoring

Feel free to contact me for more information!
See you soon

Lionel

5.0

(23)

Always wanted to learn programming but you don't know where to begin? Discover Python programming today with tailor-made courses. Whether you have never programmed in your life, have some knowledge or already program professionally, I adapt my lessons to your needs.

- For beginners, the idea is to first introduce certain key programming concepts while applying these concepts to the Python language.
- For intermediate and advanced levels, we can deepen your knowledge or start a concrete project to fill your knwoledge gaps.

My goal with these courses is to pass on my passion for programming to you and to give you all the tools you need to launch into your projects!

My lessons are adapted to all ages

Alicha

5.0

(23)

Classes are face-to-face at the student's home or via webcam. You will learn computer science according to your level and what you want to learn. I am a computer science student so quite versatile. As far as programming is concerned, the possible languages are: HTML, CSS, PHP, Python, C and C++, for the network, introduction to software such as Cisco packet tracer, GNS3, vmware, virtual box. Introductory computer courses, even rudimentary ones, are possible. You will learn in a jovial and encouraging atmosphere, I have a lot of experience in the field of teaching and I am comfortable with children

Ajay

5.0

(23)

I can teach mathematics (from primary to bachelor level), computer science, coding, and high school level physics.
Available to teach online/offline.
I make sure to adapt to the needs of the students, preparing specific exercises according to their knowledge and interest levels while not compromising on the learning aspects. I can also be flexible with the availability and timings so as to suit the needs of all concerned.
Born and raised in India; fluent in English and Hindi, currently learning French. I have been living in Brussels for more than a year now. I have Bachelor of Technology in Computer Science and a Master of Science (Mathematics) from India. Currently pursuing Master in Mathematics from KU Leuven (2nd year).
My dream is to become a high school teacher and I see tutoring as a big and important step in that direction.

Mohamed

5.0

(23)

This course provides a hands-on approach to mastering Apache Airflow, a powerful open-source workflow automation tool widely used in ETL (Extract, Transform, Load) processes. You will learn how to build, schedule, monitor, and optimize data pipelines, ensuring data reliability and efficiency in production environments. Through real-world examples and projects, you will gain the skills required to become a proficient Data Engineer capable of handling complex workflows in modern data ecosystems.

This course will allow you to build multiple real-world ETL workflows using Apache Airflow. Let me know if you would like additional information! 🚀

Said

5.0

(23)

Are you preparing for your Digital and Computer Science (NSI) exams and want to maximize your chances of success? "NSI Booster: Intensive Preparation to Shine in Your Exams!" is the course you need to revise effectively, fill in your gaps, and excel on the big day! This comprehensive and intensive program is specially designed for students in Première and Terminale to master all the key concepts of the NSI program and pass with flying colors.

Why choose this NSI preparation course?
Optimize revision time: Focus on the essential concepts to save time and revise efficiently.
Deep understanding of concepts: Don't just memorize, really understand the basics of computing to succeed in the most complex exercises.
Intensive practice: Practice with corrected exercises, exam questions and past papers to be fully prepared.
Exam Methodology: Learn how to manage your time, structure your answers, and avoid common NSI question pitfalls.
Confidence and serenity: Work in a progressive and structured manner to arrive calm on the day of the exam.
What you will learn:
This course covers the entire NSI program for Première and Terminale, focusing on the concepts most often covered in exams:

1. Algorithms and Programming:
Advanced algorithms: Algorithmic complexity, recursion, sorting and searching (quick sort, dichotomous sort).
Programming in Python:
Advanced syntax: list comprehension, lambda, decorators.
Data structures: lists, tuples, dictionaries, sets.
Functions and modularity: Decomposition of the problem, reuse of code.
File Management: Reading and writing files to process real data.
Object-oriented programming: Classes, objects, inheritance, polymorphism in Python.
Practical projects: Development of complete programs to apply the concepts covered.
2. Data Structures and Algorithms:
Lists, Stacks, Queues, and Trees: Implementation, Manipulation, and Use in Problem Solving.
Graphs: Representation (adjacency matrix, neighbor list), breadth-first (BFS) and depth-first (DFS) traversal.
Sorting and searching algorithms: Merge sort, quick sort, binary search.
Algorithmic complexity: Big-O notation, analysis of algorithm performance.
3. Databases and SQL:
Data modeling: Relational model, database design with the Entity-Relationship model.
SQL:
Select, insert, update and delete queries.
Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN).
Aggregate functions and subqueries.
Optimizing queries for better performance.
Practical projects: Creation and management of databases for concrete applications.
4. Computer and Network Architecture:
Hardware architecture: Processor, memory (RAM, cache), input/output devices.
Computer operation: Instruction cycle, execution of programs in memory.
Computer networks:
OSI model and TCP/IP.
IP addressing, routing, protocols (HTTP, FTP, SMTP).
Network security: firewall, encryption, VPN.
5. Web and Front-End Development:
HTML/CSS: Structure and formatting of web pages.
JavaScript: Dynamics of web pages, manipulation of the DOM, events.
Practical projects: Creation of interactive websites to apply the skills acquired.
Methodology and educational approach:
Targeted and structured revisions: Each module is designed to cover the key concepts of the NSI program while adapting to your level and your needs.
Practical exercises and exam questions: Practice with targeted exercises and past exam questions to familiarize yourself with the exam format.
Detailed correction and personalized feedback: Each exercise is corrected in detail with a thorough explanation of the solutions.
Exam methodology: Advice on how to read and understand the statements, structure your answers and manage your time on the day of the test.
Interactive Online Classes: Classes are conducted online with the use of audio and screen sharing, ensuring seamless communication and interactive learning.
For who ?
This course is aimed at:

NSI students in their first and final year of high school who want to pass their exams with intensive and targeted preparation.
Computer science students wanting to strengthen their foundations in programming and algorithms.
Self-taught people passionate about programming and computer science looking to deepen their knowledge.
Parents who wish to support their children in their academic success in computer science.
Why choose this course?
An experienced teacher: The course is led by a computer engineer with a perfect command of the NSI program, with a clear and motivating teaching approach.
An intensive and comprehensive program: Each concept is covered in depth, with varied exercises to practice all types of questions.
Personalized support: The content and pace of the course are adapted to your level and your objectives.
Flexibility and accessibility: Learn from home at your own pace, with additional resources to deepen your knowledge.
How does it work?
Initial assessment: A personalized assessment to identify your objectives and your starting level.
Interactive online courses: Learn from home with live explanations, demonstrations and practical exercises.
Intensive training: Series of exercises and past papers to prepare you for written and practical tests.
Personalized monitoring: Receive regular feedback on your progress and advice to continuously improve.
Register now !
Don't leave anything to chance when it comes to your NSI exams. Join "NSI Booster" for intensive and targeted preparation, and give yourself every chance of excelling in your exams!

Hanae

5.0

(23)

Hello! My name is Hanae, and I offer personalized lessons in English, Mathematics, and Computer Science for students of all levels — from primary school to university.

With over 10 years of professional experience in the tech and business world, I combine structured methods with a friendly and supportive teaching style to help students gain confidence and achieve their goals.

👩‍💻 In Computer Science, I teach programming basics (C language), digital logic, and software tools such as Power BI, Excel, and SQL.

Whether you want to improve your grades, prepare for exams, or strengthen your practical skills, my lessons are designed to make learning clear, engaging, and motivating.

Lessons can be given online or in person, and I always adapt the pace and content to the student’s needs.

Frédéric

5.0

(23)

Microsoft Office is now a virtually indispensable software suite for almost everyone, whether during our school years, through PowerPoint presentations, document creation with MS Word, calculations and graph creation in MS Excel, or during our professional lives. In the latter case, we need to get even more out of it in a minimum amount of time.

Some may have noticed that it's possible to automate a series of actions by recording "macros" to save time. But have you ever considered that behind these macros lies computer code generated for you in "Visual Basic for Applications" (VBA)? Understanding this type of code and how it manipulates the "object model" associated with the application being used (for example, the worksheets, rows and columns, cells, and the values they contain, in the case of Microsoft Excel) allows you to go further in terms of automation and flexibility.

The course is adaptable to the student and their level. Depending on demand and the number of sessions, it can cover the fundamentals of programming (variables, types, declarations, manipulations, local and global variables, etc.), illustrated using VBA, as well as best programming practices (error handling, using comments, standardizing variable names, code modularity), culminating in the creation of a project enabling interoperability between different Microsoft Office tools (for example, associating notes taken with OneNote with dates in a perpetual calendar created in Excel). It may even cover concepts such as object-oriented programming (polymorphism, encapsulation) and the differences between compiled and interpreted languages.

The sky's the limit :))