السلام عليكم ورحمة الله وبركاته
أرجو من حضراتكم أن تفيدوني في موضوعي
لدي سؤال مكون من 3 فقرات
a,b,c
وقمت أنا بالاجابة عليهم ببرنامج الأكسس
وفيما يلي سأرفق لكم السؤال+الحل بالاكسس كل فقرة بحلها بالصور
السؤال
You are responsible for managing information systems development projects at AAA Systems Inc. To better track progress in completing projects, you have decided to maintain a simple database table to track the time your employees spend on various tasks and the projects with which they are associated. It will also allow you to keep track of employees' billable hours each week. The following table provides a sample data set.
الفقرات مع الحلول
a-. Build a database table to store the data shown, and enter the records as a set of sample data.
b. Create a query that will list the hours worked for all workers who worked more than 40 hours during production week 20.
c. Create a report grouped by project that will show the number of hours devoted to each task on the project and the total number of hours devoted to each project as well as a grand total of hours worked.
المطلوب منكم أن تفيدوني بـ
هل حلي للفقرات الثلاث صحيح ؟؟ أم هناك أخطاء؟؟مع تنبيهي للأخطاء
وشكــراً لكــم
