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 Viewing Records Creating New 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. True False Question 5.*Reports are not used for which of the following: Printing Multiple Records Viewing Multiple Records None of these Answers Editing Multiple Records Question 6.*Which view is not available for reports? Datasheet View Layout View Print View Design View Question 7.*Where are Joins edited? In the Relationship Tools tab In the Primary Table In The module labeled 'Structure Changes' Joins do not exist in Access. Question 8.*Queries allow you to do which of the following: All of the answers are correct Calculate or summarize data Combine multiple related tables in one view Search for certain criteria in a table Question 9.*Buttons can be created and used in Access for which of the following: Running Macros Running Modules All the answers are correct. For Navigation Question 10.*More than one relationship can be created between two of the same tables. True False Question 11.*A column in a table represents which of the following: None of these answers are correct. View Field Record Question 12.*Normalizing is a term... that applies a format to specific numbers. that represents a process for separating data into tables. that makes sure your data is within specified parameters. 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? Pre-defined templates Can contain tables, forms and queries Adds items to a database Only works with databases with no existing tables Question 16.*The Analyze Table command in Access checks which of the following: Allows you to set Primary Keys for the tables All of the answers are correct. Alternative possibilities for an existing table Gives options for breaking up an existing table 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: Close the table 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 You must click 'Save' to ensure the record edits are saved Question 19.*Modules... None of these answers are correct. are something Access automatically creates, when necessary. do not exist in Access. are similar to a macro, but require code. Question 20.*To find a specific record, you must do which of the following: Browse Records Create a Query All of these options will work. Do a Search
