|Total of questions: 228|
|Total of questions: 228|
|First steps (29 questions)|
|Settings (4 questions)|
|Basic Functions (14 questions)|
|Indexes (7 questions)|
|Table Design (24 questions)|
|Relationships (13 questions)|
|Forms (14 questions)|
|Main functions (13 questions)|
|Queries (22 questions)|
|Record sorting (4 questions)|
|Reports (9 questions)|
|Print Settings (11 questions)|
|Aggregate Queries (3 questions)|
|DIPLOMA level questions (1 question)|
|LibreOffice Base (BENCHMARK) (30 questions)|
|LibreOffice Base (ASSESSMENT) (30 questions)|
Among the LibreOffice applications which are open, terminate LibreOffice Base only.
Hide the Form Controls toolbar and show the Tools toolbar.
Delete the Movies table.
Go to the previous record.
Create a new table displaying the following fields:
1st field: Code,type of data: BigInt, PrimaryKey, AutoValue
2nd field: Name,type of data: Text [VARCHAR]
3rd field: Information, type of data: Memo.
Save the table as Names and close it.
Change the header text Customers Form of the open form to Partners and apply Times New Roman, 20pt, bold and italics font. Save and close the form.
Use the open form to enter a new record with the following data:
Description: All Time Classic
Save the record but do not close the form.
Search for the first record which contains the text wrong in the Notes field.
Open the FormProducts form and apply a filter to retrieve only the records which display a Description beginning with CLIFFORD. Do NOT close the form.
Insert the appropriate criteria in the current query so that it returns only the customers whose PC begins with 54. Save and close the query.
Modify the current query so that it displays the CName and PC fields only for the customers whose PC begins with 54. Save and close the query.
Create a new query that will use the Description and Price fields from the Products table and the FilePath field of the ProductsPhoto table. Apply a criterion to the FilePath field to retrieve all records containing a photo. Make sure that when the query is executed the Description and Price fields only (following this order) are displayed. Save the query as q1 and close it.
Apply sorting by Price in a descending order to the Products table. Close the table.
Save and close the report.
Print only the fifth page of the R_Products report to the default printer.
Create a new query named product_count to retrieve the total number of records displayed in the Products table. Use mycount as name for the calculated field. (use the ID field to meet the needs of the query)
Delete the relationship between the Products and Orders tables. Save the changes.
If you edit, organize and display _______ within a frame, the resulting output will be_______.
Who of the following can enter, preserve and retrieve data in a database?
A database consists of …
Which of the following are examples of database?
Which of the following structures would you use to export and analyze data?
Which of the following processes can be accelerated by the use of an Index?
Changing the length of a text field from 10 to 6 characters will …
Every field has associated properties like…
What are the referential integrity rules between related fields, assure us?
What is the purpose of creating a relationship between tables?
A report is used …
What is the fastest way of printing a report to the default printer?
Which of the following ways allows printing 10 copies of a report to the default printer?