Database applications: tables, forms, queries and reports

Question 1 of 10

Explain why relationships are created between tables in a database, using Pupils and Payments tables as an example.

Question 2 of 10

AutoNumber gives each record a unique number.

Question 3 of 10

A pattern that controls how data is typed in, like a phone number, is an input ___.

Question 4 of 10

In a query, the criteria Like "A*" under Name finds names that

Question 5 of 10

Microsoft Access is an example of

Question 6 of 10

A database object used to print formatted data is a ___.

Question 7 of 10

The Relationships window in Access is used to

Question 8 of 10

An input mask is used to

Question 9 of 10

The data type best for "Has paid fees" is

Question 10 of 10

Design an Access table for a school library with six fields, their data types and the primary key.