Access 2013 - Database Design

Aim
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.
Approach
ENI offers you a unique educational interactivity with practical exercises directly within the applications and with an immediate result analysis, that respects the 4 training steps:
- The learner watches a video
- The learner carries out the exercise directly within the application
- MEDIAplus instantaneously checks the answer
- MEDIAplus provides the answer
Target Audience and Prerequisites
Any user who wishes to discover or deepen their knowledge of Access’ features. No prior knowledge of Access is necessary. However, some use of the software may make it possible to progress faster.
Course content
Access 2013 – Database
This module offers interactive training consisting of 7 training videos, 7 exercises and 2 additional resources.
- The database and its objects
Access 2013 – Records
This module offers interactive training consisting of 12 training videos and 12 exercises. Records
- Sorting and filtering
- Tables: design, structure
- Tables: management
Access 2010 – Tables
This module offers interactive training consisting of 11 training videos and 11 exercises.
- Tables: design, structure
- Tables: management
Access 2013 – Forms, reports
This module offers interactive training consisting of 37 training videos and 37 exercises.
- Forms
- Records
- Printing
- Creating controls
- Managing controls
Access 2013 – Queries and analysis of data
This module offers interactive training consisting of 22 training videos and 22 exercises.
- Basic Select queries
- Advanced Select queries
- Queries performing various tasks
- Analysing data
Complementary material
- Access 2013 – Reference book