TEST4U
Greek English German
  • Home Page
  • Shop
  • TEST4U Cloud
  • Contact
  • Greek English German

 

 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)

 

6629

Create a new query named sum_quantity to retrieve the sum of the quantities displayed in the Orders table. Use sum1 as name for the calculated field.

play video
6630

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)

play video
6632

Create a new query named pelpro that will display the Surname, Name, Description fields (in the above order) from the r_orders query. Make sure the pelpro query displays unique records.

play video

POLICY · TERMS OF USE · ABOUT · CONTACT

DOWNLOAD TEST4U

Pindou 655135, Thessaloniki, Greece

+30 2310 888 771

info (at) test4u.eu

B

infolearn © 2003 - 2025