Enhanced Microsoft Access 2013: Comprehensive 1st Edition Test Bank

Preview (16 of 556 Pages)

100%

Purchase to unlock

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage11.Accessisa____.a.wordprocessingsoftwaretoolb.filemanagementsystemc.workbookmanagementsystemd.databasemanagementsystemANSWER:dPOINTS:1REFERENCES:AC22.Ina(n)____databasesuchasthosemaintainedbyAccess,adatabaseconsistsofacollectionoftables,eachofwhichcontainsinformationonaspecificsubject.a.tabularb.recordc.attributed.relationalANSWER:dPOINTS:1REFERENCES:AC23.A(n)____containsinformationaboutagivenperson,product,orevent.a.attributeb.recordc.fieldd.columnANSWER:bPOINTS:1REFERENCES:AC34.____wordsarewordsthathaveaspecialmeaningtoAccessandcannotbeusedforthenamesoffields.a.Reservedb.Restrictedc.Significantd.TaggedANSWER:aPOINTS:1REFERENCES:AC45.InAccess,tableandfieldnamescanbeupto____charactersinlength.a.256b.128c.64d.32ANSWER:cPOINTS:1REFERENCES:AC86.Afieldwhosedatatypeis____cancontainanycharacters.a.Alphab.Characterc.Normald.ShortTextANSWER:dPOINTS:1REFERENCES:AC97.A(n)____datatypecanstoreavariableamountoftextorcombinationoftextandnumberswherethetotalnumberof

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage2charactersmayexceed255.a.Memob.LongTextc.Variabled.CharacterANSWER:bPOINTS:1REFERENCES:AC98.Afieldwiththe____datatypecanstoreauniquesequentialnumberthatAccessassignstoarecord.Accesswillincrementthenumberby1aseachnewrecordisadded.a.Sequentialb.ValueIncrementc.Incrementald.AutoNumberANSWER:dPOINTS:1REFERENCES:AC99.Afieldwiththe____datatypecancontainanattachedfile,suchasanimage,document,chart,orspreadsheet.a.Attachmentb.Filec.Documentd.ExtendANSWER:aPOINTS:1REFERENCES:AC910.Afieldwhosedatatypeis____canstoreanOLEobject,whichisanobjectlinkedtoorembeddedinthetable.a.Illustrationb.Imagec.Bitmapd.OLEobjectANSWER:dPOINTS:1REFERENCES:AC911.Afieldwhosedatatypeis____canstoretextthatcanbeusedasahyperlinkaddress.a.URLb.Webc.Placeholderd.HyperlinkANSWER:dPOINTS:1REFERENCES:AC912.Whenyouassigna(n)____toafield,Accesswilldisplaythevalueyouassign,ratherthanthefieldname,indatasheetsandinforms.a.alternateb.captionc.abbreviationd.tagANSWER:bPOINTS:1REFERENCES:AC10

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage313.WhenyoucreateatableinDatasheetview,Accessautomaticallyaddsafieldcalled____asthefirstfieldinthetable.a.AutoNumberb.AutoFillc.IDd.PrimaryIDANSWER:cPOINTS:1REFERENCES:AC1114.TodefineanadditionalfieldinDatasheetview,taporclickthe____columnheading.a.NewFieldb.AddFieldc.ClicktoAddd.InsertFieldANSWER:cPOINTS:1REFERENCES:AC1415.Toundothemostrecentchangetoatablestructure,taporclickthe____buttonontheQuickAccessToolbar.a.Cancelb.Reversec.Backd.UndoANSWER:dPOINTS:1REFERENCES:AC1516.Todeleteafieldinatable,pressandholdorright-clickthecolumnheadingforthefield,andthentaporclick____ontheshortcutmenu.a.RemoveFieldb.DeleteFieldc.DeleteColumnd.RemoveColumnANSWER:bPOINTS:1REFERENCES:AC1517.Tochangethenameofafield,pressandholdorright-clickthecolumnheadingforthefield,taporclick____ontheshortcutmenu,andthentypethedesiredfieldname.a.ChangeColumnb.RenameColumnc.ChangeFieldd.RenameFieldANSWER:dPOINTS:1REFERENCES:AC1518.ToshowthesymbolfortheEuroinsteadofthedollarsign,changethe____propertyforthefieldwhosedatatypeisCurrency.a.FieldSizeb.Formatc.Captiond.DescriptionANSWER:bPOINTS:1REFERENCES:AC15

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage419.Toinsertafieldbetweenexistingfields,pressandholdorright-clickthecolumnheadingforthefieldthatwillfollowthenewfield,andthentaporclick____ontheshortcutmenu.a.InsertColumnb.InsertFieldc.AddColumnd.AddFieldANSWER:bPOINTS:1REFERENCES:AC15-AC1620.ToopenatableinDesignview,pressandholdorright-clickthetableintheNavigationPaneandthentaporclick____ontheshortcutmenua.TableDesignb.LayoutViewc.StructureViewd.DesignViewANSWER:dPOINTS:1REFERENCES:AC1721.Intheaccompanyingfigure,thekeysymbolthatappearsintherowselectorfortheBookRepNumberfieldindicatesthatBookRepNumberisthe____forthetable.a.principalkeyb.foreignkeyc.mainkeyd.primarykeyANSWER:d

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage5POINTS:1REFERENCES:AC1722.Intheaccompanyingfigure,theBookReptabledisplaysin____.a.Structureviewb.Designviewc.Layoutviewd.TableviewANSWER:bPOINTS:1REFERENCES:AC1723.Intheaccompanyingfigure,thesmallboxorbartotheleftofeachfieldiscalledthe____.a.rowselectorb.fieldselectorc.fieldbard.currentfieldbarANSWER:aPOINTS:1REFERENCES:AC1824.Toaddarecordtoatable,taporclickthe____recordbutton.a.AddNewb.New(blank)c.Lastd.Insert(New)ANSWER:bPOINTS:1REFERENCES:AC2325.Youcanplaceaninsertionpointbytappingorclickinginthefieldorbypressing____.a.F2b.F3c.F4d.F5ANSWER:aPOINTS:1REFERENCES:AC2326.Todeletearecord,taporclicktherecordselectorfortherecord,andthenpressthe____key(s).a.CTRL+DELETEb.CTRL+Yc.DELETEd.CTRL+KANSWER:cPOINTS:1REFERENCES:AC2327.TospecifyAutoCorrectrulesandexceptionstotherules,taporclickFILEtoopentheBackstageview,taporclick____,andthentaporclickProofinginthedialogboxthatdisplays.a.Customizeb.Managec.Optionsd.GrammarANSWER:cPOINTS:1

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage6REFERENCES:AC2328.Tosavethechangestothelayoutofatable,taporclicktheSavebuttononthe____.a.statusbarb.TABLETOOLStabc.NavigationPaned.QuickAccessToolbarANSWER:dPOINTS:1REFERENCES:AC2829.Tochangetheprintorientationfromportraittolandscape,taporclickthe____buttononthePRINTPREVIEWtab.a.Portrait/Landscapeb.Orientationc.SwitchOrientationd.LandscapeANSWER:dPOINTS:1REFERENCES:AC3130.Toimportdatatoatable,taporclickthe____tabontheribbon.a.DATABASETOOLSb.FILEc.EXTERNALDATAd.IMPORTANSWER:cPOINTS:1REFERENCES:AC3331.ToopentheNavigationPane,taporclickthe____Button.a.OpenNavigationPaneb.OpenPanec.ShutterBarOpen/Closed.NavigationBarShow/HideANSWER:cPOINTS:1REFERENCES:AC4032.TocreateaqueryusingtheQueryWizard,taporclick____ontheribbonandthenclicktheQueryWizardbutton.a.CREATEb.INSERTc.NEWOBJECTd.REPORTANSWER:aPOINTS:1REFERENCES:AC4033.Toviewtheresultsofasavedquery,pressandholdorright-clickthequeryintheNavigationPaneandtaporclick____ontheshortcutmenu.a.DatasheetViewb.Openc.ResultsViewd.RunANSWER:bPOINTS:1REFERENCES:AC42-AC43

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage734.Tochangethedesignofaquery,pressandholdorright-clickthequeryintheNavigationPaneandthentaporclick____ontheshortcutmenu.a.Openb.SQLc.QueryWindowd.DesignViewANSWER:dPOINTS:1REFERENCES:AC4235.TocreateaninitialreportthatcanbemodifiedinLayoutview,taporclick____ontheCREATEtab.a.Layoutb.ReportLayoutc.Reportd.SimpleReportANSWER:cPOINTS:1REFERENCES:AC4936.ToexitAccess,taporclickthe____buttonontherightsideofthetitlebar.a.Quitb.Stopc.Endd.CloseANSWER:dPOINTS:1REFERENCES:AC5637.Tobackupthedatabasethatiscurrentlyopen,usethe____commandontheSaveAstabintheBackstageview.a.CloseandBackUpb.BackUpCurrentc.SaveAsBackUpd.BackUpDatabaseANSWER:dPOINTS:1REFERENCES:AC5638.Tocompactandrepairadatabase,taporclickthe___buttonintheInfogalleryintheBackstageview.a.Restoreb.Fixc.Compactiond.Compact&RepairANSWER:dPOINTS:1REFERENCES:AC5739.Todeleteadatabaseobject,pressandholdorright-clicktheobjectintheNavigationPaneandthentaporclick____ontheshortcutmenu.a.Eraseb.Trashc.Deleted.RemoveANSWER:cPOINTS:1REFERENCES:AC58

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage840.Torenameadatabaseobject,pressandholdorright-clicktheobjectintheNavigationPaneandthentaporclick____ontheshortcutmenu.a.NewNameb.Redefinec.Renamed.SaveNameANSWER:cPOINTS:1REFERENCES:AC58ModifiedMultipleChoice41.Filenamescannotcontaina(n)____.a.questionmark(?)b.colon(:)c.spaced.underscore(_)ANSWER:a,bPOINTS:1REFERENCES:AC742.Fieldnamescannotcontain____.a.squarebrackets([])b.periods(.)c.hyphens(-)d.accentgraves(‘)ANSWER:a,b,dPOINTS:1REFERENCES:AC843.TheAccesswindowconsistsofavarietyofcomponents.Theseincludethe____.a.NavigationPaneb.Contentpanec.Objecttabsd.QuickAccessToolbarANSWER:a,c,dPOINTS:1REFERENCES:AC844.AfieldwithaYes/Nodatatypecanstoreonlyoneoftwovalues.Thechoicesare____.a.True/Falseb.One/Zeroc.Yes/Nod.On/OffANSWER:a,c,dPOINTS:1REFERENCES:AC945.Youcancreateatablein____.a.Designviewb.Blankviewc.Layoutviewd.DatasheetviewANSWER:a,dPOINTS:1

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage9REFERENCES:AC1046.InAccess,thecolumnsinatablearecalledrecords.a.Trueb.FalseANSWER:FalsePOINTS:1REFERENCES:AC347.Auniqueidentifieralsoiscalledaprimarykey.a.Trueb.FalseANSWER:TruePOINTS:1REFERENCES:AC348.InAccess,fieldnamescannotcontaindigits.a.Trueb.FalseANSWER:FalsePOINTS:1REFERENCES:AC849.TheNavigationPanecontainsalistofalltheobjectsinthedatabase.a.Trueb.FalseANSWER:TruePOINTS:1REFERENCES:AC850.InDatasheetview,atableisrepresentedasacollectionofrowsandcolumnscalledalist.a.Trueb.FalseANSWER:FalsePOINTS:1REFERENCES:AC851.ThemaximumnumberofcharactersallowedinafieldwhosedatatypeisShortTextis255characters.a.Trueb.FalseANSWER:TruePOINTS:1REFERENCES:AC9

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage1052.FieldsthatcontainnumbersbutwillnotbeusedforarithmeticoperationsusuallyareassignedadatatypeofMemo.a.Trueb.FalseANSWER:FalsePOINTS:1REFERENCES:AC953.TheCurrencydatatypeisusedforfieldsthatcontainonlymonetarydata.a.Trueb.FalseANSWER:TruePOINTS:1REFERENCES:AC954.TheCharacterdatatypeisusedforafieldthatcanstoreavariableamountoftextorcombinationsoftextandnumberswherethetotalnumberofcharactersmayexceed255.a.Trueb.FalseANSWER:FalsePOINTS:1REFERENCES:AC955.WhenAccessfirstcreatesadatabase,itautomaticallycreatesatable.a.Trueb.FalseANSWER:TruePOINTS:1REFERENCES:AC1156.OnewaytoundochangestoafieldistoclicktheUndobuttononthestatusbar.a.Trueb.FalseANSWER:FalsePOINTS:1REFERENCES:AC1557.TheAutoErrorCorrectionfeatureofAccesscorrectscommondataentryerrors.a.Trueb.FalseANSWER:FalsePOINTS:1REFERENCES:AC23

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage1158.Asshownintheaccompanyingfigure,youcanmovetotheendofatabletoapositionforenteringanewrecordbyclickingtheInsertrecordNavigationbutton.a.Trueb.FalseANSWER:FalsePOINTS:1REFERENCES:AC2659.Asshownintheaccompanyingfigure,youcanusetheLastrecordbuttontomovetothelastrecordinthetable.a.Trueb.FalseANSWER:TruePOINTS:1REFERENCES:AC2660.Asshownintheaccompanyingfigure,youcanmovetothefirstrecordinatablebyclickingtheStartrecordNavigationbutton.a.Trueb.FalseANSWER:FalsePOINTS:1REFERENCES:AC2661.Changingthecolumnwidthinadatasheetchangesthestructureofatable.a.Trueb.False

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage12ANSWER:FalsePOINTS:1REFERENCES:AC2862.Landscapeorientationmeanstheprintoutisacrossthelength(height)ofthepage.a.Trueb.FalseANSWER:TruePOINTS:1REFERENCES:AC2963.Toprintawidedatabasetable,atablewhosecontentsdonotfitonthescreen,youwillneedportraitorientation.a.Trueb.FalseANSWER:FalsePOINTS:1REFERENCES:AC2964.Topreviewandthenprintthecontentsofatable,useTablePreview.a.Trueb.FalseANSWER:FalsePOINTS:1REFERENCES:AC3065.Formviewdisplaysasinglerecordatatime.a.Trueb.FalseANSWER:TruePOINTS:1REFERENCES:AC4566.Layoutviewshowsareportonthescreenandallowstheusertomakechangestothereport.a.Trueb.FalseANSWER:TruePOINTS:1REFERENCES:AC5067.StandardpropertiesareassociatedwithallMicrosoftOfficedocumentsandincludeauthor,title,andsubject.a.Trueb.FalseANSWER:TruePOINTS:1

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage13REFERENCES:AC5468.TheDATABASETOOLStabprovidescommandstosaveadatabasewithanothername.a.Trueb.FalseANSWER:FalsePOINTS:1REFERENCES:AC5769.Eachcustomerhasonebookrep,buteachbookrepcanhavemanycustomers.Thisisanexampleofaone-to-manyrelationship.a.Trueb.FalseANSWER:TruePOINTS:1REFERENCES:AC6270.Redundancymeansstoringthesamefactinmorethanoneplace.a.Trueb.FalseANSWER:TruePOINTS:1REFERENCES:AC6271.Thetermlistdatabasedescribesadatabasethatconsistsofacollectionoftables,eachofwhichcontainsinformationonaspecificsubject.____________________ANSWER:False-relationalPOINTS:1REFERENCES:AC272.AfieldthathastheCalculateddatatypecanstoreauniquesequentialnumberthatAccessassignstoarecord.____________________ANSWER:False-AutoNumberPOINTS:1REFERENCES:AC973.Tochangethenameofafield,pressandholdorright-clickthecolumnheadingforthefield,andthentaporclickRenameFieldontheshortcutmenu.____________________ANSWER:TruePOINTS:1REFERENCES:AC1574.Toinsertafieldbetweenexistingfields,pressandholdorright-clickthecolumnheadingforthefieldthatwillfollowthenewfield,andthentaporclickInsertColumnontheshortcutmenu.____________________ANSWER:False-Field

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage14POINTS:1REFERENCES:AC15-AC1675.Todeleteafield,pressandholdorright-clickthecolumnheadingforthefield,andthentaporclickRemoveFieldontheshortcutmenu.____________________ANSWER:False-DeletePOINTS:1REFERENCES:AC1576.A(n)____________________issoftwarethatcanbeusedtocreateadatabase;add,change,anddeletedatainthedatabase;askandanswerquestionsconcerningthedatainthedatabase;andcreateformsandreportsusingthedata.ANSWER:databasemanagementsystemPOINTS:1REFERENCES:AC277.Therowsinthetablesarecalled____________________.ANSWER:recordsPOINTS:1REFERENCES:AC378.A(n)____________________containsaspecificpieceofinformationwithinarecord.ANSWER:fieldPOINTS:1REFERENCES:AC379.Auniqueidentifieralsoiscalleda(n)____________________.ANSWER:primarykeyPOINTS:1REFERENCES:AC3

