ECDL/ICDL 4 Module 5: Database - Access 2003 Queries and Reports

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

---

Overview/Description
To outline the processes for creating and modifying queries and reports. 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)
2.6

Lesson Objectives

ECDL/ICDL 4 Module 5: Database - Access 2003 Queries and Reports

select the options that allow you to create and run a select query.

select the options that allow you to refine a query.

select the options that allow you to perform calculations on a query.

create and modify a query and print query results.

select the appropriate methods to generate a specific report.

add controls to a report.

select the methods to organize data in a report.

create a report and organize its data.

Course Number:
210721_eng