Boost your Grades with us today!

management information system a homeword on access

Everything is in the picture i uploaded, All of the homework.

Answer the following questions:

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

3. Create relation between the tables. (1Pt)

4. Create a Form with all fields on Supplier Table. (0.5 Pt)

5. Create a Form with all fields on Products Table. (0.5 Pt)

5. Create a query showing the Fields ProdcutID , ProdcutName and SupplierName where ProdcutName = Door latch . (1Pt)

6. Create a report based on Supplier and Products Tables showingthe Fields: ProdcutID

, ProdcutName and SupplierName. (1Pt)

Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!