Understanding Databases Quiz

This quiz is designed to test your knowledge of the contents of the Understanding Databases Course, part of the Office Software Suite series. These quizzes are designed to improve your database skills.

There are twenty questions. The pass mark is 70 out of a potential 100 points, 5 for each question.

Once you are satisfied with your answers, complete your name and email address and select “Submit Quiz“ to have your answers marked.

You will shortly receive an email advising you of your score, whether you have passed the quiz, and how your answers have been scored. It will also include your Free Online Training course quiz completion Certificate for the appropriate quiz.

1. 

The unique identifying field that must be set in each database table is called the…

2. 

To generate whole numbers automatically in a table, what must you select from 'field type' and 'field properties'?

3. 

After you have saved a table for the first time in Base, you can add fields in-between existing ones by right clicking and selecting 'insert'

4. 

When filtering records, if you select <= 40 it will return values that are..

5. 

What is the keyboard shortcut to run a query?

6. 

What symbols do you use in a function or formula to represent 'not equal to'?

7. 

When creating a relationship, when would you select 'update cascade'?

8. 

If you use criterion =25 in a query, which set of values for that field could possibly be returned from the following?

9. 

In a form, if you change the data it will automatically update the table without selecting save?

10. 

What word(s) could be returned from a query that used the criterion "LIKE No?" from the following?

11. 

What does a database administrator do?

12. 

What is the purpose of a database report ?

13. 

Why would you want to use a grouped report?

14. 

To export data from a table or query you have to select records, copy, then paste into Calc or Writer..

15. 

To add records to an existing table you should…

16. 

If you want to report the average amounts of a field you should…

17. 

The label field is…

18. 

To change the orientation of a report or exported table or query, you should…

19. 

To hide or unhide fields in a query you check or uncheck the 'Visible' box…

20. 

The keyboard shortcut to close a query that you have previously run is…

Be sure to click Submit Quiz to see your results!

Name
Email