Question

The structure of a table “Prod” is given below. Suggest suitable data type and size of each column. Column name Type Size Prod no ____________ ______ Prod name ____________ ______​

Answer 1

Answer:

Question 1. What is the default extension of a MS-Access database?

Answer: The default extension of a MS-Access database is .accdb.

Question 2. How NUMBER and DATE/TIME type fields are different in Access? Give any one difference.

Answer: NUMBER data type contains numeric values, while DATE/TIME type field contains date and time values.