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.
Individuals with ICDL Advanced Database certified skills can:
- Produce better reports with deeper data analysis
- Produce higher quality management information
- Use advanced features in table, query, form and report design
- Use macros within the database application
- Import, export and link data
Course Outline :
Section 1 : Fundamentals- Understand Database Concepts
- Understand SQL
- Create a Database
- Design a Table
- Create Lookup Fields
- Set and Modify Default Values
- Set Mandatory Fields
- Create Validation Rules and Text
- Create Sum and Count Queries
- Use Group By in Queries
- Show Average, Maximum and Minimum Values
- Create Calculated Fields
- 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
- Create Main Forms and Sub Forms
- Link Forms
- Create Forms from Multiple Tables
- Create the following controls:
- Calculated Fields on Forms
- Command Buttons
- Combo Boxes
- List Boxes and Check Boxes
- Option Groups
- Add Data Fields to Headers and Footers
- 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
- Import Data from Spreadsheets
- Import Data from Text Files
- Import Data from Tables
- Link a Database to External Data
- Create Append Queries
- Create Delete Queries
- Make a Table from a Query
- Create an Update Query
- Create a Crosstab Query
- Create a Find Duplicates Query
- Create a Find Unmatched Query
- 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 beginner and professional who in need of Advanced database management knowledge in order to create forms and more
Pre-requisites
Need to possess basic knowledge of Access 2010
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 ICDL courses
Course Rating
- /5 from users
Course Enquiry
Course Info
- Course Provider GENETIC COMPUTER SCHOOL PTE LTD
- Course Category Technology
- Course Price $420
Comments