Course

A03

Basics and setup of the data structure with Microsoft Access («A03»)

In this two-day Microsoft Access course, you will learn the basics of setting up and realising Access databases using illustrative examples.
Vendor code

A03

Duration 2 days
Price 1'300.–
Course documents Digital Digicomp courseware

Course facts

  • Designing relational databases in Access 2016
  • Realising relational databases efficiently in Access 2016
1 The relational database model
  • Definition and structure
  • Normal forms
  • Database modelling
2 Tables
  • Creating tables
  • Importing/linking tables
  • Customising tables
3 Table links
  • Defining links
  • Defining relationships
4 What else you should know
  • Migrating data
  • Accessing database servers (MySQL, MS SQL Server, etc.)
  • Publishing data

Component of the following courses

This course is for PowerUsers and/or developers who want to model and build databases independently.

A good basic knowledge of Windows and Office is a prerequisite for this course.

This course is also suitable for users of Access 2013 and 2010.

Download

Questions

Choose your date

Further courses

Lernen Sie Ihre Trainer kennen