facebook
Anas
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
from50.51CAD/ 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 / Trainer
Computer 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?"

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3            Saturday at 3:00  Sunday at 3:00
4            Saturday at 4:00  Sunday at 4:00
5            Saturday at 5:00  Sunday at 5:00
6  Monday at 6:00      Thursday at 6:00  Friday at 6:00  Saturday at 6:00  Sunday at 6:00
7  Monday at 7:00      Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8            Saturday at 8:00  Sunday at 8:00
9              Sunday at 9:00
10              Sunday at 10:00
11              
12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00      
13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00      
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00    Saturday at 14:00  Sunday at 14:00
15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00    Saturday at 15:00  Sunday at 15:00
16  Monday at 16:00  Tuesday at 16:00  Wednesday at 16:00  Thursday at 16:00    Saturday at 16:00  Sunday at 16:00
17  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00    Saturday at 17:00  Sunday at 17:00
18              
19              
20              
21              
22              
23              
from C$50.51At teacher's location
from C$50.51Online via webcam
from C$68.87At 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.

Online reputation

  • Instructor since October 2019
  • Phone number verified
  • Google connected

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3            Saturday at 3:00  Sunday at 3:00
4            Saturday at 4:00  Sunday at 4:00
5            Saturday at 5:00  Sunday at 5:00
6  Monday at 6:00      Thursday at 6:00  Friday at 6:00  Saturday at 6:00  Sunday at 6:00
7  Monday at 7:00      Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8            Saturday at 8:00  Sunday at 8:00
9              Sunday at 9:00
10              Sunday at 10:00
11              
12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00      
13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00      
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00    Saturday at 14:00  Sunday at 14:00
15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00    Saturday at 15:00  Sunday at 15:00
16  Monday at 16:00  Tuesday at 16:00  Wednesday at 16:00  Thursday at 16:00    Saturday at 16:00  Sunday at 16:00
17  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00    Saturday at 17:00  Sunday at 17:00
18              
19              
20              
21              
22              
23              
from C$50.51At teacher's location
from C$50.51Online via webcam
from C$68.87At 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


Imane
Introductory programming course for children or beginners
Passionate 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.

Mohammed Shan
Computer Science Fundamentals and Exam Preparation
📌 What You’ll Learn: ✅ Core Computer Science concepts (Operating Systems, Databases, Networks) ✅ Data Structures & Algorithms (Sorting, Searching, Graphs, Trees, etc.) ✅ Exam preparation (GCSE, A-Level, University courses) ✅ Hands-on problem-solving 🖥️ Teaching Style: I provide interactive lessons with clear explanations, real-world examples, and coding exercises to ensure conceptual clarity. Sessions are structured based on individual learning needs, whether for academic success or competitive exam prep. 📅 Class Format: Mode: Online (Zoom/Google Meet) Duration: Flexible scheduling Group & 1-on-1 sessions available Materials provided: Notes, problem sets, practice questions

Hamza
Maîtrisez Python avec un Expert en Programmation et Data Science
Dé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 !

Bozhidar
Math/Computer Science Tutoring for high-school and BSc Computer Science students
Hey! Are you looking for a young, approachable yet meticulous tutor in Computer Science or Mathematics? Then I believe I might be the tutor for you! I offer lessons in the aforementioned subjects (English only) for high-school and bachelor students at the start of their studies. A little bit about me: My name is Bozhidar and I am a MSc Data Science student at ETH Zuerich. Last year, I completed my bachelor's in Computer Science at TU Delft (the #1 technical university in the Netherlands) with distinction. I was a teaching assistant for 10 courses during my stay at the university. Additionally, I have given private lessons to a few high school and bachelor's students, so I believe I have accumulated enough experience with guiding and tutoring students across different disciplines. I have found out that I enjoy teaching a lot, so that is why I am here - to help you and myself! My expertise: During my high school years, I won tens of awards and scholarships for achievements in Mathematics and Computer Science. I also won my high school's recognition award which is given to one student every year for distinctive results. I've helped high-school and university peers with exam preparation, taught whole courses privately, prepared sample exams, and reviewed and graded real ones. Regarding the university courses I have experience in, I have taught: - Object-Oriented Programming - Reasoning & Logic - Computer Organisation - Algorithms and Data Structures - Web and Database Technologies - Calculus - Information & Data Management - Automata, Computability and Complexity - Concepts of Programming Languages - Computational Intelligence Here are some of the reviews I have received as a teaching assistant: Overall: 4.97/5 (70 reviews) 5/5 - "Great job! Did far more than just explaining this example and went far deeper into the material, helping me to understand it." 5/5 - "Favourite TA. Always there for the difficult questions. Never leaves anything unanswered no matter how long it takes." 5/5 - "Delightful person with an insightful way of thought! Brilliant TA!" 5/5 - "Clear explanations and expert in the material" So, what are you waiting for? Write me a message and let's get the knowledge train running.

