Résumé de section

  • Généralités

    Tout replier Tout déplier

    In the modern world, data has become a vital asset for every organization, especially in the fields of accounting and finance. Efficient data management is essential for ensuring accuracy, transparency, and informed financial decision-making. This course introduces students of Accounting and Finance to the fundamental concepts and techniques of Database Management Systems (DBMS). Through both theoretical lessons and practical sessions using Microsoft Access, students will learn how to design, organize, and manage databases that support accounting records, financial analysis, and business operations. By the end of the course, students will be able to understand how databases are used to store, process, and analyze financial data, and how effective database design contributes to improving financial management, control, and reporting within organizations.

     

  • Nouvelle section

    In the field of Finance and Accounting, data accuracy and organization are essential for reliable analysis and decision-making. Financial transactions, accounting records, and performance indicators all depend on well-structured and efficiently managed data systems.
     
    This course introduces students of Finance and Accounting to the fundamental principles of Database Management Systems (DBMS). It provides both theoretical and practical training using Microsoft Access, enabling students to design, create, and manage databases that support financial reporting, auditing, budgeting, and business analysis.
     
    By the end of the course, students will be able to understand how databases are used to store, process, and analyze financial and accounting data, and how effective database management contributes to accuracy, transparency, and efficiency in financial operations.

  • Lesson: Queries in Access

    *    . What is a Query?

     A query is a tool in Access used to search, filter, analyze, and extract specific information from one or multiple tables.

    • course:Queries in Access Fichier
    • database:Sales_Management.accdb Fichier

      • "Sales_Management" database

        اعزّائي الطلبة، لقد قمتُ بوضع قاعدة البيانات الكاملة Sales_Management" والتي تضم جميع المراحل التي شرحناها في الدروس: إنشاء الجداول، العلاقات، إدخال البيانات، والاستعلامات الأساسية. الرجاء تحميلها واستعمالها في التطبيق العملي خلال الحصص القادمة.

        Dear students, I have uploaded the complete "Sales_Management" database, which includes all the steps covered in coures: table creation, relationships, data entry, and essential queries. Please download it and use it for the practical exercises in the upcoming sessions

  • EXAM

    EXAM

    • امتحان Test
      Ouvert : lundi 2 février 2026, 08:00
      Terminé : lundi 2 février 2026, 23:59

      EXAM

      -        مدة اجتياز الامتحان 25 دقيقة مع محاولة واحدة فقط.

    • EXAM Fichier
    • الاجابة على الإمتحان Devoir
      Ouvert le : dimanche 14 décembre 2025, 00:00
      À rendre : jeudi 18 décembre 2025, 00:00

      ضع هنا حلول الاستجواب

  • Nouvelle section

  • Nouvelle section