Management information system, a homeword on “Access”

1. Create a new database, name it “Your family and your colleaguefamily name Database”
2. Create two tables in your Database with the following:(1Pt)

▪ Supplier

Mobile number

SupplierName

SupplierID

0501111111

Abdullah Alali

1111

0502222222

Saleh Alahmadi

2222

0503333333

OmarAlKhalid

3333

▪ Products

SupplierID

ProdcutName

ProdcutID

1111

Door latch

1

2222

Door handle

2

1111

Mirror side

3

3333

Door molding

4

1111

Door lock

5

1. Create relation between the tables. (1Pt)
2. Create a Form with all fields on Supplier Table. (0.5 Pt)
3. Create a Form with all fields on Products Table. (0.5 Pt)
4. Create a query showing the Fields ProdcutID , ProdcutName and SupplierName where ProdcutName = Door latch . (1Pt)
5. Create a report based on Supplier and Products Tables showingthe Fields: ProdcutID

Sample Solution