Question

Choose one of the three discussion areas and discuss with your classmates. Consider Microsoft Access when answering this question.   

1. Why is it important to select the proper field size for a field whose data type is Number? What would happen if you had a field that contained only decimal values and you assigned a field size of integer or long integer?
2. Should you group related fields together, such as street, city, state, postal code or simply add them in random order? Why or why not?
3. Does the primary key field need to be the first field in a table?

Answer 1

Why is it important to select the proper field size for a field whose data type is Number?

because number will be fixed and unique id that contain some fixed length like mobile number for say 10 digits so not more than that should be inserted so size if must in number field.

What would happen if you had a field that contained only decimal values and you assigned a field size of integer or long integer?

it wont affect it takes any long or integer with number data type as you can check in screenshot.

Should you group related fields together, such as street, city, state, postal code or simply add them in random order? Why or why not?

there should be some fixed sequence to be maintained so data discipline will get maintain and all data will be filtered properly during the report time

Does the primary key field need to be the first field in a table?

no it can be any filed to be defined as pk .

if you have any doubt then please ask me without any hesitation in the comment section below , if you like my answer then please thumbs up for the answer , before giving thumbs down please discuss the question it may possible that we may understand the question different way and we can edit and change the answers if you argue, thanks :)