The document describes how to sort and filter data in a table in Microsoft Access. It explains that sorting arranges records in ascending or descending order based on a selected field. Filtering selects records that meet certain criteria. The steps provided include selecting the field to sort/filter on, choosing the sort/filter option, and applying or removing the filter. Examples are given of sorting and filtering a practice table by country, year, team name, and other fields.
The document describes how to sort and filter data in a table in Microsoft Access. It explains that sorting arranges records in ascending or descending order based on a selected field. Filtering selects records that meet certain criteria. The steps provided include selecting the field to sort/filter on, choosing the sort/filter option, and applying or removing the filter. Examples are given of sorting and filtering a practice table by country, year, team name, and other fields.
The document describes how to sort and filter data in a table in Microsoft Access. It explains that sorting arranges records in ascending or descending order based on a selected field. Filtering selects records that meet certain criteria. The steps provided include selecting the field to sort/filter on, choosing the sort/filter option, and applying or removing the filter. Examples are given of sorting and filtering a practice table by country, year, team name, and other fields.
The document describes how to sort and filter data in a table in Microsoft Access. It explains that sorting arranges records in ascending or descending order based on a selected field. Filtering selects records that meet certain criteria. The steps provided include selecting the field to sort/filter on, choosing the sort/filter option, and applying or removing the filter. Examples are given of sorting and filtering a practice table by country, year, team name, and other fields.
Download as DOC, PDF, TXT or read online from Scribd
Download as doc, pdf, or txt
You are on page 1of 1
SORTIRANJE PODATAKA U TABELI (ong i veba)
Sortiranje je postupak uredjivanja zapisa po odredjeno redos!edu" Redos!ed o#e $iti%
As&endin' (rastu)i* i Des&endin' (opadaju)i* Postupak: - selektovati eljeno polje sa podacima - meni Record opcija Sort Sort Ascending ili Sort Descending ili bre - dugme u oolbar-u able Datas!eet (Ascending) ili (Descending) *komande isprobati na ranije kreiranoj tabeli +ILTRIRANJE PODATAKA U TABELI (ong i veba) +i!triranje je postupak izdvajanja zapisa koji zadovo!javaju neki us!ov" Prienjuje se nad poda&ia u ta$e!i i o$ras&ia" Postupak: - i"abrati tabelu i pre#i u pogled na podatke (Datas!eet $ie%) - i"abrati podatak u polju - eni Re&ord opcija &ilter &ilter b' &orm (i" padaju#e liste i"abrati eljeni uslov pa dugme Appl' &ilter - &ilter b' Selection (i"abrati podatak pa "adati komandu) - &ilter ()cluding Selection (prika"uje sve osim i"abranog podatka) - Advanced &ilter (postavljanje posebni! uslova pomo#u dokera *+, i operatora) - desni k!ik na i"abrani podatak &ilter &or (i"bor podataka pod uslovom) - du'e iz Too!$ara - &ilter b' Selection+ &ilter b' &orm+ Uk!anjanje ,i!tera: - meni Record opcija Remove &ilter+ - desni klik - opcija Remove &ilter - dugme Appl'-Remove &ilter *komande isprobati na ranije kreiranoj tabeli -E.BA% ./ 0a tvom ra1unaru u 2' Documents u 3olderu Sanja nala"i se 3ajl veba &ilter/ 4ve"i je u Access+ uredi i koristi "a naredne "adatke/ 5/ 4redi "apise u rastu#em poretku prema polju Drave 6/ Poredjaj godine u opadaju#i poredak 7/ Prikai prvake i" 8ra"ila 9/ Prikai prvake i" ekipe &erari :/ Prikai sve prvake osim prvaka i" $el/ 8ritanije+ ;/ Prikai sve prvake osim prvaka i" ekipe 2eklaren+ </ Prikai prvake od .==> naovamo+ =/ Prikai sve prvake od .=:> do .=;> .>/ Prikai ekipe na slovo &+ ../ Prikai prvake i" 8ra"ila posle .=<>/ god/ .5/ Prikai prvake ekipe $ilijams od .=<> do 5>>>/ god