Loading page image...

Name:Class:Date:Access2013Chapter01:DatabasesandDatabaseObjectsCengageLearningTesting,PoweredbyCogneroPage1580.Intheaccompanyingfigure,the____________________Panecontainsalistofalltheobjectsinthedatabase.ANSWER:NavigationPOINTS:1REFERENCES:AC781.Intheaccompanyingfigure,thewordsDatasheetViewatthelowerleftofthescreenappearonthe____________________.ANSWER:statusbarPOINTS:1REFERENCES:AC782.Intheaccompanyingfigure,theentireareathatdisplaysonthescreeniscalledthe____________________workarea.ANSWER:AccessPOINTS:1REFERENCES:AC783.Intheaccompanyingfigure,____________________fortheopenobjectsappearatthetopoftheworkarea.ANSWER:objecttabsPOINTS:1REFERENCES:AC784.Intheaccompanyingfigure,thedatabasename,BavantPublishingappearsonthe____________________.ANSWER:titlebarPOINTS:1REFERENCES:AC7

Preview Mode

This document has 556 pages. Sign in to access the full document!

Report

Study Now!

Document Details

Related Documents

DevOps and Its Importance Study Notes

Veeam Certified Engineer VMCE-V12

Modules 1 - 3 Basic Network Connectivity and Commu

Notes CCNA

CCNA 200-301 Portable Command Guide 5th Edition 20

CCNA 200-301 Portable Command Guide 5th Edition 22

CCNA 200-301 Portable Command Guide 5th Edition 36

Foundations of Novell Networking Section 26

Modulo 7 DHCPv4

Build and troubleshooting Integration Challenge

Company

Explore

Study Tools