Designing Database Tables (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 are the two essential principles of good database design?
What are the two essential principles of good database design?
No redundant data & correct info
Which problem is NOT caused by redundant data?
Which problem is NOT caused by redundant data?
Slow internet connection
What is the first step in planning your database structure?
What is the first step in planning your database structure?
Determine the database purpose
What does OLE allow you to do in Access?
What does OLE allow you to do in Access?
Embed files from other programs
Which three field properties are most critical for maintaining data quality?
Which three field properties are most critical for maintaining data quality?
Required, Validation rule, Text
In an input mask, what does the character '0' represent?
In an input mask, what does the character '0' represent?
Required digit (0-9)
In an input mask, what does 'L' require?
In an input mask, what does 'L' require?
Required letter (A-Z)
Which validation rule ensures an entry contains an @ symbol?
Which validation rule ensures an entry contains an @ symbol?
Like "@"
Which validation rule allows only numbers between 10 and 100 (inclusive)?
Which validation rule allows only numbers between 10 and 100 (inclusive)?
=10 And <=100
How must dates be formatted in Access validation rules?
How must dates be formatted in Access validation rules?
yyyy/mm/dd in hash symbols (#)