Manipulate Data
Muhtasari
A database is only as useful as the questions you can ask of it. A garage with three hundred cars in stock does not want to scroll through every row; it wants to see, in one click, only the Fords under $4000, sorted from cheapest to dearest, with the profit on each one worked out automatically. That is what manipulating data means: searching, sorting and calculating so the right information rises to the surface.
In this lesson you will learn to write queries that select exactly the records you want using the operators AND, OR, NOT and the comparisons such as greater than and less than, and to search inside text using wildcards. You will sort data into ascending or descending order on one or more fields, and create calculated fields and summaries that compute totals and averages at run time. These are core skills of the practical database papers.
Malengo
- Perform calculations.
- Use arithmetic operations or numeric functions to perform calculations including calculated fields, calculated controls Use formulae and functions to perform calculations at run time including addition, subtraction, multiplication, division, sum, average, maximum, minimum, count.
- Sort data.
- Use a single criterion, or multiple criteria to sort data into ascending or descending order.
- Search and select data.
- Use a single criterion, or multiple criteria to select subsets of data using a query perform searches using a variety of operators including AND, OR, NOT, LIKE, >, <, =, >=, <=, <> perform searches using wildcards.
Maelezo ya Somo
Inapatikana kwenye programu ya Green Bridge
Pakua programu ya Green Bridge CBT kwenye simu yako au kompyuta yako ili kupata maelezo kamili ya masomo, maswali ya mazoezi, na mengi zaidi.
Tathmini ya Somo
Hongera kwa kukamilisha somo la Manipulate Data. Sasa kwa kuwa umechunguza dhana na mawazo muhimu, ni wakati wa kuweka ujuzi wako kwa mtihani. Sehemu hii inatoa mazoezi mbalimbali maswali yaliyoundwa ili kuimarisha uelewaji wako na kukusaidia kupima ufahamu wako wa nyenzo.
Utakutana na mchanganyiko wa aina mbalimbali za maswali, ikiwemo maswali ya kuchagua jibu sahihi, maswali ya majibu mafupi, na maswali ya insha. Kila swali limebuniwa kwa umakini ili kupima vipengele tofauti vya maarifa yako na ujuzi wa kufikiri kwa makini.
Tumia sehemu hii ya tathmini kama fursa ya kuimarisha uelewa wako wa mada na kubaini maeneo yoyote ambapo unaweza kuhitaji kusoma zaidi. Usikatishwe tamaa na changamoto zozote utakazokutana nazo; badala yake, zitazame kama fursa za kukua na kuboresha.
- Which logical operator returns records only when every condition is true? A. OR B. NOT C. AND D. LIKE Answer: C
- The criterion >=10 placed in a Quantity field selects records where the quantity is: A. less than 10 B. exactly 10 only C. 10 or more D. less than or equal to 10 Answer: C
- Which search would find all colours that begin with the letters Bl? A. *Bl B. Bl* C. *Bl* D. =Bl Answer: B
- A new field defined as Profit: [SPrice] - [PPrice] is an example of a: A. Primary key B. Validation rule C. Calculated field D. Foreign key Answer: C
- Which function returns the number of records in a group? A. SUM B. AVG C. MAX D. COUNT Answer: D
Inapatikana kwenye programu ya Green Bridge
Pakua programu ya Green Bridge CBT kwenye simu yako au kompyuta yako ili kupata maelezo kamili ya masomo, maswali ya mazoezi, na mengi zaidi.
Inapatikana kwenye programu ya Green Bridge
Pakua programu ya Green Bridge CBT kwenye simu yako au kompyuta yako ili kupata maelezo kamili ya masomo, maswali ya mazoezi, na mengi zaidi.
Vitabu Vinavyopendekezwa
Fanya Mazoezi ya Maswali ya Majaribio
Ungependa kufanya mazoezi ya maswali ya majaribio kuhusu Manipulate Data? Pakua programu ya Green Bridge CBT ili kupata maswali ya majaribio na tathmini kamili za mazoezi kuhusu mada hii.
Pakua Programu Kwenye Google Playstore
Kila kitu unachohitaji ili kufaulu katika JAMB, WAEC & NECO.
