Database applications: tables, forms, queries and reports

Question 1 of 10

In an Access query, the criteria >=50 under the Score field will

Question 2 of 10

The AutoNumber data type

Question 3 of 10

A validation rule can reject a mark of 150 if the rule is Between 0 And 100.

Question 4 of 10

The Relationships window in Access is used to

Question 5 of 10

Explain validation rules and input masks, with an example of each.

Question 6 of 10

In Access, the view used to set field names and data types is

Question 7 of 10

Which object would you create to print a list of pupils grouped by class?

Question 8 of 10

Referential integrity allows records that refer to non-existent records.

Question 9 of 10

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

Question 10 of 10

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