The student will apply principles of database design and management to the selection of appropriate relational database systems. Students will demonstrate skills at the introductory and intermediate & advanced levels by producing documents using Windows 7 and Microsoft Access 2010. Within Access, students will create and maintain database tables, define table relationships, create running and saving queries, sort and filter records, create and customize forms and reports, publish Access objects to the World Wide Web, replicate a database, create and run macros, create a switchboard, work with database security and write Visual Basic code. Students will identify different models of database design. Students will use their knowledge of object-oriented, distributed, and client/server systems, as well as data warehousing, QBE, and SQL, to identify and analyze database design needs and internet and intranet implications for database management. This course is designed to prepare students for the Microsoft Office Specialist Certification (MOS) certification exams. The MOS Program Certification exams help students demonstrate their proficiencies to prospective employers and give them a competitive edge in the job marketplace.

This is a prerequisite course for CPD 226.