WSQ Advanced Access Course in Singapore

Module 1: Database Concepts

• Database Development and Use – Know that different types of database models exist like: hierarchical/relational/object-oriented, know the life cycle stages of a database: logical design/database creation/data entry/data maintenance/information retrieval, recognize common business applications of databases like: dynamic website, know the term SQL and understand its main use in querying database content
  
  

Module 2: Tables and Relationships

• Fields/Columns – Create/modify/delete a lookup in a field/column, create/modify/delete an input mask in a field/column, set data entry for a field/column: required/not required
• Relationships and Joins – Create/modify/delete a one to-one/one-to-many relationship between tables, create/modify a many-to-many relationship using a junction table, apply referential integrity between tables, apply automatic update of related fields, apply automatic deletion of related records, apply/modify an inner join/outer join, create/modify a subtract join, apply a self joinAdvanced Access Practical hands-on training at Intellisoft
  
  

Module 3: Queries

• Query Types – Create/run a query to update data/append records/delete records in a table, create, run a query to save selected data as a new table, create/run a cross tab query, show duplicated records within a table, show unmatched records in related tables
• Refining a Query – Create/modify/run a one/two variable parameter query, use wildcards, show highest/lowest range of values, create and name a calculated field that performs arithmetic operations, group information in a query using functions: sum, count, average, max, min