ECDL/ICDL 4 Module 5: Database - Basic Access 2003 Tables

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
To outline the processes for creating and modifying tables. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details.

Target Audience
End users wanting to attain competency in using a database application; end users wanting to become familiar with database concepts; end users wanting to attain competency in using Microsoft Access 2003; end users wanting to attain an ECDL or ICDL certification or equivalent; staff of businesses and public bodies needing to attain certification in computer proficiency; university or other students needing to attain a basic IT qualification; staff of public bodies or organizations seeking to reskill themselves for the technology-based workplace; staff at universities, schools, or other training centers teaching computer literacy skills

Prerequisites
Familiarity with basic IT concepts; familiarity with the Windows XP operating system

Expected Duration (hours)
3.2

Lesson Objectives

ECDL/ICDL 4 Module 5: Database - Basic Access 2003 Tables

add a table to an Access database.

add a table using the Design and Datasheet views.

modify fields to define a table's features.

apply indexing to fields.

create and modify a specific table in Access 2003.

identify relationships when planning a database.

identify the steps involved in creating the various types of relationships between tables.

manage the data in records.

define and edit relationships between tables.

create a database containing relational tables in response to a business requirement.

Course Number:
210582_eng