CEIT112 Information Technology in Education II
This course provides a comprehensive knowledge into database management and Microsoft Access, designed to equip students with the skills to organize, analyze, and manage data efficiently. Students will delve into foundational concepts, intermediate techniques, and advanced applications in a progressive manner, ensuring both a solid understanding and practical proficiency.
- The fundamental concepts of database management systems and the principles of relational database design
- How to effectively use Microsoft Access 2021, including navigating its interface and utilizing its core features
- Techniques for creating and managing tables, relationships, and queries to organize and analyze data
- The process of designing and generating customized forms and reports to meet specific user requirements
- Methods to ensure data security and ethical practices in data management and ownership
Course Objectives
Learning Materials
Resources
- Microsoft Learn: Introduction to Access
- Udemy: Microsoft Access for Beginners
- Simon Sez IT – "Microsoft Access for Beginners" Playlist
- Teknolojik Yardım – Microsoft office
- Learnit Training – Access Traning Playlist
- Access Tutorials: Beginners' Guide to MS Access
- GCFGlobal: Microsoft Access Basics
📍 Beginner
Roadmaps
Skills to Learn
- Familiaring with the MS Access interface
- Creating tables and defining basic relationships
- Writing simple queries
- Designing basic forms and reports
- Efficient data management techniques
- Advanced querying and reporting
- Relational database design principles
- Introduction to macros and automation
- VBA programming for Access
- Data integration and automation
- Database optimization and security
- Complex reporting and analysis