Introduction to Databases (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
Database views purpose
Database views purpose
Different ways to view/interact with data
Two primary database views
Two primary database views
Datasheet View and Design View
View button functionality
View button functionality
Toggles between Datasheet and Design View
Datasheet View main purpose
Datasheet View main purpose
Interact directly with data in spreadsheet-like format
Design View main purpose
Design View main purpose
Create and modify table structure
Actions possible in Datasheet View
Actions possible in Datasheet View
Enter data, edit records, navigate, view data, adjust columns
Datasheet View limitations
Datasheet View limitations
Cannot change table structure or modify field properties
Actions possible in Design View
Actions possible in Design View
Create fields, set data types, configure properties
Design View limitations
Design View limitations
Cannot view or edit actual data stored in table
Best workflow for new tables
Best workflow for new tables
Start Design View, switch Datasheet for data, back for changes
