BTEC National U2 - Database Revision

A Primary Key is a code that uniquely identifies a _____________ in a Database.

• Record 
• Field 
• Text 
• Number

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

• Query
• Report
• Database 
• Spreadsheet

In a database table, rows are called __________

• Field
• Record
• Primary Key

Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.

• Cell
• Field
• Column
• Record

Forms, queries, and reports are created based on the information in the _________

• Form
• Table
• Report

What software do you use to make databases?

• Access

• Excel

• PowerPoint

• Word

Data type for '12/4/16'

• Text

• Date

• Long text

• Number

Data type for 'Bob'

• Number

• Memo

• Text

• Currency

Data type for '5.5'

• number

• text

• long text

• autonumber

Data type for '£5.67'

• Number

• Currency

• Date

• Time