Private lessons
in Casablanca



Trusted teacher
from26.72USD/ h
Database avec SQL et Access et autres outils bureautiques
Doté d'une longue expérience dans la création des bases de données pour la gestion de différents domaines d'activités. De plus, la maîtrise de l'intégration d'Access avec les autres outils de la bureautique.
Les cours sont dédiés aux étudiants et aux professionnels.
Les cours sont dédiés aux étudiants et aux professionnels.
Extra information
LaptopLocation
Online via webcam
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 90 minutes |
The class is taught in: | English, French, Arabic |
About Me
Hi, I'm M'Amine, I joined apprentus in order to share my experiences and knowledge with people who want to improve their skills in languages (English, French and Arabic) and also informatics (Data base,....). At anytime and anywhere.If you want to improve your skills in English, to discuss, to exchange flowently with your friends, at work, don't hesitate to join me.
A various package is provided to help you reach your purposes. Effeicient interaction is guaranteed ;)@.
Ask a question
Send a message explaining your needs and M'Amine 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 -04: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 $26.72Online via webcam
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 May 2021
- Phone number verified
- Facebook connected
- Google connected
Availability of a typical week
(GMT -04: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 $26.72Online via webcam
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 Casablanca
Similar classes
Prachir
Microsoft Excel and Access skills for Beginners/Advanced
Microsoft Excel and Access are great tools for maintaining MIS and perform automated functions. Being an expert I would like to help learn the basics as well as perform advanced operations.
For Beginners,
In each class I would attempt to teach excel functions.
For Advanced,
In each class I would attempt to solve their daily problems or better ways to manage and represent data including use of Macros.
Jean Marc
Cours Excel Word ACCESS PowerPoint informatique générale
EXCEL POWER POINT WORD et ACCESS sont des logiciels inévitables lorsque l'on travail avec un ordinateur je vous ferai découvrir ces logiciels avec des exercices à faire par vous même ,exercices accompagnés de cours appropriés à vos demandes
Jamal
Computer and office trainer word excel access and PowerPoint
Office automation plays an essential role in the management of your business or at home this court list is for you yourself to be able to practice computer and office tools like professionals from A to Z ...
Tarik
Excel pour tous les niveau, avec des méthodes simple et faciles
Quelque soit votre niveau, débutant ou avec des notions, étudiant ou salarié.
Excel n'est pas destiné aux programmeurs ou les mathématiciens, plutôt un MUST LEARN outil pour toute personne qui se prépare pour intégrer le monde professionnel ou qui y est déjà.
Il suffit juste la volonté et la rigueur.
Je mets a votre disposition des méthodes simple pour apprendre Excel et l'utiliser au quotidien.
Structure Excel
Formule et fonctions.
Tableau croisé dynamique
Connexion avec MS ACCESS
la mise en forme
Les graph(Dynamique et static)
les tableau de board.
Macro VBA
Anas
Master Microsoft Access software (Beginner / Advanced)
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 diagrams: relay tables, star diagrams, 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
Aish
Math,Computer science,Java, Sql, Sql server,Microsoft Excel,Microsoft Access ,R programming Tutoring
I have been doing online computer tutoring on topics including database programming such as Oracle Sql,SQL server,MS Access,MS Excel ,jav and HTML
I have been volunteering as a computer tutor for couple of years in Schenectady county public library,New York
Previously was tutoring as GED math tutor for more than 50 hours tutoring in Literary Newyork Greater capital region,New York
I hold bachelors Degree in Information Technology
Yves
Business Consultant - Your expert for your Excel files
You are a financial director or boss of your SME, a manager in a large company, or you want additional training to perfect your knowledge.
If you spend more than 4 hours a day on your Excel files, if you feel overwhelmed by your next budget, if your reports lack punch, nothing is lost!
Hello, My name is Yves. I have more than 25 years of business experience (of all sizes) and have worked in multiple functions (sales, purchasing, planning, supply chain, administration). Today I choose to help business professionals by accompanying them in their project and training them to become more efficient in their tasks. Excel is a fantastic and underutilized tool.
I teach Excel at all levels, including VBA programming. I work on PC, but also on Mac, both FR and US version of Excel.