Learn how to use and create a database with Access in a simple way using logic rather than memorization.
- creation of tables
- the different types of controls with their properties and their input masks
- choice lists
- the 1st and 2nd keys
- creation of relationships between tables
- referential integrity
- filtering and sorting
- creation of queries (selection, table addition, update, deletion, table addition, cross analysis)
- calculated fields
- different displays (creation mode, data mode to be encoded, personalized displays, adding to groups ...)
- creation of forms
- creation of reports
- external data (import and export)
- compaction
- linked source tables
- etc ...
Learn the basics of office automation necessary for office work, in a simple and logical way rather than based on memorization.
Program according to the student's wishes
Word / Libre Office texts:
Mail formatting
Alignment, fonts, paragraphs, tabs
Margins, orientation
Styles: creation of chapters and table of contents
Sections of a document
Footers and headers
...
Excel / LibreOffice calculations:
Shaping of cells
Sheet management
Preparation for printing with headers and footers
Basic functions
...
Powerpoint / Libre Office Presentation:
Creation of a slideshow with images, shape drawings, sounds, text animation, transitions between slides
Templates and themes
Pptx, ppsx and pdf formats
...
Outlook
Mail management with attachments, cc and bcc
Email search and ranking
Basic rules: automatic replies
Setting up a mailbox
Calendar and tasks
...
Learn to use Excel or LibreOffice calculations, in a simple way by resorting to logic rather than memorization. A la carte or an evolving program
- sheet management
- formatting
- automatic lists
- different number formats
- arithmetic formulas
- essential functions (min, max, sum, average, nb, if, sum.si, recherchev, date formulas, concatenate etc ...)
- different collages: values, formula, format, incl. transposition
- sort and filter
- different types of graphics
- layout and printing
- etc ...
Learn how to process photos, in a simple way using logic rather than memorization.
A la carte courses according to the students' requests. Or according to my program:
- getting started with the program
- resizing and resolution of photos
- different file formats
- discovery of the toolbox
- selections (magic wand, lasso etc ...)
- balancing and adjustment of colors, contrasts, brightness, saturation etc ...
- transformation into black and white
- work on layers
- use of masks
- different filters
- animated gifs
Learn how to create a successful website with the Wordpress program. This on the computer before learning to put it online.
Local Wordpress installation via a virtual server: wamp
Site administration
The dashboard
Different themes and designs
The identity of the site
Pages and articles
Text formatting
Multimedia content: images, sounds, videos, links ...
Contact forms
Wordpress extensions
Customizing a theme
etc ...
Reviews (1)
Excellente prestation. Grande disponibilité.
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 2014
- Phone number verified
- Linkedin connected