Spreadsheet
What feature in spreadsheet extracts data from a table based on some criteria.
Advanced Filtering
What feature in Database maintains data accuracy between data in the tables.
Relationships
Pretending to be someone else to steal information is called
Identity theft
Which input device is used to read data off cheques.
MICR
Name the tab used to create fillable forms
Developer tab
What formula checks the number of book categories in a table.
=COUNTA
Explain how to form a relationship between two tables.
Close all open tables, select database tools, match the primary key and foreign key of the tables and enforce referential integrity.
Getting sensitive information by deceiving the user through an email
Phishing
Name three output device
printer, speaker, plotter
List three content controls used in a fillable form
rich text, date picker, combo box, drop down list, check box
What feature in spreadsheet allows us to summarise and manipulate data without changing the data in the table.
Pivot table
Name three objects that be used to analyse and manipulate data.
queries, reports, forms
Breaking into someone account
Hacking
OMR
What content control can be used for date of birth, date registered
date picker
Briefly explain how to create a pie chart to show total number of various fruits sold.
Select Quantity and then hold down ctrl select the fruits column and then click insert, select pie chart. Place title above chart.
List any three data types used in access(database)
currency, short text, Long text, number, date and time
Listening to personal calls to get information
Electronic Eavesdropping
Name THREE input devices
keyboard, mouse, joystick, scanner, microphone
when doing mail merge state the first step
create recipient list ( contact information)
If a table has item cost and No. Sold. State the formula used to show Total Cost
=product(item cost*No.SOld)
Explain why we should maintain integrity of data in a database
maintains consistency of data, prevents data loss and corruption, accuracy in decision making
Using the internet to embarrass or hurt someone
Cyber bullying
Which input device converts handwritten text into digital form
OCR
Why do we create fillable forms
more organized data, ease of use, faster, more efficient, accuracy of data