Realdolmen Education


MS Access Module 1 - Designing and Creating Databases

Deze cursus is momenteel niet ingepland op de open kalender, maar kan op aanvraag georganiseerd worden.

Cursus aanvragen

Aantal dagen

1 day(s)


The course is intended for users who wish to use MS Access to create databases with the intention of recording, treating, processing and retrieving data.


Knowledge of databases is not required. Participants are however assumed to have a basic knowledge of Windows. A good knowledge of Excel is a great advantage.


At the end of this course, students will: understand Access terminology; have insight in the possibilities of creating MS Access databases; be able to devise and set up a relational database.


Instructor-led classroom training with hands-on exercises and intensive interaction between instructor and students. Each student disposes of a workstation.


The scope of this is course is limited to creating and manipulating Access databases, tables and relationships.


  • Introduction
    • What is Microsoft Access?
    • MS Access terminology
    • Starting and closing MS Access
    • The MS Access window
    • Using MS Access Help
  • Databases
    • What is a (relational) database?
    • Types of relations
    • Steps to take in creating databases
    • Using templates
  • Tables
    • Creating tables
      • Methods
      • Fields (field name, data type, field properties)
      • Primary keys
    • Defining relations between tables
    • Formatting a table
    • Importing and exporting data
    • Using tables
      • Entering, modifying and deleting data
      • Handling columns
      • Finding and replacing data
      • Sorting and filtering data
    • Modifying the structure
    • Table properties
    • Formulas in tables
    • Analyzing a table