Anas
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
from35.64USD/ 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.
...
>>> What is Excel? Microsoft Excel is a spreadsheet that allows you to do calculations, analyze data with formulas, tables and graphs. Excel versions 2010 - 2013 -2016. >>> 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.
_*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

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 -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4            Saturday at 4:00  Sunday at 4:00
5            Saturday at 5:00  Sunday at 5:00
6            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  Monday at 8:00      Thursday at 8:00  Friday at 8:00  Saturday at 8:00  Sunday at 8:00
9            Saturday at 9:00  Sunday at 9:00
10              Sunday at 10:00
11              Sunday at 11:00
12              
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      
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  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00    Saturday at 18:00  Sunday at 18:00
19              
20              
21              
22              
23              
from $35.64At teacher's location
from $35.64Online via webcam
from $47.89At 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
  • 3 repeat students
  • Phone number verified
  • Google connected

Availability of a typical week

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

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.

Oussama
Mastering Web Development: From Fundamentals to Advanced Techniques
Hello everyone ! I'm oussama, a web developer and certified Python instructor with 1 year experience as a fullstack developer. I am passionate about programming and love teaching students of all skill levels how to create professional websites. I've helped many students develop their programming skills, from beginners to advanced levels, and I'd love to help even more people achieve their web development goals. With a solid background in programming and development, I am able to provide my students with theoretical and practical training in algorithms and data structures, as well as in website development languages such as HTML, CSS, JavaScript , React JS, Bootstrap and others. My classes are designed to meet the individual needs of each student and are suitable for different learning styles. Whether you are just starting out or looking to improve your developing skills, my classes can help you achieve your career goals. Do not hesitate to contact me for more information on my web development courses. I look forward to helping you become a competent web developer and succeed in this exciting field!

Brahim
Introduction to NoSQL DataBase MongoDB by Pratique
Do 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.

Ymama
Electronics & Arduino basics using TinkerCAD for kids and teenagers
Using STEAM principles to teach kids and teenagers the most important subjects and skills these days, they will learn how to connect and program Arduino circuits using virtual labs, estially we are going to use TinkerCAD, it's preferred that the student has simple knowledge or idea about the programming principle in general but not necessarily.

Ousmane
Computer science, office automation, algorithms and programming
Computer and office courses are learning programs designed to help individuals acquire essential skills in information technology and office software management. These courses are offered in a variety of educational environments, ranging from elementary and secondary schools to colleges and universities, career training centers and online programs. My commitment to this goal extends to the constant search for varied educational resources, participation in specialized training and the creation of stimulating learning environments, in order to ensure a complete and enriching transmission of IT knowledge to my students. students.

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.

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.

Mo
Computer science at all levels (Algorithmics, Theoretical computer science, Programming, Introduction to computer science)
Computer science is a skill that is always in demand. From computer architecture to artificial intelligence, in this field, thousands of computer scientists are recruited every year all over the world. As a computer engineer with 8 years of experience including 3 years in a very large international company, I give theoretical and practical computer science courses at all levels. I teach algorithms, operating systems, some computer software and programming. I also give lessons for pupils and students (college, high school, university, other). For people who are passionate about IT, even if they have no knowledge in the field, I can help them get off to a solid start.

Florian
Logic, formal languages, and automata theory for computer science
Experienced and patient teacher of logic for computer science. I have taught logic, formal languages and automata theory to undergraduates for six years. My tutoring is adapted to the student's level and goals. Whether you need to learn logic for your studies, or you would simply like to know more about the subject, I will be more than happy to help you improve your understanding and skills. Logic The sciences presuppose a certain standard of rationality. An ability to distinguish between correct reasoning and claims that do not follow from the assumptions. In this class we study the basic principles of logic and apply mathematical techniques to the study thereof. Topics include: Propositional and Predicate Logic Syntax and semantics Semantic Tableaux Natural deduction Correctness and soundness Completeness Formal languages and automata A formal language is an abstraction of general characteristics of programming languages. Such a languages consists of a set of symbols together with some rules to determine whether a string made up out of those symbols is a member of the language. Topics include: Regular languages, context-free languages Finite automata, pushdown automata, Turing machines Regular expressions Regular grammar, context-sensitive grammar Pumping lemmas for regular and context-free languages

Yasmina
Personalized Computer Science, Scratch, Python and ICT Courses for Middle and High School Students
Hello, I am a computer engineer, passionate about sharing knowledge. I offer private lessons intended to help students succeed in their academic career, from middle school (7th year) to the baccalaureate. My offer includes Scratch and Python programming courses, as well as courses on Information and Communication Technologies (ICT). My packages are flexible and negotiable to accommodate each student's individual needs. I am based in Hammam Chatt, and you can contact me for further information. Welcome to everyone who wants to develop their computer skills, explore programming and excel in their studies

Mouad
Support course in Python (For all levels, CPGE)
As engineering students who are passionate about programming, we offer Python support courses suitable for all levels, from beginner to advanced. These courses are designed for students in preparatory classes for Grandes Ecoles (CPGE) as well as for anyone interested in acquiring solid programming skills. The lessons cover the essential foundations of Python with a clear and accessible teaching approach. Whether you are discovering programming for the first time or looking to deepen your knowledge, you will benefit from structured and progressive teaching. With a focus on real-world concepts and practical examples, these courses aim to strengthen your skills in a tangible way. As an engineering apprentice, you will be guided through the nuances of Python, gaining a deep understanding that will be valuable to you both in your studies and in your future career. Join us to explore the foundations of Python programming and progress to more advanced levels. Together we will build a strong foundation and develop the skills needed to excel in the dynamic world of computer programming.

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.

Salomé
University graduate gives computer/excel/word/typing lessons
A 32-year-old university graduate, management engineer, with 8 years of professional experience offers her teaching services. Course of (1H) - 1H30 or 2H depending on the subject/level/location Educational and organized teacher with good revision and organization techniques Microsoft Office - excel/word/powerpoint - mail - typing - ... Pedagogue and patient 97% success rate with regular monitoring I come to your home and also teach online Group lessons also possible, with reduced rates from 3! Feel free to contact me for more information ! See you soon