Series of two week projects due every other Wednesday.

This course is an in-depth study of the use of Microsoft Access for business-related purposes. It provides students the opportunity to learn this industry standard program by applying real-world relational database management skills and database design techniques. This course offers extensive hands-on training on the introductory, intermediate, and advanced levels. General topics included are understanding the nature and business use of relational databases, effectively planning and designing a database, normalizing data, understanding data types, developing effective entity relationship models and diagrams, understanding the role of primary and foreign keys, creating tables, modifying field properties, enforcing referential integrity, developing sub-datasheets, developing queries, understanding SQL coding and types of joins, and designing basic forms to enter and modify data, and designing basic reports. This course should accommodate the needs of those desiring to obtain comprehensive knowledge and application of using a relational database in any career field. 

This course is an in-depth study of the use of Microsoft Excel for business-related purposes. It provides students the opportunity to learn this industry standard program by applying real-world data management skills and data analysis techniques. This course offers extensive hands-on training on the introductory, intermediate, and beginning advanced levels. General topics included are managing and organizing data using tables, calculating data with formulas and functions, analyzing data using charts and conditional formatting, summarizing data with outlining and pivot tables, validating data and trouble-shooting errors, and automating procedures with macros. This course should accommodate the needs of those desiring to obtain comprehensive knowledge and application of using spreadsheets in any career field.