CIS 120 - Introduction to Databases

    Recent Professors
    Mark Macias
    Recent Semesters
    Spring 2027
    Class Size
    Not published
    Difficulty
    4.1Lightout of 10
    Credits
    3
    Prerequisite
    CIS 104
    Spring 2027 Sections
    View Spring 2027 sections of CIS 120
    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.