FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
from27.84USD/ h

Database with SQL and Access and other office tools

Translated by Google. Click to view original.
With extensive experience in creating databases for the management of different areas of activity. In addition, mastery of the integration of Access with other office automation tools.
The courses are dedicated to students and professionals.

Extra information

Translated by Google. Click to view original.
Laptop

Location

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?"

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4              
5              
6            Saturday at 6:00  Sunday at 6:00
7            Saturday at 7:00  Sunday at 7:00
8      Wednesday at 8:00  Thursday at 8:00    Saturday at 8:00  Sunday at 8:00
9      Wednesday at 9:00  Thursday at 9:00      
10      Wednesday at 10:00  Thursday at 10:00      
11        Thursday at 11:00      
12    Tuesday at 12:00          
13    Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
14    Tuesday at 14:00  Wednesday at 14:00    Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15    Tuesday at 15:00    Thursday at 15:00  Friday at 15:00  Saturday at 15:00  Sunday at 15:00
16          Friday at 16:00    
17    Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00  Friday at 17:00    
18    Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00      
19              
20              
21              
22              
23              
from $27.84Online 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.

Online reputation

  • Instructor since May 2021
  • Phone number verified
  • Google connected

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4              
5              
6            Saturday at 6:00  Sunday at 6:00
7            Saturday at 7:00  Sunday at 7:00
8      Wednesday at 8:00  Thursday at 8:00    Saturday at 8:00  Sunday at 8:00
9      Wednesday at 9:00  Thursday at 9:00      
10      Wednesday at 10:00  Thursday at 10:00      
11        Thursday at 11:00      
12    Tuesday at 12:00          
13    Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00  Saturday at 13:00  Sunday at 13:00
14    Tuesday at 14:00  Wednesday at 14:00    Friday at 14:00  Saturday at 14:00  Sunday at 14:00
15    Tuesday at 15:00    Thursday at 15:00  Friday at 15:00  Saturday at 15:00  Sunday at 15:00
16          Friday at 16:00    
17    Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00  Friday at 17:00    
18    Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00      
19              
20              
21              
22              
23              
from $27.84Online 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


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 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

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.

Yves
Access, Excel, VBA programming, Office automation and internet courses
Computer development professional offers courses on: - Ms Access, all versions - MS Excel, all versions, - Programming in VBA - Assistance in the design of management tools During the day or in the evening, exclusively remotely (Teams, Google Meet, or other..)

Jean Marc
Excel course Word ACCESS PowerPoint general IT
EXCEL POWER POINT WORD and ACCESS are inevitable software when working with a computer. I will introduce you to this software with exercises to do by yourself, exercises accompanied by courses appropriate to your requests.

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 ...

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.

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