Cours MS Access 2010 - Advanced
Objectif
This advanced course for users provides a good training of complementary and indispensable tools of Microsoft Access 2010 to develop Microsoft Access applications with more competence and efficiency when using à database.
Pré-requis
- Good knowledge of Windows environment
- Knowledge of databases
- Access Introduction or equivalent knowledge
Contenu
- Improvement and automation using Microsoft Access 2010
- Refresh on basic concept
- Improve structure of database and tables
- Database creation – concept
- Multi list and calculated fields
- Analyze the Performance of a Database
- Determine Object Dependency
- Write advanced queries
- Introduction to SQL language
- Create a PivotTable and a PivotChart
- Create join queries
- Create queries with Expression Builder
- Create advanced forms
- Create Switchboard
- Use Controls and ActiveX Controls (Calendars)
- Insert Sub FormInsert Calculated Field and custom queries
- Use function from Expression Builder (ex : Dlookup())
- Create advanced reports
- Include chart into the report
- Sections and Groups
- Header and footer
- Simplifying Tasks with Macros and VBA
- Create a Macro
- Convert Macro to VBA
- VBA initiation
- Triggers
- Database start options
- Security
- Data integration with Outlook, SharePoint or InfoPath
Langue du cours
EN
15.- CHF
Durée
2 jour(s)
Prix
1950.- CHF
Nos cours collectifs
Aucune session programmée
