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.