Manipulate Data
Gbogbo ọrọ náà
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.
Ebumnobi
- 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.
Akọmọ Ojú-ẹkọ
Ọ dị na ngwa Green Bridge
Budata ngwa Green Bridge CBT na ekwentị maọbụ kọmputa gị iji nweta akwụkwọ ndụmọdụ zuru oke, ajụjụ mmụta, na ndị ọzọ.
Ayẹwo Ẹkọ
Ekele diri gi maka imecha ihe karịrị na Manipulate Data. Ugbu a na ị na-enyochakwa isi echiche na echiche ndị dị mkpa, ọ bụ oge iji nwalee ihe ị ma. Ngwa a na-enye ụdị ajụjụ ọmụmụ dị iche iche emebere iji kwado nghọta gị wee nyere gị aka ịmata otú ị ghọtara ihe ndị a kụziri.
Ị ga-ahụ ngwakọta nke ụdị ajụjụ dị iche iche, gụnyere ajụjụ chọrọ ịhọrọ otu n’ime ọtụtụ azịza, ajụjụ chọrọ mkpirisi azịza, na ajụjụ ede ede. A na-arụpụta ajụjụ ọ bụla nke ọma iji nwalee akụkụ dị iche iche nke ihe ọmụma gị na nkà nke ịtụgharị uche.
Jiri akụkụ a nke nyocha ka ohere iji kụziere ihe ị matara banyere isiokwu ahụ ma chọpụta ebe ọ bụla ị nwere ike ịchọ ọmụmụ ihe ọzọ. Ekwela ka nsogbu ọ bụla ị na-eche ihu mee ka ị daa mba; kama, lee ha anya dị ka ohere maka ịzụlite onwe gị na imeziwanye.
- 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
Ọ dị na ngwa Green Bridge
Budata ngwa Green Bridge CBT na ekwentị maọbụ kọmputa gị iji nweta akwụkwọ ndụmọdụ zuru oke, ajụjụ mmụta, na ndị ọzọ.
Ọ dị na ngwa Green Bridge
Budata ngwa Green Bridge CBT na ekwentị maọbụ kọmputa gị iji nweta akwụkwọ ndụmọdụ zuru oke, ajụjụ mmụta, na ndị ọzọ.
Àwọn Ìwé Tó Dáa Láti Kà
Meecha Ajụjụ Ule Ọmarịcha
Ị chọrọ ime ajụjụ ule ọmarịcha gbasara Manipulate Data? Budata ngwa Green Bridge CBT iji nweta ajụjụ ule ọmarịcha na nyocha zuru ezu gbasara isiokwu a.
Dawunlodi Ẹpp naa lori Google Playstore.
Ihe nile ichoro iji nwee ihe ịga nke ọma na JAMB, WAEC & NECO.
