AF_Accesse

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