Basics of Access (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 organises info into
Database organises info into
Structured files called tables
Structure used by database tables
Structure used by database tables
Grid with columns (fields) and rows (records)
Fields in a database table
Fields in a database table
Vertical columns containing one specific type of info
Records in a database table
Records in a database table
Horizontal rows with all info about one item/person
Database object that stores actual data
Database object that stores actual data
Tables
Forms purpose in a database
Forms purpose in a database
User-friendly interfaces for data entry
Queries purpose in a database
Queries purpose in a database
Search tools that can combine info from multiple tables
Reports purpose in a database
Reports purpose in a database
Present data in formatted layouts for printing/sharing
AutoNumber data type function
AutoNumber data type function
Automatically generates unique numbers for each record
Text data type character limit
Text data type character limit
Up to 255 characters