Hogeschool Gent
Geraard de Duivelstraat 5 - 9000 Gent
Tel: 09 243 33 33 - E-mail: info@hogent.be
Website: www.hogent.be
ICT: Database management (English taught)28501/3977/1718/1/16
Study guide

ICT: Database management (English taught)

28501/3977/1718/1/16
Academic year 2017-18
Is found in:
  • International Curriculum, programme stage 3
This is a single course unit.
Study load: 3 credits
Weight: 3,00
Total study time: 75,00 hours
Possible deadlines for learning account: 01.12.2017 () or 15.03.2018 ()

Organisation of education

Teaching Activities, Learning Activities, Assessment Activities
Self-study51,00 hours
Seminar24,00 hours
This course unit is marked out of 20 (rounded to an integer).
Re-sit exam: is possible.
It is not possible to enrol in this course unit under
  • exam contract (to obtain a credit).
  • exam contract (to obtain a degree).
Special admission is required to enrol in this course unit under credit contract.
Co-ordinator: Mestdagh Barbara
Other teaching staff: De Poorter Hilde
Language course: No
Languages: English
Scheduled for: Semester 1 or Semester 2

Objectives

This course wants to make students familiar with databases. By means of a database program (part of an office-package) the student will be able to produce and use a database professionally.

Contents

  • Basic terminology concerning database programs
  • Creating tables, making relations, inputing data (importing and exporting)
  • Designing queries: selection queries (parameter and join-queries included) and action queries
  • Working with forms and reports
  • Introduction to macros

Order of enrolment

There are no prerequisites for this course.

Prerequisites

Being able to use the prevailing possibilities of an operating system.

Final objectives

1. Having a basic knowledge of relational databases.

Indicators:

  • Knows the relevant terms and definitions of relational databases, such as record, primary key, referential integrity, join query, SQL, reports.
  • Can design a relational database with one-to-many relations.

2. Working smoothly and efficiently with Microsoft Access.

Indicators:

  • Can make tables and make relations between these tables.
  • Can import and export data (e.g. from and to .csv and .xlsx).
  • Knows the advantages and disadvantages of the use of Microsoft Access compared to Microsoft Excel.
  • Uses the Help function when looking for information on less used characteristics and functions.
  • Can make queries using the design grid. Simple selection queries using and, or, Like, Is Null, but also parameter queries, group by queries and inner/outer joins.
  • Can make changes to many records at the same time using action queries.
  • Can design forms and adapt the design of existing forms. Can add all kinds of controls (selection lists).
  • Can make master/detail forms.
  • Knows how to make reports, even complex reports such as group reports showing data based on various tables.
  • Knows some of the functions that are used a lot and can use them in queries, forms and reports.
  • Can make a simple macro and attach it to a button.
  • Can do assignments within given deadlines in Microsoft Access.

Organisation of education

Through the question-and-answer method, guided and individual exercises on computer students get to know the software.
Students will be coached by the lecturer and help you on with the exercise prepared before.

Study guidance

Students will be coached during class hours All exercises are available on Chamilo so studentscan do them (again) on their own; there are multiple choice exercises with self correction and feedback.

Evaluation

First exam opportunity:
- Non-period bound evaluation: /
- Period bound evaluation: 100% exam on computer
Second exam opportunity:
- 100% exam on computer