Synaps | Courses Access Designing and creating a database

You want us to call you? Fill in the form and we will contact you when it best suits you.

The training Access : "Designing and creating a database", will regularly take place at our location Koloniënstraat Brussels in Dutch or French. The training Access : "Designing and creating a database" can also be organized by you or us in French, Dutch or English on request.

Get subsidized for this course Access Designing and creating a database

Additionally, this training can also be organised in a (blended-) e-learning environment.

Objectives

In this course, the participants will learn to understand and to use the basic notions of relational databases in Access.

Target Audience

This training is for present or future Access users (versions 2003, 2007, 2010 or 2013).

How to create a database with Microsoft Access

Discovering the basic notions of an Access Table (field, record, data type)

Data

Insert and modify data
Navigate in an Access Datasheet
Use the wizards to create a database

Tables

Use of the online templates to create a new database/table (2007 & 2010 & 2013)
How to create tables manually
How to use the new datatypes (attachment) (2007 & 2010 & 2013)
Importing data from SharePoint (2007 & 2010 & 2013)
Add, delete, move a field, select a data type
How to assign a default value, a condition, ... to a field
Define primary keys
Indexation of certain fields
How to link several tables

When/why to use several tables?

When and why to use several tables?
Define relationships between tables, to modify their characteristics, to delete relationships
Enforce referential integrity between tables: 1-1 relations, 1-N; update data
Insert and modify data