Question: Amaya and her ten friends have decided to deposit ₹10 every month for the welfare of some poor children in an orphanage. Make a database table structure in the Design View, containing the fields like Student_Name, Roll_no, Month and Amount.
Question: Amaya and her ten friends have decided to deposit ₹10 every month for the welfare of some poor children in an orphanage. Make a database table structure in the Design View, containing the fields like Student_Name, Roll_no, Month and Amount.
Follow the below points:
1. Set the field size for Student_Name to 20 Characters.
2. Set the field Data Validation for Roll_no so that Roll_no must not be less than 1 and more than 50
3. Format the Amount field to Currency Number(rupee).
4. Set the default value for the Month field to August.
5. Make 5 entries for your friends.
Answers
Answer:
2020. Learn More
Brainly.in
What is your question?
1
gaurav5212
gaurav5212
3 weeks ago
Computer Science
Primary School
+5 pts
Question: Amaya and her ten friends have decided to deposit ₹10 every month for the welfare of some poor children in an orphanage. Make a database table structure in the Design View, containing the fields like Student_Name, Roll_no, Month and Amount.
Question: Amaya and her ten friends have decided to deposit ₹10 every month for the welfare of some poor children in an orphanage. Make a database table structure in the Design View, containing the fields like Student_Name, Roll_no, Month and Amount.
Follow the below points:
1. Set the field size for Student_Name to 20 Characters.
2. Set the field Data Validation for Roll_no so that Roll_no must not be less than 1 and more than 50
3. Format the Amount field to Currency Number(rupee).
4. Set the default value for the Month field to August.
5. Make 5 entries for your friends