Databases 2

A __________ helps us to keep the information in our database structured

• Primary Key

• Record

• Autonumber

• Field

A table is divided into __________________

• field and form

• fields and records

• datasheet and design

• record and form

To delete or rename a field in Microsoft Access, the first thing to do is _________

• Right click on the field

• Delete the field

• Double Click on the field

• Open the field

In Microsoft Access, a field labelled “Price” must be created as

• Currency

• Primary Key

• Number 

• Short Text

Which of these is not an example of a field type?

• Picture

• Short Text

• Date and Time

• Yes/No

1.   Data _____________ refers to ensuring accuracy and consistency of data.

• Integrity

• Collation

• Assessment

• System

• Quick Access Tool Bar
• Control Box
• Object Pane
• Ribbon

True or False: A database is a collection of data or information which is stored in a logical and structured way.

• False

• True

These are key objects in a database. They contain the data that is stored in the database and are made up of rows and columns.

• Table

• Report

• Query

• Form

A request for data results from a database or for action on the data.

• query

• table

• file

• record