NEW
Font size
WorksheetsBTEC National ICT U2 - Microsoft Access
Total questions: 10
Worksheet time: 32mins
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
