Advanced Database Quiz The Place For Free Online Training Courses 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. To change the tab order of a form which icon/command must you select? Tab order Form order Entry order Activation order2. How do you concatenate fields in LibreOffice Base? Create a query and use the SQL statement || ‘ ‘ || Create a query and use the SQL statement MERGE Select 'merge fields' as an option in reports Select 'concatenate fields' as an option in reports3. To append records from one table to another using SQL you must… Use the statement INSERT specifying a table, followed by SELECT and FROM to choose fields from another table. Use the statement INSERT INTO, specifying a table, followed by SELECT and FROM to choose fields from another table. Use the statement APPEND, specifying a table, followed by SELECT and FROM to choose fields from another table. Use the statement INSERT INTO, specifying a table, followed by the other table name.4. If you link data from a spreadsheet to a database… data changed in the spreadsheet will be updated in the database data changed in the database will be updated in the spreadsheet workbooks added to the spreadsheet will add tables to the database all of the above5. When you create a junction table you must… create two primary keys and relate them to two other tables create on primary key that relates to two tables create two primary keys that relates to one other table create a primary and foreign key6. What is a 'combo box'? a way of entering data directly into a table a data entry box in a form that allows you to type or choose data from a menu a combination of a check box and a list box a box that combines data in a report7. Bound controls limit… what can be entered in a table what can be displayed in a report the results of a query what can be entered into a box in a form8. The '?' wildcard represents… one and only one character any number of characters the results of a query numerical characters only9. Which character do we use to designate a parameter in SQL? @ : v #10. When is an 'Alias' used in a query? to create a new field, often the result of two fields combined arithmetically to rename other fields that may clash between joined tables to ensure referential integrity between tables to hide fields that you don't want to be displayed in a query result11. How can use macros in a LibreOffice Base database? To modify forms To modify reports To add or delete records in a table To select objects in the main window12. How do you modify an existing relationship between two tables? Select modify relationships from the main window toolbar Press CTRL-e in the relationships window Right click the relationship line and select edit in the relationship window Double click the relationship line in the relationship window13. A relational database… uses a tree structure has tables that are linked together has no primary keys does not use SQL14. An input mask that uses: NaLAc stands for: Number, lower case letter, locked, upepr case letter, lower case character None, lower case letter, lower case character, upepr case letter, lower case character Number, letter, locked, letter, character Number, lower case character, letter, upper case character, criteria15. What does a 'subtract join' do? deletes records from a table links the primary keys of two tables returns results that are in one table, but not in the other subtracts a numerical values in one table from another16. What is a subform? A list of data that can be edited within a form A table that is displayed in a separate form A group of options within a form A form that automatically edits another form17. How can you make sure each grouped record appears on a new page in a report? Select properties for the 'Detail' section of the report and change 'Force new page' option to 'Before selection' Select properties for the 'Group' section of the report and change 'Force new page' option to 'Before selection' Select properties for the 'Group' section of the report and change 'Force new page' option to 'After selection' Select properties for the 'Header' section of the report and change 'Force new page' option to 'Before selection'18. What does the SQL statement INSERT do? Inserts a new relationship Inserts a field into a table Inserts an inner join between two tables Inserts a record into a table19. What is an 'option group' in a form? A group of options that can be selected from a drop-down menu A list of options that is selected by clicking radio buttons Grouped records within a form A list of options that can be selected in a combo box20. 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? Field List options Valuelist ValuesBe sure to click Submit Quiz to see your results! Name Email Time is Up!