2020-2021 Spring Edition 
    
    Mar 29, 2024  
2020-2021 Spring Edition [ARCHIVED CATALOG]

CIMA 206 ADVANCED DATABASE - ACCESS


3 Units 3 hours lecture 1 hour lab
Recommended Preparation: CIMA 106 or CIMA 283H
Develops competencies in the advanced topics of database software. Learn to validate data, normalize data tables, use analysis and design tools, and export and import data. Create advanced action, parameter, append, delete and crosstab queries. Perform data mining with PivotTables. Create advanced forms and reports. Create macros and write SQL statements. Encrypt/decrypt databases and improve database performance.
Grading Method: GR - Letter Grade or Pass/No Pass
NR