Microsoft Office Access Assignment
Deadline: Tuesday 28/11/2023 – 14/05/1445 @ 23:59
Task1
1- Create new database and Enter the following tables:
Customers_Table

Customer_ID
1 2 3 4
Sales_Table
Transaction_ID
21 22 23 24 25
First_Name Text
Lamia Hajer Sama Fahad
Customer_ID
3 4 1 3 2
Last_Name Text
Saad Ahmad Abdulsalam Omar
Transaction_Da te – Date
5-5-2023 6-5-2023 6-5-2023 6-5-2023 6-5-2023
Address Text
Riyadh Kharj Makkah Abha
Product – Text
Pens Books Erasers Books rulers
Mobile_No
055343
056789
055672
055567
Numbe r- Text
3 4 5 3 1
Comments
New Customer
New Customer Frequent Customer New Customer
ب-Price Total عملة
Payment
(PK)- number
Number
Long Text
حقل محسو
(PK)-Number
(FK)-Number
(Price*Number)
Yes-No
12 SR 36 No 40 SR 160 yes 30 SR 150 yes 60 SR 180 yes 4SR 4 No
2- Make a Relation between the above two tables (PK to FK)
3- Generate a query that displays information about customers who do
not pay? (Customer_ID)(First_Name)(Last_Name)(Total)(Payment)
Kingdom of Saudi Arabia
المملكة العربية السعودية
Prince Sattam bin Abdulaziz University
جامـعـة األمير سطام بن عبد العزيز
الكلية التطبيقية بحوطة بني تميم
Applied College in Hotah
قسم أمن المعلومات
Department of Information Security
Student name:
Student ID:
Course name:
Course code:
Year/Sem.: 1445H – 2023 – 1st Semester
Due date:
Lecturer: Hanan Al-asmari
Evaluation:
Microsoft Office Access Assignment
Deadline: Tuesday 28/11/2023 – 14/05/1445 @ 23:59
Task1
1- Create new database and Enter the following tables:
Customers_Table
Customer_ID
(PK)- number
Last_Name
Text
Address
Text
Mobile_No
Number
Lamia
Hajer
Sama
Fahad
Saad
Ahmad
Abdulsalam
Omar
Riyadh
Kharj
Makkah
Abha
055343
056789
055672
055567
Transaction_ID
(PK)-Number
Customer_ID
(FK)-Number
Transaction_Da
te – Date
Product
– Text
Numbe
r- Text
Price
عملة
Total-حقل محسوب
(Price*Number)
Payment
Yes-No
21
22
23
24
25
3
4
1
3
2
5-5-2023
6-5-2023
6-5-2023
6-5-2023
6-5-2023
Pens
Books
Erasers
Books
rulers
3
4
5
3
1
12 SR
40 SR
30 SR
60 SR
4 SR
36
160
150
180
4
No
yes
yes
yes
No
1
2
3
4
First_Name
Text
Comments
Long Text
New Customer
New Customer
Frequent Customer
New Customer
Sales_Table
2- Make a Relation between the above two tables (PK to FK)
3- Generate a query that displays information about customers who do
not pay? (Customer_ID)(First_Name)(Last_Name)(Total)(Payment)
________________________________________________________________________________
Page 1 of 1