Total Time: 5 hour(s)

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

Ojectives: 
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: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.