Designing Database Tables (Grade 11 NSC Matric Computer Application Technology): Quizzes

What are the two essential principles of good database design?

No redundant data & correct info

Which problem is NOT caused by redundant data?

Slow internet connection

What is the first step in planning your database structure?

Determine the database purpose

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?

Required, Validation rule, Text

In an input mask, what does the character '0' represent?

Required digit (0-9)

In an input mask, what does 'L' require?

Required letter (A-Z)

Which validation rule ensures an entry contains an @ symbol?

Like "@"

Which validation rule allows only numbers between 10 and 100 (inclusive)?

=10 And <=100

How must dates be formatted in Access validation rules?

yyyy/mm/dd in hash symbols (#)