CIS 120 - Introduction to Databases

    Recent Professors
    Not yet assigned
    Recent Semesters
    No scheduled sections on record
    Class Size
    Not published
    Credits
    3
    Prerequisite
    CIS 104
    Transfers To
    CSU
    Description
    This course covers the concepts of database structures and design involving the physical and logical structures and the environments in which they can be applied. Students will gain a comprehensive coverage of the database features including creating and maintaining a database, creating simple and advanced queries, creating standard and custom forms and reports, enhancing table design, automating tasks with macros, working with layout view, interactive form and report design capabilities, and changes to security features. This course provides students with a solid understanding of important database concepts, including database design, field properties, table relationships, join types, splitting a database, object dependencies, normalization, and naming conventions. The three major approaches to the application of databases are included: relational, hierarchical, and network. Students will have a variety of hands-on and case project assignments that reinforce the database concepts. This course meets the requirements for the Microsoft Certified Application Specialist exam for Microsoft Office Access 2007.