About this Course

This module enables candidates to understand some of the main concepts of databases and demonstrate the ability to use a database application. This includes creating and modifying tables, queries, forms and reports, and preparing outputs ready for distribution, as well as learning to relate tables and to retrieve and manipulate information from a database by using query and sort tools.

On completion of this module each candidate will be able to:

1. Understand what a database is and how it is organized and operated
2. Create a simple database and view the database content in various modes
3. Create a table, define and modify fields and their properties; enter and edit data in a Table
4. Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database
5. Understand what a form is and create a form to enter, modify and delete records and data in records

Course Outline :

• Start Access
• Recognize the Screen   Layout
• Use the Ribbon and Quick   Access Toolbar
• Use Help and the Office   Assistant
• Open an Existing Database
• Close a Table and Database
• Exit Access
  

• Use the Mouse and   Keyboard to Move
• Create a New Database   & Table
• Format and Edit Field   Properties
• Define a Primary Key
• Create Index Fields
• Enter Data in a Table
• Create Validation Rules and Text
• Print All and Parts of a Table

• Understand and Apply Relationships
• Create Various Types of Relationship
• Delete Relationships
• Apply Referential Integrity
• Understand the Implications of Referential Integrity

• Change Column Width
• Find Text
• Edit and Delete Data
• Use Undo
• Add & Delete Records
• Use Wildcards to Search
• Edit and Enter Data using Shortcuts

• Sort Records, Use Filters

• Create, Edit and Delete a Query
• Use Sort in a Query
• Print Query Results
• Query Related Tables
• Use Value Ranges in   Queries
• Use a Query to Find Non-Matches
• Use AND & OR Queries

• Create Quick Forms
• Design and Create a New   Form
• Format a Form
• Edit and Delete a Form
• Edit and Browse Data within a Form
• Print from a Form

• Create a Quick Report
• Modify and Delete Reports
• Preview and Print Report
• Sort Data in a Report
• Group Data in Reports
• Perform Calculations in Reports

For beginner and professional who in need of database management in order to create forms and more

Need to possess the knowledge of Basic PC

Successful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore. This is a joint certification between WDA and ICDL Singapore. Student must take a 45 min online assessment at the end of the course.

ICDL - Perform Advanced Database Functions (Advanced Access 2010)

Rate this course:

Log in to submit

Comments