INFO161 Relational Databases with MS Access: Introduction (3 semester hours)
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 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 Office Specialist (MOS). Course software requirements with the appropriate versions are listed under the course materials site. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS even on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.Microsoft Access® is a registered trademark of Microsoft Corporation.
View the course schedule to find out details about each course including prerequisites, course objectives, course materials, a snapshot of the syllabi, and session dates.
INFO221 Relational Database Concepts (3 semester hours)
This course introduces students to the concepts, management issues, and advantages of relational database management systems. Topics covered in the class will include data definition, data manipulation, relational algebra, Structured Query Language (SQL), and Online Transaction Processing (OLTP) systems. Also, this class examines database design, normalization for OLTP systems, Codd’s rules for OLTP systems, data integrity, database system functions (journaling, forward recovery, and backward recovery), database security (authentication and authorization), and database administration. Other topics that students will explore in this course include distributed databases, Online Analytic Processing (OLAP) systems, data warehouses, and object-oriented databases.
View the course schedule to find out details about each course including prerequisites, course objectives, course materials, a snapshot of the syllabi, and session dates.
INFO222 Database Concepts (3 semester hours)
This course studies the major advancements in database technology that have taken place in recent years. The class will introduce students without a prior background in Microsoft Access® to basic concepts and will cover advanced topics as well. The course offers both conceptual and hands-on material in database management, enabling students to have improved comprehension and retention of course material. Note: Software for this course is not provided by the course material grant and must be purchased/provided by students.Note for Mac users: Access 2019 and older do not work on the Mac OS. The University recommends using Windows OS, even on Mac. If a Mac OS must be used, it is recommended that students install Windows on Parallels (purchased separately) and install Access 2019 on the Windows OS via Parallels. Microsoft Access is a registered trademark of Microsoft Corporation.Microsoft Access® is a registered trademark of Microsoft Corporation.
View the course schedule to find out details about each course including prerequisites, course objectives, course materials, a snapshot of the syllabi, and session dates.
INFO261 Relational Databases with MS Access®: Advanced (3 semester hours)
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 Microsoft 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 software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.Microsoft Access® and Microsoft Excel are registered trademarks of Microsoft Corporation.
View the course schedule to find out details about each course including prerequisites, course objectives, course materials, a snapshot of the syllabi, and session dates.
INFO262 Relational Databases with MS Access®: Project (3 semester hours)
This course is a study and application of the Microsoft 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 software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS even on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS even on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.Microsoft Access® is a registered trademark of Microsoft Corporation.
View the course schedule to find out details about each course including prerequisites, course objectives, course materials, a snapshot of the syllabi, and session dates.
INFO331 Management Information Systems (3 semester hours)
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.
View the course schedule to find out details about each course including prerequisites, course objectives, course materials, a snapshot of the syllabi, and session dates.
INFO400 MongoDB® and Python® (3 semester hours)
In this dynamic, project-based course on Python® and its applications, students will explore various aspects of Python and its use in data analysis. Students will have the opportunity to learn and apply analytical methods, dive into statistics, and understand the fundamentals of machine learning. Students will also work with traditional SQL databases and explore NoSQL data management systems. The course will also help to provide students with a well-rounded understanding of different data management approaches. The course will focus on engaging exercises that will help students to develop essential skills and gain hands-on expertise with key data science libraries. (Prerequisites: ENTD200, ENTD220, and INFO222)MongoDB is a registered trademark of MongoBD, Inc.; Python® is a registered trademark of the Python Software Foundation.
View the course schedule to find out details about each course including prerequisites, course objectives, course materials, a snapshot of the syllabi, and session dates.
INFO498 Information Technology: Capstone (3 semester hours)
This capstone course is a senior level course designed to allow the student to review, analyze and integrate the work the student has completed toward a degree in Information Technology. The student will complete an approved academic project and paper that demonstrates mastery of their program of study in a meaningful culmination of their learning, and assesses their level of mastery of the stated outcomes of their degree requirements. This is a capstone course to be taken after all other Information Technology courses have been satisfactorily completed. Students must have senior standing in the program and must demonstrate that they have taken all other IT courses in their degree plan prior to registering for this course. (Prerequisite: Completion of a minimum of 105 hours towards your program including ENGL101 or ENGL110)
View the course schedule to find out details about each course including prerequisites, course objectives, course materials, a snapshot of the syllabi, and session dates.