Course | December 4 | 1:30-4 p.m. | 28 University Hall
This course details the process of designing Select Queries in a Microsoft Access database. Emphasis is placed on sorting, ranking, filtering, interactive criteria, and modular design techniques. Learning Objectives * Understand the purpose and interdependencies of the six major database object types. * Contrast flat file data storage against relational database management systems. * Design new Select Queries to sort and filter Table records. * Understand the concept of modular design and Query-based data sources. * Set Query and field properties to alter record output results. * Integrate SQL keywords and operators to enhance filter capabilities. * Understand the functional difference between unique values and unique records. * Apply ranked values to Query results. * Summarize results using grouping and totaling. * Define Parameter Values to create dynamic, interactive Query objects.