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.
2. When you create a junction table you must…
5. What does the SQL statement INSERT do?
6. How do you concatenate fields in LibreOffice Base?
7. To append records from one table to another using SQL you must…
8. When is an 'Alias' used in a query?
9. How do you modify an existing relationship between two tables?
10. An input mask that uses: NaLAc stands for:
12. What does a 'subtract join' do?
18. How can you make sure each grouped record appears on a new page in a report?
20. If you link data from a spreadsheet to a database…
Comments
Advanced Database — No Comments
HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>