ACCESS EXAM 3 QUESTIONS AND
ANSWERS
Which uof uthe ufollowing uis ua ucollection uof udata uorganized uinto umeaningful uinformation
uto ube uused uin ua umeaningful uway? u- uCorrect uAnswer u- uDatabase
Which uof uthe ufollowing ubest udescribes uinformation? u- uCorrect uAnswer u- uInformation
uis uthe ufinal uproduct uthat uis uproduct uthat uis uproduced uby ua udatabase
Of uthe ufollowing, uwhich uis uNOT ua umain uobject utype uin uan uAccess udatabase? u-
uCorrect uAnswer u- urecord
A u____________ uis ua uquestion uyou uask uabout udata ustored uin ua udatabase. u- uCorrect
uAnswer u- uquery
The u____________ uview uin uAccess ulooks usimilar uto uan uExcel uspreadsheet. u- uCorrect
uAnswer u- uDatasheet
You ucan ucreate uor umodify ua utable's ufield unames uand udata utypes uin u___________
uview. u- uCorrect uAnswer u- uDesign
A uprimary ukey: u- uCorrect uAnswer u- umust ucontain ua uunique uvalue ufor ueach urecord
uwithin ua utable.
Access udiffers ufrom uother uMicrosoft usoftware ubecause uit: u- uCorrect uAnswer u- uworks
uprimarily ufrom ustorage.
You ucan uclick uthe u___________ ubutton uon uthe utable utoolbar uto usort urecords uin
ualphabetical uorder, ufrom uA uto uZ. u- uCorrect uAnswer u- uAscending uorder
When uyou uapply ua umultiple usort uin uAccess, ucolumns uare usorted: u- uCorrect uAnswer u-
ufrom uleft uto uright
Alice uis uworking uin ua udatabase ucontaining uthe unames, uservice ulocations, uand
uservices uoffered uby ulandscapers. uShe uneeds uto ufind ulandscapers uthat uoffer uservices
uin uthe uPhoenix uarea uand uthat uservice urare uplants. uThe ubest uway ufor uher uto usearch
ufor uthis udata uis uto uperform ua: u- uCorrect uAnswer u- uFilter uby uForm
Ryan uis uworking uin ua udatabase uthat uorganizes uvendor ucontact uinformation. uRyan
umust ufind uvendors ulocated uin uSeattle uand uPortland. uThe uvendors umust uhave uoffices
uin uboth ucities uin uorder uto umeet uRyan's urequirements. uHe ushould uuse uFilter uby uForm
u_________ ucondition. u- uCorrect uAnswer u- uAND
ANSWERS
Which uof uthe ufollowing uis ua ucollection uof udata uorganized uinto umeaningful uinformation
uto ube uused uin ua umeaningful uway? u- uCorrect uAnswer u- uDatabase
Which uof uthe ufollowing ubest udescribes uinformation? u- uCorrect uAnswer u- uInformation
uis uthe ufinal uproduct uthat uis uproduct uthat uis uproduced uby ua udatabase
Of uthe ufollowing, uwhich uis uNOT ua umain uobject utype uin uan uAccess udatabase? u-
uCorrect uAnswer u- urecord
A u____________ uis ua uquestion uyou uask uabout udata ustored uin ua udatabase. u- uCorrect
uAnswer u- uquery
The u____________ uview uin uAccess ulooks usimilar uto uan uExcel uspreadsheet. u- uCorrect
uAnswer u- uDatasheet
You ucan ucreate uor umodify ua utable's ufield unames uand udata utypes uin u___________
uview. u- uCorrect uAnswer u- uDesign
A uprimary ukey: u- uCorrect uAnswer u- umust ucontain ua uunique uvalue ufor ueach urecord
uwithin ua utable.
Access udiffers ufrom uother uMicrosoft usoftware ubecause uit: u- uCorrect uAnswer u- uworks
uprimarily ufrom ustorage.
You ucan uclick uthe u___________ ubutton uon uthe utable utoolbar uto usort urecords uin
ualphabetical uorder, ufrom uA uto uZ. u- uCorrect uAnswer u- uAscending uorder
When uyou uapply ua umultiple usort uin uAccess, ucolumns uare usorted: u- uCorrect uAnswer u-
ufrom uleft uto uright
Alice uis uworking uin ua udatabase ucontaining uthe unames, uservice ulocations, uand
uservices uoffered uby ulandscapers. uShe uneeds uto ufind ulandscapers uthat uoffer uservices
uin uthe uPhoenix uarea uand uthat uservice urare uplants. uThe ubest uway ufor uher uto usearch
ufor uthis udata uis uto uperform ua: u- uCorrect uAnswer u- uFilter uby uForm
Ryan uis uworking uin ua udatabase uthat uorganizes uvendor ucontact uinformation. uRyan
umust ufind uvendors ulocated uin uSeattle uand uPortland. uThe uvendors umust uhave uoffices
uin uboth ucities uin uorder uto umeet uRyan's urequirements. uHe ushould uuse uFilter uby uForm
u_________ ucondition. u- uCorrect uAnswer u- uAND
