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: Editing Records Viewing Records Creating New Records Printing Records Question 2.*Tables contain the following: Records Modules Relationships Queries 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: None of these Answers Viewing Multiple Records Editing Multiple Records Printing Multiple Records Question 6.*Which view is not available for reports? Print View Datasheet View Layout View Design View Question 7.*Where are Joins edited? In the Relationship Tools tab In the Primary Table Joins do not exist in Access. In The module labeled 'Structure Changes' Question 8.*Queries allow you to do which of the following: Combine multiple related tables in one view Search for certain criteria in a table 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: Running Macros For Navigation All the answers are correct. Running Modules 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: None of these answers are correct. Record Field View 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 Lookup All of the asnwers are field types. Short Text 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 Adds items to a database Can contain tables, forms and queries 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 Gives options for breaking up an existing table Alternative possibilities for 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: Close the table to ensure the record edits are saved You must click 'Save' to ensure the record edits are saved Do nothing to ensure the record edits are saved Close the form 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: Create a Query All of these options will work. Browse Records Do a Search
