BTEC National ICT U2 - Microsoft Access

In your database, information is stored in the ...

• Table

• Report

• Query

• Form

In a Table, a column is known as a ...

• Record

• Garden

• Field

• Stage

Records in a table can be updated any time.

• True

• False

Access offers different views of objects. Which view do you use to edit a table?

• Datasheet View

• Design View

• Table View

• Print View

In a Table, a row is known as a ...

• File

• Field

• Record

• Stage

Multiple tables that are related to each other is known as ...

• Access Database

• Relational Database

• Database Tables

• Informational Database

A database contains a Customer table. What would be stored in a record of the Customer table?

• Information about one customer

• Information about all the customers

• Information about one order

• Information about every order

Which of the following is an easy way to enter and browse data in a large database?

• Forms

• Tables

• Spreadsheets

• Records

What is data integrity?

• Maintaining and assuring accuracy and consistency of data in a database.

• Stores all the information for one item in a table.

• Stores information about one specific kind of item in a database.

• Forms are a way to view and browse information in a database.

A primary key field from one table appears in a second table. What is the field in the second table called?

• A primary key

• A foreign key

• A relationship key

• A linked key