Overview of Reports (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
Reports in databases
Reports in databases
Professional way to present database info in organised format
Tables vs reports difference
Tables vs reports difference
Tables show raw data; reports format, group & summarise data
Report header section
Report header section
Appears at start; holds logo, title, date for entire report
Page footer section
Page footer section
Appears at bottom of every page; typically page numbers
Detail section in reports
Detail section in reports
Where actual data appears; repeats once for every record/row
Report Wizard
Report Wizard
Tool that guides through report creation step by step
Sum() function
Sum() function
Adds up all numerical values in a column
Count() function
Count() function
Tells how many items appear in a column
CSV
CSV
Comma-Separated Values files
External Data tab purpose
External Data tab purpose
Provides comprehensive set of import and export tools