Databases 3

A table is divided into __________________

• field and form

• fields and records

• datasheet and design

• record and form

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

• Primary Key

• Record

• Autonumber

• Field

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

I attempted to delete a relationship between two tables, but I got this error. How do I fix it?

• Close the open tables then try again

• Restart the computer

• Ask my friend whether they are using my database at the same time

• Close any conflicting programs

When establishing a relationship between two tables, how would you fix this error?

• Change the ArtistID data type in each table so they are both numbers

• Add an additional Artist ID field in another table

• Link both primary keys in each table

• Ensure that Enforce Referential Integrity is ticked.

In an Access database, information is stored as related...?

• Tables

• Reports

• Queries

• Forms

In a table, a column is also known as a...?

• Record

• Garden

• Field

• Stage