Database Structure (Grade 11 NSC Matric Computer Application Technology): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What must every database contain according to Microsoft Access database structure principles?
What must every database contain according to Microsoft Access database structure principles?
At least one table
What is the purpose of a primary key in a database table?
What is the purpose of a primary key in a database table?
Unique identifier for each record
Which field property forces a user to enter a value before saving a record?
Which field property forces a user to enter a value before saving a record?
Required
Which data type automatically generates unique identifiers in Access?
Which data type automatically generates unique identifiers in Access?
Autonumber
Which tab do you use to add tables to an existing database in Access?
Which tab do you use to add tables to an existing database in Access?
Create tab
Which field property automatically places a value when a new record is added?
Which field property automatically places a value when a new record is added?
Default Value
Which form creation method gives complete creative freedom over appearance?
Which form creation method gives complete creative freedom over appearance?
Blank forms in Design view
What is the main purpose of data validation in databases?
What is the main purpose of data validation in databases?
Maintain quality and consistency
Which field property controls how data is entered by providing a template?
Which field property controls how data is entered by providing a template?
Input Mask
Which data type should be used for storing names and addresses?
Which data type should be used for storing names and addresses?
Short Text