Oussama
Mastering Web Development: From Fundamentals to Advanced Techniques
What You’ll Learn: Front-end Technologies: HTML, CSS, JavaScript, React.js, Next.js, TailwindCSS for creating dynamic, responsive applications. Back-end Mastery: Node.js, Nest js, Express, and Fastify for building robust and scalable web servers. Databases: MySQL, PostgreSQL, and MongoDB for handling data efficiently. DevOps & Deployment: Learn Docker, CI/CD with GitHub Actions, and cloud deployment practices to ensure your applications are production-ready. How You Will Benefit: Students: Gain the technical skills and portfolio to ace your academic projects and land internships or entry-level jobs. Self-Taught Learners: Stop the guesswork and follow a structured, hands-on approach to mastering full-stack development faster. Professionals: Upgrade your skills to meet the demands of modern web development and position yourself for career growth. Why My Course is Different: Real-World Projects: You'll build applications that solve real business problems, like a complete e-commerce site, RESTful APIs, and microservices. Tailored Learning: Each course is personalized to your experience level and goals, ensuring you get the most out of every session. Problem-Solving Focus: From debugging to performance optimization, you'll learn to tackle real-world challenges confidently. Industry-Relevant Skills: Stay ahead of the curve with training in modern technologies and practices that top employers are looking for.

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.

Sindhu
Private lessons in: Mathematics/Statistics/Computer Science by a Post Graduate (in English)
Hello, I am Sindhu. I am a mathematics enthusiast and have completed my bachelor's and master's degrees in Mathematics with a Minor in Computer Science. Currently, I am pursuing my doctorate here. I have a passion for teaching and I want to help others understand and appreciate this subject. I am excited about the opportunity to teach you!

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.

Younes
Scratch, Roblox: Code for Fun - A Fun Adventure for Kids and Beginners!
With Scratch and Roblox, programming becomes child's play! Learn how to create animations, games, and interactive stories using colorful, easy-to-manipulate blocks of code. No complex language here, just a visual and intuitive approach to make learning as fun as possible. Whether you are a parent wanting to introduce your children to the language of programming or a beginner curious to discover the world of coding, this training is suitable for all ages. No prerequisites necessary, just a dose of curiosity and a desire to have fun while learning. As a trainer, I am committed to creating a caring and creative learning environment. I will use teaching methods adapted to each child, promoting positive interaction and encouraging the free expression of creativity. The goal is to make each lesson an engaging and enriching experience.

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.

Volodymyr
Programming and Applied Problem Solving, by a Cambridge Grad
For whom: - You have a University Class in Programming - You are at School/Uni and want to get better at coding - You have an assignment or need to write a program for your project but don't know where to start What you will learn: - How to think algorithmically - How to better use AI/ChatGPT for your coding - Leetcode

Antonin
Experienced teacher in private lessons gives private lessons in the Geneva region
Need a catch-up, tutoring, private lessons or help with homework in mathematics? In computer science ? In logic? I'm here for you! I offer you a personalized approach; because there is no one method that works for everyone, I adapt to the needs and requests of each student (and their parents). The first hour of class will be used to define the student's needs, deadlines and strengths. My courses are aimed at secondary school students of all levels, higher education students and anyone wishing to refresh or strengthen their knowledge of mathematics and computer science. I have been helping friends and acquaintances on a voluntary basis for a long time in the success of their studies and I hope to be able to put this experience to the benefit of your success :)

Paul
I am a teacher of mathematics and I give extra hours for private lessons in science subjects
As a math teacher, I offer private lessons in science subjects. My classes are mainly aimed at cycle and college students in Geneva, as well as students from private schools. I can also help people who have already finished their schooling but who need to upgrade their knowledge for professional needs. I am generally available within 3 days of your request and I move around the canton of Geneva using public transport (TPG). Travel costs are included in my rates. For a long-term follow-up, I can give you exercises to do between sessions and correct them at home. I speak and understand English, but my lessons will be mainly in French. I am ready to adapt my teaching according to your specific needs and to provide personalized support to help you progress in scientific subjects. Do not hesitate to contact me if you have additional questions or if you wish to schedule a lesson session. I will be happy to help you in your math learning.

Mouad
Support course in Python (For all levels, CPGE)
Passionate about programming, we offer Python support courses adapted to all levels, from beginner to advanced. These courses are aimed at students in preparatory classes for grandes écoles (CPGE) as well as anyone wishing to acquire solid programming skills. The lessons cover the essential foundations of Python with a clear and accessible teaching approach. Whether you are new to programming or want to deepen your knowledge, you will benefit from structured and progressive teaching. With a focus on concrete concepts and practical examples, these courses aim to strengthen your skills in a tangible way. You will be guided through the nuances of Python, gaining a deep understanding that will benefit you both in your studies and in your future career. Join us to explore the fundamentals of Python programming and progress to more advanced levels. Together, we will build a solid foundation and develop the skills needed to succeed in the dynamic world of computer programming.

Mathieu
Wordpress private lesson - From beginner to expert
With 7 years of experience as a developer in a Factory, I now develop Wordpress websites for large groups. In the training program, you will learn to: - Install, configure, and deploy WordPress sites - Develop custom Wordpress themes and plugins - Use powerful tools like ACF Pro, Gravity Forms, WPML, AIOS Security, WP rocket... - Create custom post types and tailor-made taxonomies - Develop pages using the right methods in HTML, CSS, Javascript & PHP - Administer and manage a site database - Contribute to the good natural referencing (SEO) of your site - Use WP-Cli to speed up the maintenance of your sites - Use Docker to containerize your local/prod projects and facilitate their management - Administer your WP sites the right way - And much more... For any questions, you can contact me by PM. See you soon, Matthew