Undergraduate Certificate in Microsoft Access Database Applications

This course is a study of the principles of data presentation and the use of Crystal Reports to visualize data. Students will explore the facilities of Crystal Reports (Design Window, Toolbars, Field Explorer, Database Expert, Record Sort Expert, Group Expert, Formula Workshop, Formula Editor, Select Expert, Section Expert, Business Views, and Repository). They will export and import data to MS Office Applications such as Word and Excel. They will parameterize reports, conditionally format reports, customize the appearance of reports, build custom functions, create business views, specify data security, and control user access. Students must have access to Crystal Reports version 10 (or higher) software. This software is not provided by the course material grant and must be purchased/provided by the student.

This course focuses on the role, function, and operations of relational databases in the management of information. The course will be taught from a mixture of analytical and practical methods. This course introduces the student to the concepts of relational databases and to the principles of relational database design in the context of the Microsoft Access Relational Database Management System (RDBMS). Students will apply their knowledge of the principles of data design and database engineering to design and develop a database application that includes user interfaces, form design, data analysis, and data presentation. They will examine the rudiments of referential integrity and normalization and apply this knowledge to design the database tables that implement validation rules to ensure application integrity. They will also examine and develop advanced queries such as: top values, list of values, cross tab, find duplicates, and find unmatched. Students must have access to Microsoft Access 2007 (or higher) software. This software is not provided by the course material grant and must be purchased/provided by the student. The book meets the topical requirements for the Microsoft Certified Application Specialist (MCAS): Using Microsoft Office Access 2007 certification.

This course is an introduction to the concepts, management issues, and advantages of relational database management systems. Topics include data definition, data manipulation, relational algebra, Structured Query Language (SQL), and Online Transaction Processing (OLTP) systems. This course examines database design, normalization for OLTP systems, Codd’s rules for OLTP systems, data integrity, database system functions (journaling, forward recovery, backward recovery), database security (authentication and authorization), and database administration. This course also explores distributed databases, Online Analytic Processing (OLAP) systems, data warehouses, and object-oriented databases. Students must have access to Microsoft Access 2007 (or higher) software. This software is not provided by the course material grant and must be purchased/provided by the student.

This course focuses on developing Microsoft Access Switchboard applications; it includes: designing and building form and report interfaces, interfacing the Access database to a web page, building dynamic web pages, integrating Access with other Office applications such as Excel, building pivot tables and charts, categorizing the various types of join operations, examining the rudiments of the Visual Basic for Applications (VBA) code, debugging VBA code, creating macros and functions, and designing Access applications. Students must have access to Microsoft Access 2007 (or higher) software. This software is not provided by the course material grant and must be purchased/provided by the student.(Prerequisite: INFO161).

Pre Reqs: Relational Databases with MS Access: Introduction(INFO161)

This course is a study and application of the MS Access VBA Programming; it takes you from using Access to programming with Access. This course translates ERD diagrams into database designs, examines the VBA programming model, converts macros to VBA code, delves into the rudiments of the Visual Basic for Application (VBA) language system, uses the VBA editor, uses VBA to connect to Access, utilizes VBA to perform DDL actions in Access, creates sub procedures, implements functions, handles errors, performs debugging, and utilizes the built-in functions. This course also includes implementing database access in Windows based and Web based solutions. This course also includes an examination of the Security Model in the context of Access and VBA. Students must have access to Microsoft Access 2003 (or higher) software. This software is not provided by the course material grant and must be purchased/provided by the student.(Prerequisite: INFO221 and INFO261).

Pre Reqs: Relational Database Concepts(INFO221),Relational Databases with MS Access: Advanced(INFO261)

This course provides a technical and organizational foundation for understanding the use and importance of information systems and information technology in today's management environment. This course covers the hardware, software, and infrastructure that support management information systems. Information and decision support systems, knowledge management and specialized information systems, database management systems, telecommunications, the Internet, Intranets, Extranets, and wireless networks will be examined. This course also covers systems development, e-commerce, and the ethical and societal impact of management information systems.