Cours MS Access 2010 and 2007 Advanced English
Imprimer RetourObjectif
Access 2010 and 2007 Advanced is an advanced course that gives you a complete training on Microsoft Access 2010 and 2007 and teaches you how to develop Access applications in a more efficient way. This course lasts two days and allows you to perfectly master the fundamental and complementary tools of Access 2010 and 2007 databases.
Pré-requis
- Good knowledge of the Windows environment
- Knowledge of databases
- Having followed the course Fundamentals of MS Access 2010 and 2007 or having equivalent knowledge
Contenu
- Reminders on basic concepts of Access 2010 and 2007
- Improving the structure of tables and databases
- Database modeling
- Multi-list and calculated fields
- Performance analysis of the database
- Dependent objects
- Advanced queries
- Introduction to the SQL language
- Create queries for pivot tables and pivot charts
- Create multi-join queries
- Create advanced queries using the expression builder
- Creating advanced forms
- Creating a navigation form
- Using controls and ActiveX controls (calendar)
- Inserting sub-forms
- Inserting calculated fields
- Creating links between forms and customized queries
- Using functions from the expression builder (ex: RechDom())
- Creating advanced reports
- Including a chart in a report
- Selections and groups
- Headers & Footers
- Simplifying tasks with Macros and VBA
- Creating a macro
- Converting a macro in VBA
- Initiation to VBA
- Trigger generator
- Database starting options
- Security
- Integration of data with Outlook, SharePoint or InfoPath
Langue du cours
EN
Support de cours
- Training support in supplement
Durée
2 jour(s)
Nos cours collectifs
Disponibilité sur demande
Pour toute problématique d'accès ou de situation de handicap merci de contacter nos équipes.