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: Viewing Records Creating New Records Editing Records Printing Records Question 2.*Tables contain the following: Modules Records Relationships Queries Question 3.*Primary Keys must be unique. True False Question 4.*Macros in Access are just recordings to automate formatting. True False Question 5.*Reports are not used for which of the following: Viewing Multiple Records Editing Multiple Records Printing Multiple Records None of these Answers Question 6.*Which view is not available for reports? Design View Print View Datasheet View Layout View Question 7.*Where are Joins edited? In The module labeled 'Structure Changes' In the Primary Table In the Relationship Tools tab Joins do not exist in Access. 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 Running Modules For Navigation All the answers are correct. 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: Field None of these answers are correct. Record View Question 12.*Normalizing is a term... that applies a format to specific numbers. that represents a process for separating data into tables. that represents a process for building proper relationships. that makes sure your data is within specified parameters. Question 13.*Which field type is not an actual field type in Access 2016? Memo All of the asnwers are field types. Short Text Lookup 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? Only works with databases with no existing tables Pre-defined templates Can contain tables, forms and queries 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 Gives options for breaking up an existing table All of the answers are correct. Alternative possibilities for 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: Do nothing to ensure the record edits are saved Close the table to ensure the record edits are saved Close the form 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. do not exist in Access. are something Access automatically creates, when necessary. are similar to a macro, but require code. 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
