ICDL Module 5: ES WSQ - Perform Database Functions (Microsoft Access 2007)

  

About this Course

The course provides the learners the basic concepts of databases and to demonstrate the ability to use a database on a personal computer. 

The module is divided in two sections; the first section, to design and plan a simple database using a standard database package; the second section requires the learners to demonstrate that he or she can retrieve information from an existing database by using the query, select and sort tools available in the data-base. The learners shall also be able to create and modify reports.

COURSE OUTLINE

Module 1.Exploring Access

Module 2.Creating Tables

Module 3.Setting Field Properties

Module 4.Working with Tables

Module 5.Editing Tables

Module 6.Finding and Filtering Data

Module 7.Using Simple Queries

Module 8.Modifying Query Results

Module 9.Using Operators in Queries

Module 10.Creating Relationships

Module 11.Creating Basic Forms

Module 12.Using Design View

Module 13.Creating Basic Reports

Module 14.Using Advanced Report Design

PRE-REQUISITE

An understanding of Windows / MS Access 2003 will be an added advantage.

Rate this course:

Comments

Course Rating

  • /5 from users

Course Enquiry

Course Info

Other Similar Courses Provided By COMAT TRAINING SERVICES PTE LTD