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)
