About this Course

ICDL Advanced Database is a high level certification program which enables candidates gets more from the database application by giving them the skills to use the many advanced tools available in database applications to better manage and organize structured information.

1. Individuals with ICDL Advanced Database certified skills can: 
2. Produce better reports with deeper data analysis
3. Produce higher quality management information 
4. Use advanced features in table, query, form and report design 
5. Use macros within the database application 
6. Import, export and link data

Course Outline :

Section 1 : Fundamentals

• Understand Database Concepts
• Understand SQL
• Create a Database
• Design a Table

Section 2 : Field Properties

• Create Lookup Fields
• Set and Modify Default Values
• Set Mandatory Fields
• Create Validation Rules and Text

Section 3 : Queries

• Create Sum and Count Queries
• Use Group By in Queries
• Show Average, Maximum and Minimum Values
• Create Calculated Fields

Section 4 : Relationships

• Apply Primary Keys
• Apply and Modify Different
• Types of Relationship
• Query Related Tables
• Understand Joins
• Apply Referential Integrity
• Update and Delete Related Records
• Work with Subdatasheets

Section 5 : Forms

• Create Main Forms and Sub Forms
• Link Forms
• Create Forms from Multiple Tables

Section 6 : Form Controls

• Calculated Fields on Forms
• Command Buttons
• Combo Boxes
• List Boxes and Check Boxes
• Option Groups
• Add Data Fields to Headers and Footers

Section 7 : Reports

• Create Grouped Reports
• Create Sub reports
• Insert Page Breaks
• Create Calculated Fields in Reports
• Calculate Percentages
• Insert Data Fields in Headers and Footers
• Print Reports

Section 8 : Import and Link Data

• Import Data from Spreadsheets
• Import Data from Text Files
• Import Data from Tables
• Link a Database to External Data

Section 9 : Action Queries

• Create Append Queries
• Create Delete Queries
• Make a Table from a Query
• Create an Update Query

Section 10 : Query Wizards

• Create a Crosstab Query
• Create a Find Duplicates Query
• Create a Find Unmatched Query

Section 11 : Macros

• Understand Macro Actions
• Create a Macro
• Attach a Macro to a Control or Object
• Create Macros from Controls
• Create Command Button Macros

Course Duration : 24 Hours

Target Audience

For professionals who in need of Advanced database management knowledge in order to create forms and more

Pre-requisites

Need to possess basic knowledge of Access 2007

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 60 min online assessment at the end of the course.

Course Pathway

Any other MS Office 2007 courses