Course goals
To discover Access and master its features. From the essential to the advanced commands, this training programme, organised by topic, will make it possible for you to understand the structure and set up a database. You will be able to manage your tables and records, create and customize your queries, forms and reports.
Prerequisites
Target audience:
Any user who wishes to discover or deepen their knowledge of Access’ features.
Level required:
No prior knowledge of Access is necessary. However, some use of the software may make it possible to progress faster.
Course content
MEDIAplus eLearning
This module offers interactive training consisting of 7 training videos, 7 exercises and 2 additional resources.
Access 2010 – Databases
• The database and its objects
MEDIAplus eLearning
This module offers interactive training consisting of 12 training videos and 12 exercises.
Access 2010 – Records
• Records
• Sorting and filtering
• Integrating with other applications
MEDIAplus eLearning
This module offers interactive training consisting of 11 training videos and 11 exercises.
Access 2010 – Tables
• Tables: design, structure
• Tables: management
MEDIAplus eLearning
This module offers interactive training consisting of 37 training videos and 37 exercises.
Access 2010 – Forms, reports
• Forms
• Reports
• Printing
• Creating controls
• Managing controls
MEDIAplus eLearning
This module offers interactive training consisting of 22 training videos and 22 exercises.
Access 2010 – Queries and analysis of data
• Basic Select queries
• Advanced Select queries
• Queries performing various tasks
• Analysing data
Additional book
This module includes digital course material.
Access 2010 – Reference book