Grade 7- ICT- access Database

A "database" is...

• a structured set of data held in a computer, especially one that is accessible in various ways
• spreadsheet program
• owerful presentation software

A "key" in a database allows the user to...

•  help establish relationships with other tables
• unlock data

In a database, a "form" allows you to...

• create a query
• enter data and edit it in a simple form that consists of the fields from a table

In a database, a "table" is a...

• set of data elements using a model of vertical columns and horizontal rows
• spreadsheet program
• presentation program

Nick wants Access to assign an ID number to each record. What is this called?

• Data Type
• auto numbering
• Properties

The swim coach is looking for swim team purchase orders  that are greater than $200. What criteria would give her this info?

• >200 OR swimming
• >=200 OR swimming
• >200 AND swimming

TRUE OR FALSE:  You can create "reports" in Access Database in order to format data in user friendly way

• TRUE
• FALSE

TRUE OR FALSE:  You can create "reports" in Access Database in order to format data in user friendly way

• TRUE
• FALSE

In a database, a "field" is 

• unique identifier
• user friendly report
• a data structure for a single piece of data composed of records and fields

A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.

• Query
• Report
• Database 
• Spreadsheet