skip to navigation skip to content
Self-taught course

Provided by: University Information Services


Booking

This course is self taught (Materials may be loaned out).

Bookings cannot be made on this course (Course is not taking bookings).



Booking / availability

ECDL 4.5 Module 5 - Databases (Access 2007) (Win) (workbook)
BeginnersLoan


Description

This publication is intended for people who wish to prepare for Module 5 - Database of the ECDL/ICDL Syllabus (Version 4.5) using Microsoft Access 2007. In Module 5 the candidate will learn about the main concepts of databases and be able to demonstrate the ability to use a database on a computer. The candidate will be able to create and modify tables, queries, forms and reports, and prepare outputs ready for distribution. The candidate will be able to relate tables and retrieve and manipulate database information using the query and sort tools available in the application.

Prerequisites

This course is intended for people who wish to prepare for Module 5 - Database of the ECDL/ICDL Syllabus (Version 4.5) using Microsoft Access 2007. The course assumes no prior knowledge of Microsoft Access 2007. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system as the candidate will be required to start applications, work with and copy files, and locate file folders.

Topics covered
  • Understand how Access is used and how to navigate around it
  • Design a database with lookup tables
  • Design a relational database project
  • Create a database structure using Access 2007
  • Create a relational database file with multiple tables
  • Modify the structure of an existing table
  • Set table relationships and join tables together
  • Add records to a new table
  • Use various data validation features in Access to protect data
  • Work with the records in a database table
  • Format the data in a table
  • Sort and filter records in a table
  • Create simple and effective queries
  • Perform more advanced queries using a variety of querying techniques
  • Create queries based on one or more tables
  • Create meaningful reports from tables
  • Create and use a variety of forms
Format

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

Duration

27 hours.

Themes

Booking / availability

Override user: