Past Papers 12th Class Computer Science Ch 6

Past Papers 12th Class Computer Science Ch 6 Questions

• Define Text Data Type in MS-Access.
• Differentiate between Field and Record.
• Name two table views available in MS-Access.
• Define the term cardinality of relation.
• Define the term table in database.
• What is field?
• What are reports?
• Write two characteristics of tables.
• How does a database differ from a table?
• What is the uses of query in database?
• What is attribute? Give an example.
• What is the use of Input Mask?
• What is the use of field size property?
• Define the term sorting.
• What is filter? Explain its two types available in MS-Access.
• Write a query to display all record from employee table?
• List any field properties.
• What datasheet view is different from table design view?
• What is the use of SELECT query?
• List three methods to create table in MS-Access.
• Discuss the use of design view in MS-Access.
• Why is it important to specify the data type and size of the field?
• What is the use wild cards?
• How is criteria specified in query?
• Define referential integrity?
• Define the term degree of relation?
• List out different data types available in MS-Access?