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 FasoBurundiCabo VerdeCambodiaCameroonCanadaCayman IslandsCentral African RepublicChadChileChinaChristmas IslandCocos IslandsColombiaComorosCongoCongo, Democratic Republic of theCook IslandsCosta RicaCroatiaCubaCuraçaoCyprusCzechiaCôte d'IvoireDenmarkDjiboutiDominicaDominican RepublicEcuadorEgyptEl SalvadorEquatorial GuineaEritreaEstoniaEswatiniEthiopiaFalkland IslandsFaroe IslandsFijiFinlandFranceFrench GuianaFrench PolynesiaFrench Southern TerritoriesGabonGambiaGeorgiaGermanyGhanaGibraltarGreeceGreenlandGrenadaGuadeloupeGuamGuatemalaGuernseyGuineaGuinea-BissauGuyanaHaitiHeard Island and McDonald IslandsHoly SeeHondurasHong KongHungaryIcelandIndiaIndonesiaIranIraqIrelandIsle of ManIsraelItalyJamaicaJapanJerseyJordanKazakhstanKenyaKiribatiKorea, Democratic People's Republic ofKorea, Republic ofKuwaitKyrgyzstanLao People's Democratic RepublicLatviaLebanonLesothoLiberiaLibyaLiechtensteinLithuaniaLuxembourgMacaoMadagascarMalawiMalaysiaMaldivesMaliMaltaMarshall IslandsMartiniqueMauritaniaMauritiusMayotteMexicoMicronesiaMoldovaMonacoMongoliaMontenegroMontserratMoroccoMozambiqueMyanmarNamibiaNauruNepalNetherlandsNew CaledoniaNew ZealandNicaraguaNigerNigeriaNiueNorfolk IslandNorth MacedoniaNorthern Mariana IslandsNorwayOmanPakistanPalauPalestine, State ofPanamaPapua New GuineaParaguayPeruPhilippinesPitcairnPolandPortugalPuerto RicoQatarRomaniaRussian FederationRwandaRéunionSaint BarthélemySaint Helena, Ascension and Tristan da CunhaSaint Kitts and NevisSaint LuciaSaint MartinSaint Pierre and MiquelonSaint Vincent and the GrenadinesSamoaSan MarinoSao Tome and PrincipeSaudi ArabiaSenegalSerbiaSeychellesSierra LeoneSingaporeSint MaartenSlovakiaSloveniaSolomon IslandsSomaliaSouth AfricaSouth Georgia and the South Sandwich IslandsSouth SudanSpainSri LankaSudanSurinameSvalbard and Jan MayenSwedenSwitzerlandSyria Arab RepublicTaiwanTajikistanTanzania, the United Republic ofThailandTimor-LesteTogoTokelauTongaTrinidad and TobagoTunisiaTurkmenistanTurks and Caicos IslandsTuvaluTürkiyeUS Minor Outlying IslandsUgandaUkraineUnited Arab EmiratesUnited KingdomUnited StatesUruguayUzbekistanVanuatuVenezuelaViet NamVirgin 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 Printing Records Creating New 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: None of these Answers Viewing Multiple Records Printing Multiple Records Editing Multiple Records Question 6.*Which view is not available for reports? Print View Datasheet View Design View Layout View Question 7.*Where are Joins edited? In the Primary Table In the Relationship Tools tab 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 Combine multiple related tables in one view Calculate or summarize data Search for certain criteria in a table Question 9.*Buttons can be created and used in Access for which of the following: All the answers are correct. Running Modules For Navigation Running Macros 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: Record View None of these answers are correct. Field Question 12.*Normalizing is a term... that represents a process for building proper relationships. that applies a format to specific numbers. that makes sure your data is within specified parameters. that represents a process for separating data into tables. Question 13.*Which field type is not an actual field type in Access 2016? Memo All of the asnwers are field types. Lookup Short Text Question 14.*A Primary Key can only be assigned to one field. True False Question 15.*Which answer is not true, when describing Quick Start Application Parts? Can contain tables, forms and queries Adds items to a database Only works with databases with no existing tables Pre-defined templates Question 16.*The Analyze Table command in Access checks which of the following: All of the answers are correct. Alternative possibilities for an existing table Allows you to set Primary Keys for the tables 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: 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... are something Access automatically creates, when necessary. None of these answers are correct. are similar to a macro, but require code. do not exist in Access. Question 20.*To find a specific record, you must do which of the following: Browse Records Create a Query Do a Search All of these options will work.
