Transfers ToCSUDescriptionThis 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.