Advanced Database 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. 

A relational database…

2. 

What is a 'combo box'?

3. 

An input mask that uses: NaLAc stands for:

4. 

To change the tab order of a form which icon/command must you select?

5. 

How do you modify an existing relationship between two tables?

6. 

When you create a junction table you must…

7. 

What does a 'subtract join' do?

8. 

What does the SQL statement INSERT do?

9. 

To append records from one table to another using SQL you must…

10. 

Which character do we use to designate a parameter in SQL?

11. 

The '?' wildcard represents…

12. 

When is an 'Alias' used in a query?

13. 

Bound controls limit…

14. 

If we want to create a list of options that can be selected for a list box, what do we select for the 'Type of list contents' in the control properties?

15. 

What is an 'option group' in a form?

16. 

What is a subform?

17. 

How do you concatenate fields in LibreOffice Base?

18. 

How can you make sure each grouped record appears on a new page in a report?

19. 

If you link data from a spreadsheet to a database…

20. 

How can use macros in a LibreOffice Base database?

Be sure to click Submit Quiz to see your results!

Name
Email