Step 1 of 21 - Question 1 4% Name* First Last Address* City State / Province / Region ZIP / Postal Code AfghanistanAlbaniaAlgeriaAmerican SamoaAndorraAngolaAnguillaAntarcticaAntigua and BarbudaArgentinaArmeniaArubaAustraliaAustriaAzerbaijanBahamasBahrainBangladeshBarbadosBelarusBelgiumBelizeBeninBermudaBhutanBoliviaBonaire, Sint Eustatius and SabaBosnia and HerzegovinaBotswanaBouvet IslandBrazilBritish Indian Ocean TerritoryBrunei DarussalamBulgariaBurkina FasoBurundiCambodiaCameroonCanadaCape VerdeCayman IslandsCentral African RepublicChadChileChinaChristmas IslandCocos IslandsColombiaComorosCongo, Democratic Republic of theCongo, Republic of theCook IslandsCosta RicaCroatiaCubaCuraçaoCyprusCzech RepublicCôte d'IvoireDenmarkDjiboutiDominicaDominican RepublicEcuadorEgyptEl SalvadorEquatorial GuineaEritreaEstoniaEswatini (Swaziland)EthiopiaFalkland IslandsFaroe IslandsFijiFinlandFranceFrench GuianaFrench PolynesiaFrench Southern TerritoriesGabonGambiaGeorgiaGermanyGhanaGibraltarGreeceGreenlandGrenadaGuadeloupeGuamGuatemalaGuernseyGuineaGuinea-BissauGuyanaHaitiHeard and McDonald IslandsHoly SeeHondurasHong KongHungaryIcelandIndiaIndonesiaIranIraqIrelandIsle of ManIsraelItalyJamaicaJapanJerseyJordanKazakhstanKenyaKiribatiKuwaitKyrgyzstanLao People's Democratic RepublicLatviaLebanonLesothoLiberiaLibyaLiechtensteinLithuaniaLuxembourgMacauMacedoniaMadagascarMalawiMalaysiaMaldivesMaliMaltaMarshall IslandsMartiniqueMauritaniaMauritiusMayotteMexicoMicronesiaMoldovaMonacoMongoliaMontenegroMontserratMoroccoMozambiqueMyanmarNamibiaNauruNepalNetherlandsNew CaledoniaNew ZealandNicaraguaNigerNigeriaNiueNorfolk IslandNorth KoreaNorthern Mariana IslandsNorwayOmanPakistanPalauPalestine, State ofPanamaPapua New GuineaParaguayPeruPhilippinesPitcairnPolandPortugalPuerto RicoQatarRomaniaRussiaRwandaRéunionSaint BarthélemySaint HelenaSaint Kitts and NevisSaint LuciaSaint MartinSaint Pierre and MiquelonSaint Vincent and the GrenadinesSamoaSan MarinoSao Tome and PrincipeSaudi ArabiaSenegalSerbiaSeychellesSierra LeoneSingaporeSint MaartenSlovakiaSloveniaSolomon IslandsSomaliaSouth AfricaSouth GeorgiaSouth KoreaSouth SudanSpainSri LankaSudanSurinameSvalbard and Jan Mayen IslandsSwedenSwitzerlandSyriaTaiwanTajikistanTanzaniaThailandTimor-LesteTogoTokelauTongaTrinidad and TobagoTunisiaTurkeyTurkmenistanTurks and Caicos IslandsTuvaluUS Minor Outlying IslandsUgandaUkraineUnited Arab EmiratesUnited KingdomUnited StatesUruguayUzbekistanVanuatuVenezuelaVietnamVirgin Islands, BritishVirgin Islands, U.S.Wallis and FutunaWestern SaharaYemenZambiaZimbabweÅland Islands Country Company Name Email* Question 1.*Forms are not used for the following: Printing Records Creating New Records Viewing Records Editing Records Question 2.*Tables contain the following: Records Relationships Queries Modules Question 3.*Primary Keys must be unique. False True Question 4.*Macros in Access are just recordings to automate formatting. False True Question 5.*Reports are not used for which of the following: Printing Multiple Records None of these Answers Viewing Multiple Records Editing Multiple Records Question 6.*Which view is not available for reports? Design View Print View Layout View Datasheet View Question 7.*Where are Joins edited? In the Relationship Tools tab Joins do not exist in Access. In the Primary Table In The module labeled 'Structure Changes' Question 8.*Queries allow you to do which of the following: Search for certain criteria in a table Combine multiple related tables in one view Calculate or summarize data All of the answers are correct Question 9.*Buttons can be created and used in Access for which of the following: For Navigation Running Macros Running Modules All the answers are correct. Question 10.*More than one relationship can be created between two of the same tables. False True Question 11.*A column in a table represents which of the following: Record View Field None of these answers are correct. Question 12.*Normalizing is a term... that makes sure your data is within specified parameters. that represents a process for separating data into tables. that applies a format to specific numbers. that represents a process for building proper relationships. Question 13.*Which field type is not an actual field type in Access 2016? Memo Short Text Lookup All of the asnwers are field types. Question 14.*A Primary Key can only be assigned to one field. False True Question 15.*Which answer is not true, when describing Quick Start Application Parts? Can contain tables, forms and queries Only works with databases with no existing tables Pre-defined templates Adds items to a database Question 16.*The Analyze Table command in Access checks which of the following: Allows you to set Primary Keys for the tables Alternative possibilities for an existing table Gives options for breaking up an existing table All of the answers are correct. Question 17.*It is best practice to use both forms and reports for navigation within the database. True False Question 18.*When you edit a record and go to the next record, you need to do which of the following: You must click 'Save' to ensure the record edits are saved Close the form to ensure the record edits are saved Do nothing to ensure the record edits are saved Close the table to ensure the record edits are saved Question 19.*Modules... do not exist in Access. are something Access automatically creates, when necessary. are similar to a macro, but require code. None of these answers are correct. Question 20.*To find a specific record, you must do which of the following: Do a Search All of these options will work. Create a Query Browse Records
