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 :

• Opening and Closing a Database
• Navigating in the Database

Editing

• Change Column Width
• Find Text
• Edit & Delete Data
• Add Records, Delete & Edit
• Use Wildcards to Search
• Edit & Enter Data Using Shortcuts

Section 6 : Table Relationships

• Understand & Apply Relationships
• Create Various Types of Relationship
• Defining a Primary Key
• Relationship Concepts & Types
• Applying Relationships
• Referential Integrity
• Updating / Deleting Records

Section 7 : Forms

• Overview
• Quick Forms & the Form Wizard
• Form Design (Create / Delete)
• Editing a Form Design
• Using the Form (Sorting / Editing)
• Filtering & Printing From a Form
  

Section 8 : Reports

• Using Quick Report
• Creating & Deleting a Report
• Modifying a Report
• Creating Calculations in Reports
• Printing From a Report

Section 9 : Queries

• Finding Specific Text
• Using Wildcards
• Querying a Table
• The Select Query
• Editing / Deleting Queries
• Using Value Ranges
• Querying Related Tables
• AND & OR Queries
• Non-Matches
• Sorting Query Results
• Saving & Printing Queries
  

Section 10 : Exporting

• Exporting Data

Course Duration : 17 Hours

Target Audience

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

Pre-requisites

Need to possess the knowledge of Basic PC

Certification

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.

Course Pathway

ICDL - Perform Advanced Database Functions (Advanced Access 2013)

Rate this course:

Log in to submit

Comments