Trusted teacher
This teacher has a fast response time and rate, demonstrating a high quality of service to their students.
Since October 2019
Instructor since October 2019
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
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
_*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
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
- 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.
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.
Reviews
4.8
1st lesson is backed
by our Good-fit Instructor Guarantee
by our Good-fit Instructor Guarantee