Information and Communication Technology

Question 1

1A query in Access is used to

Easy

A. find, filter and sort data that meets criteria B. enter new records only C. format pages D. draw charts

Question 2

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

Easy

Your answer (fill in the blank)

Question 3

3Queries store the original data.

Easy

A. True B. False

Question 4

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

Medium

A. add 50 to scores B. show only records with scores of 50 or more C. sort the scores D. delete those records

Question 5

5The data type best for a date of birth field is

Easy

A. Yes/No B. Short Text C. Date/Time D. Currency

Question 6

6The Relationships window in Access is used to

Medium

A. design forms only B. link tables through common fields C. change fonts D. print reports

Question 7

7A report is mainly used for printing formatted data.

Easy

A. True B. False

Question 8

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

Hard

Your answer (fill in the blank)

Question 9

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

Medium

A. True B. False

Question 10

10A report in Access is used to

Easy

A. present data in a formatted layout for printing B. type new data C. remove duplicates D. build the table structure