CHAPTER 18- DATA MANIPULATION

 

A database is an

• interesting collection of facts

• a computer-based data storage technology

• organised collection of data

• a large disorganised bucket of data

To search a database

• Report

• Query

• Label

• Table

When would MS Access be used instead of MS Excel?

• When using one large worksheet with mostly numeric data

• Creating complex graphs or charts

• Creating essays with included data

• For multiple tables, lots of data & using external databases

 

What do we use to ensure that at least one aspect of a Record is unique?

• Datatypes

• Primary Key

• Field Names

• Reports

Which of these fields is the primary key

• Student_Fname

• Student_Sname

• Student_ID

• None of these

A software tool that allows you to use a computer to create a database

• Records

• Microsoft Access

• Datasheet

• Blind date

A collection of rows and columns

• Database

• Design View

• Datasheet

• Form View

Another name for unique identifier

• Unique Identifier

• Special Field

• Primary Key

• Access Codes

Contains a specific piece of information within a record.

• Field

• Text File

• Database Sheet

• Report Wizard

Rows in the table

• Fields

• Records

• Row your boat

• Entry