Access basis

Prerequisites:

You have no or very little experience with access.
We assume, however, that you have you can work smoothly with one or more office applications.

Description:

During this training you learn to create a simple relational database. You learn the different components of access such as tables, reports, queries and forms.


Content:

Introduction:

  • Database parts
  • Access screen
  • The navigation window
  • The access ribbon
  • Use "Help"


Working with a database:

  • Opening and saving of database
  • Viewing database objects in different reproductions
  • Data input
  • Quick search
  • Quick print
     

Tables:

  • Create a table
  • Modifications in tablestructure
  • Defining fieldcharacteristics
  • Adapt table structure
  • Using Excel filterpossibilities

Relational databases:

  • Linking of tables
  • Working with linked tables

Queries

  • Sort and select
  • Creating and modifying selectionquery
  • Calculations in queries
  • Topqueries
  • Actionqueries
  • Queries on multiple tables

Forms:

  • Creating a form
  • Alterations in a form
  • Layout view
  • Data from different applications
  • Insert new elements
  • Forms of linked tables

Reports:

  • Create reports with and without wizard
  • Alterations in a report
  • Generate addresslabels
  • Reports with multiple columns
  • Group and sort

Practical information

Date:

3 days: 8 Nov., 15 Nov. and 22 Nov. 2019

Hours:

from 9h30 till 17h00


Location: 

Stadscampus - Building P - Room P.201

Teacher:

Bit by Bit

Language of the course:

English

Docop-points:

This course counts for 2,1 docop-points.

Registration:

via the Sisa Selfservice (log in with your student account)