Search form

 

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:

  1. The learner watches a video
  2. The learner carries out the exercise directly within the application
  3. MEDIAplus instantaneously checks the answer
  4. 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