Database Structure (Grade 11 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Primary key
Primary key
Unique identifier for each record across entire database
Minimum tables needed in database
Minimum tables needed in database
At least one table
Field Size property function
Field Size property function
Maximum size limit on data entered into column
Default Value property function
Default Value property function
Automatically placed in column when new record added
Required property function
Required property function
Forces user to enter value before saving record
Short Text data type used for
Short Text data type used for
Names, addresses, and other text information
Autonumber data type purpose
Autonumber data type purpose
Automatically generated unique identifiers
Forms in database provide
Forms in database provide
User-friendly way to interact with database information
Form Wizard function
Form Wizard function
Guides through creating forms step by step
Data validation maintains
Data validation maintains
Quality and consistency of database information