· Understand what a database is and how it is organized and operated.
· Create a simple database and view the database content in various modes.
· Create a table, define and modify fields and their properties; enter and edit data in a table.
· Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database.
· Understand what a form is and create a form to enter, modify and delete records and data in records.
· Create routine reports and prepare outputs ready for distribution.
Description
This course requires the candidate to understand the basic concepts of databases and demonstrate the ability to use a database on a personal computer. The module is divided into two sections; the first section tests the candidate's ability to design and plan a simple database using a standard database package; the second section requires the candidate to demonstrate that he or she can retrieve information from an existing database by using the query, select and sort tools available in the database. The candidate shall also be able to create and modify reports.
Audience :
This course is designed for trainees who would like to get their first steps in database world.
Topics :
Using the Application
o Database Concepts
o First Steps with Databases
o Adjust Settings
Tables
o Main Operations
o Define Keys
o Table Design/Layout
o Table Relationships
Retrieve Information
o Main Operations
o Queries
o Sort Records
Forms
o Create Save & Open Forms
o Use Forms to Manipulate Data
o Navigate Through a Form
o Headers and Footers in a Form
o Delete a Form
Reports
o Create and Save a Report
o Alter the Position of Fields in a Report
o Group Information in a Report
o Calculate Statistics for Groups in a Report
o Add Text to a Report Header or Footer
o Delete a Report
o Save and Close a Report
Prepare Outputs
o Prepare to Print
o Print Options
Data Export
o Export a table, query output
Recommended Knowledge :
Basic Knowledge Using Microsoft Windows any version
Recommended Course(s) :
Category :
Training Materials :
Approved ICDL Courseware
Labs :
This course includes several labs to ensure you will gain the targeted skills and experience.
Credential :
This course prepares the attendees for the ICDL V5 Module 5 exam.
