CSCI Microsoft Access with correct
answers 2026
WhichvofvthevfollowingvisvanvexamplevofvanvAccessvobject?-Form
Wherevisvthevdatavinvavdatabasevstored?-Table
YouveditvseveralvrecordsvinvanvAccessvtable.vWhenvshouldvyouvexecutevthevSavevcommand?vvcorr
ectvanswers-Recordsvarevsavedvautomatically;vthevsavevcommandvisvnotvrequired
WhichvofvthevfollowingvisvNOTvtruevofvanvAccessvdatabase?v-
vcorrectvanswersEveryvtablevinvavdatabasevcontainsvthevsamevnumbervofvrecordsvasveveryvothervt
able
Whichvofvthevfollowingvisvtruevregardingvtablevviews?-
,ChangesvmadevinvDatasheetvviewvarevautomaticallyvsavedvwhenvyouvmovevthevinsertionvpointvtov
a vdifferentvrecord
Whichvofvthevfollowingvutilitiesvisvusedvtovrecovervinvtheveventvofvavlossvorvdamage?vvcorrectvan
swers-BackvUpvDatabases
WhichvofvthevfollowingvwouldvbevmatchedvifvyouvusevavSelectionvfilter'svexactvmatchvoptionvforvt
he vnamevAnn?-Ann,vANN,vandvann
WhichvofvthevfollowingvconditionsvisvavailablevthroughvavSelectionvfilter?v-
vcorrectvanswersEqualvcondition
Allvofvthevfollowingvstatementsvarevtruevaboutvcreatingvavdatabasevexcept:v-
vcorrectvanswersThevobjectsvprovidedvinvavtemplatevcannotvbevmodified
Tovaddvavpredefinedvtablevtovanvexistingvdatabase,vyouvshouldvusevwhichvofvthevfollowing?vvcorr
ectvanswers-Applicationvpart
SelectionvFilter-
Avfilteringvmethodvthatvdisplaysvonlyvrecordsvthatvmatchvselectedvcriteria.
Filtervbyvform-
Avfilteringvmethodvthatvdisplaysvrecordsvbasedvonvmultiplevcriteria.
Object-
Avmainvcomponentvthatvisvcreatedvandvusedvtovmakevavdatabasevfunction,vsuchvasvavtablevorvfor
m.
Sort-Avmethodvofvlistingvrecordsvinvavspecificvsequencev(suchvasvalphabetically).
Template-
Avpredefinedvdatabasevthatvincludesvprofessionallyvdesignedvtables,vforms,vreports,vandvothervobj
ects.
,Query-Avquestionvyouvaskvaboutvthevdatavinvyourvdatabase.
Navigationvpane-
AnvAccessvinterfacevelementvthatvorganizesvandvlistsvdatabasevobjectsvinvavdatabase.
Form-
AnvAccessvobjectvthatvsimplifiesventering,vmodifying,vandvdeletingvtablevdata.
Applicationvpart-
AvsetvofvcommonvAccessvcomponentsvthatvcanvbevaddedvtovanvexistingvdatabase.
Report-
Anvobjectvthatvcontainsvprofessionallookingvformattedvinformationvfromvunderlyingvtablesvorvqueri
es.
Table-Anvobjectvusedvtovstorevdata,vorganizingvdatavintovcolumnsvandvrows.
Record-
Completevsetvofvallvthevfieldsvaboutvonevperson,vplace,vevent,vorvconcept.
Primaryvkey-
Thevfieldv(orvcombinationvofvfields)vthatvuniquelyvidentifiesveachvrecordvinvavtable.
Designvview-Viewvthatvenablesvyouvtovcreatevandvmodifyvavtablevdesign.
Database-
Avcollectionvofvdatavorganizedvasvmeaningfulvinformationvthatvcanvbevaccessed,vmanaged,vstored,
v queried,vsorted,vandvreported.
Relationship-Avconnectionvbetweenvtwovtablesvusingvavcommonvfield.
, Datasheetvview-
Avgridvthatvenablesvyouvtovadd,vedit,vandvdeletevthevrecordsvofvavtable.
Field-Avpiecevofvinformationvstoredvinvavtable,vsuchvasvavcompanyvnamevorvcity.
DatabasevManagementvSystemv(DBMS)CorrectvAnswer-
Avsoftwarevsystemvthatvprovidesvthevtoolsvneededvtovcreate,vmaintain,vandvusevavdatabase
Filter-
Enablesvyouvtovspecifyvconditionsvtovdisplayvonlyvthosevrecordsvthatvmeetvcertainvconditions.
Allvofvthevfollowingvarevsuggestedvguidelinesvforvtablevdesignvexcept:v-
vcorrectvanswersAvoidvdatevarithmetic.
Whichvofvthevfollowingvdeterminesvhowvthevfieldvnamesvcanvbevmadevmorevreadablevinvtablevan
dv queryvdatasheets?-Captionvproperty
Whenventering,vdeleting,vorveditingvinputvmasks:v-
vcorrectvanswersThevtablevmustvbevinvDesignvview.
WithvrespectvtovimportingvdatavintovAccess,vwhichvofvthevfollowingvstatementsvisvtrue?vvcorrectva
nswers-YouvcanvassignvavprimaryvkeyvwhilevyouvarevimportingvExcelvdata.
ThevmainvreasonvtovsetvavfieldvsizevinvAccessvisvto:v-
vcorrectvanswersLimitvthevlengthvofvvaluesvinvavtable.
Anvillustrationvofvavone-to-manyvrelationshipvwouldvbe:-
Avcustomervmayvhavevmorevthanvonevaccountvinvanvaccountsvtable
Avquery'svspecificationsvasvtovwhichvtablesvtovincludevmustvbeventeredvonvthe:v-
vcorrectvanswersTablevrowvofvthevqueryvdesignvgrid
answers 2026
WhichvofvthevfollowingvisvanvexamplevofvanvAccessvobject?-Form
Wherevisvthevdatavinvavdatabasevstored?-Table
YouveditvseveralvrecordsvinvanvAccessvtable.vWhenvshouldvyouvexecutevthevSavevcommand?vvcorr
ectvanswers-Recordsvarevsavedvautomatically;vthevsavevcommandvisvnotvrequired
WhichvofvthevfollowingvisvNOTvtruevofvanvAccessvdatabase?v-
vcorrectvanswersEveryvtablevinvavdatabasevcontainsvthevsamevnumbervofvrecordsvasveveryvothervt
able
Whichvofvthevfollowingvisvtruevregardingvtablevviews?-
,ChangesvmadevinvDatasheetvviewvarevautomaticallyvsavedvwhenvyouvmovevthevinsertionvpointvtov
a vdifferentvrecord
Whichvofvthevfollowingvutilitiesvisvusedvtovrecovervinvtheveventvofvavlossvorvdamage?vvcorrectvan
swers-BackvUpvDatabases
WhichvofvthevfollowingvwouldvbevmatchedvifvyouvusevavSelectionvfilter'svexactvmatchvoptionvforvt
he vnamevAnn?-Ann,vANN,vandvann
WhichvofvthevfollowingvconditionsvisvavailablevthroughvavSelectionvfilter?v-
vcorrectvanswersEqualvcondition
Allvofvthevfollowingvstatementsvarevtruevaboutvcreatingvavdatabasevexcept:v-
vcorrectvanswersThevobjectsvprovidedvinvavtemplatevcannotvbevmodified
Tovaddvavpredefinedvtablevtovanvexistingvdatabase,vyouvshouldvusevwhichvofvthevfollowing?vvcorr
ectvanswers-Applicationvpart
SelectionvFilter-
Avfilteringvmethodvthatvdisplaysvonlyvrecordsvthatvmatchvselectedvcriteria.
Filtervbyvform-
Avfilteringvmethodvthatvdisplaysvrecordsvbasedvonvmultiplevcriteria.
Object-
Avmainvcomponentvthatvisvcreatedvandvusedvtovmakevavdatabasevfunction,vsuchvasvavtablevorvfor
m.
Sort-Avmethodvofvlistingvrecordsvinvavspecificvsequencev(suchvasvalphabetically).
Template-
Avpredefinedvdatabasevthatvincludesvprofessionallyvdesignedvtables,vforms,vreports,vandvothervobj
ects.
,Query-Avquestionvyouvaskvaboutvthevdatavinvyourvdatabase.
Navigationvpane-
AnvAccessvinterfacevelementvthatvorganizesvandvlistsvdatabasevobjectsvinvavdatabase.
Form-
AnvAccessvobjectvthatvsimplifiesventering,vmodifying,vandvdeletingvtablevdata.
Applicationvpart-
AvsetvofvcommonvAccessvcomponentsvthatvcanvbevaddedvtovanvexistingvdatabase.
Report-
Anvobjectvthatvcontainsvprofessionallookingvformattedvinformationvfromvunderlyingvtablesvorvqueri
es.
Table-Anvobjectvusedvtovstorevdata,vorganizingvdatavintovcolumnsvandvrows.
Record-
Completevsetvofvallvthevfieldsvaboutvonevperson,vplace,vevent,vorvconcept.
Primaryvkey-
Thevfieldv(orvcombinationvofvfields)vthatvuniquelyvidentifiesveachvrecordvinvavtable.
Designvview-Viewvthatvenablesvyouvtovcreatevandvmodifyvavtablevdesign.
Database-
Avcollectionvofvdatavorganizedvasvmeaningfulvinformationvthatvcanvbevaccessed,vmanaged,vstored,
v queried,vsorted,vandvreported.
Relationship-Avconnectionvbetweenvtwovtablesvusingvavcommonvfield.
, Datasheetvview-
Avgridvthatvenablesvyouvtovadd,vedit,vandvdeletevthevrecordsvofvavtable.
Field-Avpiecevofvinformationvstoredvinvavtable,vsuchvasvavcompanyvnamevorvcity.
DatabasevManagementvSystemv(DBMS)CorrectvAnswer-
Avsoftwarevsystemvthatvprovidesvthevtoolsvneededvtovcreate,vmaintain,vandvusevavdatabase
Filter-
Enablesvyouvtovspecifyvconditionsvtovdisplayvonlyvthosevrecordsvthatvmeetvcertainvconditions.
Allvofvthevfollowingvarevsuggestedvguidelinesvforvtablevdesignvexcept:v-
vcorrectvanswersAvoidvdatevarithmetic.
Whichvofvthevfollowingvdeterminesvhowvthevfieldvnamesvcanvbevmadevmorevreadablevinvtablevan
dv queryvdatasheets?-Captionvproperty
Whenventering,vdeleting,vorveditingvinputvmasks:v-
vcorrectvanswersThevtablevmustvbevinvDesignvview.
WithvrespectvtovimportingvdatavintovAccess,vwhichvofvthevfollowingvstatementsvisvtrue?vvcorrectva
nswers-YouvcanvassignvavprimaryvkeyvwhilevyouvarevimportingvExcelvdata.
ThevmainvreasonvtovsetvavfieldvsizevinvAccessvisvto:v-
vcorrectvanswersLimitvthevlengthvofvvaluesvinvavtable.
Anvillustrationvofvavone-to-manyvrelationshipvwouldvbe:-
Avcustomervmayvhavevmorevthanvonevaccountvinvanvaccountsvtable
Avquery'svspecificationsvasvtovwhichvtablesvtovincludevmustvbeventeredvonvthe:v-
vcorrectvanswersTablevrowvofvthevqueryvdesignvgrid
