International Computer Driving Licence Version 4.0 Series: Database
Product Code: ICD405 Time: 5.0 hour(s) CEUs: Available

Summary:

This course shows users how to work with a database application to create a database; create, use, and change a data entry form; retrieve information; and create reports. This course describes how to meet European Computer Driving Licence (ECDL) objectives using Microsoft Access on a personal computer that uses a Windows operating system. The ECDL/ICDL test can be taken with any database application, and although this course demonstrates a specific application, the tasks it teaches can be applied to other applications as well.

Objectives:

After completing this course, students will be able to:
  • Open and close a database
  • Revise and save records
  • Use application help
  • Create a database
  • Update a database
  • Create, use, and revise a data entry form
  • Create and refine a query
  • Select and sort data
  • Create and edit a report

Topics:

  • Database concepts
  • Opening and closing a database application
  • Adjusting settings
  • Defining table fields
  • Finalizing tables
  • Creating table relationships
  • Adding and revising records
  • Working with forms
  • Searching records
  • Filtering and sorting records
  • Queries
  • Advanced query functions
  • Creating reports
  • Working with reports
  • Printing information

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 98, NT, 2000, or XP. Internet Explorer 5.0 or higher required. (5.5 or higher for MindLeaders Central) Minimum Connection Speed: 28.8k. Sound card, with speaker or headphones is recommended, but not required to play the courses. Macromedia Flash Player 7.0 (Note: We do not recommend or support installation of the Yahoo toolbar.) JavaScript must be enabled. Netscape and AOL browsers not supported.


Copyright © 2005 MindLeaders. All rights reserved.