Access with correct answers 2026
Whichvtypevofvdatabasevconsistsvofvavcollectionvofvtables,veachvofvwhichvinformationvonvavspecifi
cvs ubject?vgrelational
Curtvneedsvtovcreatevavbackupvtovhisvexistingvdatabasevonvanvexternalvhardvdrive.vWhatvactionvs
ho uldvhevtake?vgsavevas
Susievwantsvtovlocatevthevfilevnamevofvhervcurrentvdocument.vWherevshouldvshevlook?vgtitlevbar
Erinvneedsvtovpreparevavcustomvtablevforvhervrecipevcollection.vShevhasvtovincludevthevingredient
vp ortions.vWhichvisvthevcorrectvtoolvtovuse?vgdesignvview
Juanvisvcreatingvavnewvdatabase.vHevwantsvtovassignvfieldvnames.vWhichvviewvisvthevbestvtovcrea
tev thevnewvdatabase?vgdesignvview
MattvneedsvtovaddvhisvcontactsvtovthevDrivervEducationvDatabase.vTovdovthisvquickly,vwhatvprede
fi nedvobjectvcanvhevcreate?vgapplicationvparts
WherevisvthevcommandvforvcreatingvavnewvtablevfromvTablevDesignvview?vgcreatevribbon
,AnvaddressvbookvcontainingvallvFBLAvmembersvwouldvbevanvexamplevofva:vgdatabase
Whenvavdatabasevisvcreated,vwhatvisvdefinedvwhenvnamesvandvdatavtypesvarevassignedvtovallvdat
avf ieldsvinvavtable?vgstructure
YouvhavevbeenvaskedvtovdevelopvanvaddressvbookvforvthevFBLAvmember.vLastvnamevandvfirstvna
mev wouldvbevexamplesvof:vgfields
Juanvneedsvtovviewvandvaccessvallvpartsvofvhisvdatabase.vWherevcanvthesevobjectsvbevlocatedvmo
stv efficiently?vgnavigationvpane
NickvwantsvtovdesignvavdatabasevandvwantsvAccessvtovautomaticallyvassignvanvIDvnumbervtoveach
vr ecord.vWhatvdatavtypevshouldvhevuse?vgautovnumber
Whichvviewvdisplaysvthevareavusedvtovcreatevavtablevorvtovmodifyvthevstructurevofvavtable?vgdesi
gn
WhatvarevthreevvalidvmethodsvforvsavingvavdatabasevinvMicrosoftvAccess?vgCtrlv+vs,vfilevtabvsave
vcommand,vquickvaccessvsavevcommand
Nickvwantsvtovimmediatelyvopenvanvemployees'vemailvfromvhisvdatabase.vWhatvdatavtypevshouldv
b evusedvforvthevemailvaddress?vghyperlink
NickvwantsvtovdesignvavdatabasevandvwantsvAccessvtovautomaticallyvassignvanvIDvnumbervtoveach
vr ecord.vWhatvisvautovnumberingvanvexamplevof?vgdatavtype
Whichvtermvrefersvtovavstoringvthevsamevfieldvinvmorevthanvonevlocationvinvavdatabase?vgredund
ancy
Whichvsoftwarevprogramvisvusedvtovcreatevavdatabasevonvavcomputer,vadd,vchange,vandvdeletevd
at
, avinvthevdatabase,vandvcreatevqueries,vforms,vandvreportsvusingvthevdatavinvthevdatabase?vgMicr
osoftvaccess
Curtvneedsvtovfinishvavdatabasevprojectvfromvyesterday.vWhatvactionvshouldvhevtakevinvordervtov
sta rtvworkingvonvthevdatabase?vgopen
Whatvtypevofvdatabasevcontainsvmultiplevcollectionsvofvdatavthatvarevrelatedvtovonevanother?vgre
lational
WhichvareavappearsvonvthevleftvsidevofvMicrosoftvAccessvwindowsvandvdisplaysvavlistvofvobjectsva
va ilablevinvthevdatabase?vgnavigationvpane
WhenvsavingvavMicrosoftvAccessvdatabasevasvanothervfilevtype,vwhichvribbonvcontainsvanvareavof
vc entralizedvtasksvthatvarevrelatedvtovfilevmanagementvknownvasvthevbackstage?vgfilevtab
IndividualventriesvinvthevFBLAvaddressvbookvwouldvbeventeredvintova:vgcell
Curtvneedsvtovexitvhisvdatabasevinvordervtovworkvonvanothervdatabase.vWhatvactionvshouldvhevta
ke vaftervsavingvhisvwork?vgclose
Jennyvisvsettingvthevaddressvforveachvpatient.vWhichvdatavtypevshouldvshevuse?vgtext
IsabelvwantsvtovdesignvavdatabasevforvhervFBLAvclubvtovincludevallvthevmembers'vinformation.vW
ha tvdatavtypevshouldvshevusevforvLastvname?vgtext
Johnnyvhasvplannedvhisvbaseballvcardvdatabasevandvdeterminedvavlogicalvarrangement.vWhatvisvhi
svnextvstep?vggathervthevinformation
Whichvtypevofvrelationshipvmeansvthatvavrecordvinvthevfirstvtablevisvrelatedvorvmatchesvmorevtha
nv onevrecordvinvthevsecondvtable?vgonevtovmany
Whichvtypevofvdatabasevconsistsvofvavcollectionvofvtables,veachvofvwhichvinformationvonvavspecifi
cvs ubject?vgrelational
Curtvneedsvtovcreatevavbackupvtovhisvexistingvdatabasevonvanvexternalvhardvdrive.vWhatvactionvs
ho uldvhevtake?vgsavevas
Susievwantsvtovlocatevthevfilevnamevofvhervcurrentvdocument.vWherevshouldvshevlook?vgtitlevbar
Erinvneedsvtovpreparevavcustomvtablevforvhervrecipevcollection.vShevhasvtovincludevthevingredient
vp ortions.vWhichvisvthevcorrectvtoolvtovuse?vgdesignvview
Juanvisvcreatingvavnewvdatabase.vHevwantsvtovassignvfieldvnames.vWhichvviewvisvthevbestvtovcrea
tev thevnewvdatabase?vgdesignvview
MattvneedsvtovaddvhisvcontactsvtovthevDrivervEducationvDatabase.vTovdovthisvquickly,vwhatvprede
fi nedvobjectvcanvhevcreate?vgapplicationvparts
WherevisvthevcommandvforvcreatingvavnewvtablevfromvTablevDesignvview?vgcreatevribbon
,AnvaddressvbookvcontainingvallvFBLAvmembersvwouldvbevanvexamplevofva:vgdatabase
Whenvavdatabasevisvcreated,vwhatvisvdefinedvwhenvnamesvandvdatavtypesvarevassignedvtovallvdat
avf ieldsvinvavtable?vgstructure
YouvhavevbeenvaskedvtovdevelopvanvaddressvbookvforvthevFBLAvmember.vLastvnamevandvfirstvna
mev wouldvbevexamplesvof:vgfields
Juanvneedsvtovviewvandvaccessvallvpartsvofvhisvdatabase.vWherevcanvthesevobjectsvbevlocatedvmo
stv efficiently?vgnavigationvpane
NickvwantsvtovdesignvavdatabasevandvwantsvAccessvtovautomaticallyvassignvanvIDvnumbervtoveach
vr ecord.vWhatvdatavtypevshouldvhevuse?vgautovnumber
Whichvviewvdisplaysvthevareavusedvtovcreatevavtablevorvtovmodifyvthevstructurevofvavtable?vgdesi
gn
WhatvarevthreevvalidvmethodsvforvsavingvavdatabasevinvMicrosoftvAccess?vgCtrlv+vs,vfilevtabvsave
vcommand,vquickvaccessvsavevcommand
Nickvwantsvtovimmediatelyvopenvanvemployees'vemailvfromvhisvdatabase.vWhatvdatavtypevshouldv
b evusedvforvthevemailvaddress?vghyperlink
NickvwantsvtovdesignvavdatabasevandvwantsvAccessvtovautomaticallyvassignvanvIDvnumbervtoveach
vr ecord.vWhatvisvautovnumberingvanvexamplevof?vgdatavtype
Whichvtermvrefersvtovavstoringvthevsamevfieldvinvmorevthanvonevlocationvinvavdatabase?vgredund
ancy
Whichvsoftwarevprogramvisvusedvtovcreatevavdatabasevonvavcomputer,vadd,vchange,vandvdeletevd
at
, avinvthevdatabase,vandvcreatevqueries,vforms,vandvreportsvusingvthevdatavinvthevdatabase?vgMicr
osoftvaccess
Curtvneedsvtovfinishvavdatabasevprojectvfromvyesterday.vWhatvactionvshouldvhevtakevinvordervtov
sta rtvworkingvonvthevdatabase?vgopen
Whatvtypevofvdatabasevcontainsvmultiplevcollectionsvofvdatavthatvarevrelatedvtovonevanother?vgre
lational
WhichvareavappearsvonvthevleftvsidevofvMicrosoftvAccessvwindowsvandvdisplaysvavlistvofvobjectsva
va ilablevinvthevdatabase?vgnavigationvpane
WhenvsavingvavMicrosoftvAccessvdatabasevasvanothervfilevtype,vwhichvribbonvcontainsvanvareavof
vc entralizedvtasksvthatvarevrelatedvtovfilevmanagementvknownvasvthevbackstage?vgfilevtab
IndividualventriesvinvthevFBLAvaddressvbookvwouldvbeventeredvintova:vgcell
Curtvneedsvtovexitvhisvdatabasevinvordervtovworkvonvanothervdatabase.vWhatvactionvshouldvhevta
ke vaftervsavingvhisvwork?vgclose
Jennyvisvsettingvthevaddressvforveachvpatient.vWhichvdatavtypevshouldvshevuse?vgtext
IsabelvwantsvtovdesignvavdatabasevforvhervFBLAvclubvtovincludevallvthevmembers'vinformation.vW
ha tvdatavtypevshouldvshevusevforvLastvname?vgtext
Johnnyvhasvplannedvhisvbaseballvcardvdatabasevandvdeterminedvavlogicalvarrangement.vWhatvisvhi
svnextvstep?vggathervthevinformation
Whichvtypevofvrelationshipvmeansvthatvavrecordvinvthevfirstvtablevisvrelatedvorvmatchesvmorevtha
nv onevrecordvinvthevsecondvtable?vgonevtovmany
