Have an account?
Skip to Content
Build your own quiz
30 questions
Show Answers
See Preview
- 1. Multiple ChoiceWithin an Access table, each record is represented by one _____________.ColumnRowFieldTable
- 2. Multiple ChoiceA tool for collecting and organizing information.databasesource baseword processorpresentation software
- 3. Multiple ChoiceA column in a database table.recordfield
- 4. Multiple ChoiceThe column in a database that uniquely identifies each row.Primary KeyQuery
- 5. Multiple ChoiceA group of database tables that is connected or linked by a defined relationship that ties the information together.Relational databaseRelated by name databasesProfessional databaseOptional database
- 6. Multiple Choice
Identify the bordered object (not where the arrow is pointing)Tool BarObject BarRibbonNone of the Above - 7. Multiple ChoiceIdentify the bordered object (not where the arrow is pointing)Navigation PaneTitle BarControl BoxNone of the Above
- 8. Multiple ChoiceIdentify the bordered object (not where the arrow is pointing)Control Box & Quick Access Tool BarWindows ControlRibbonTool Bar
- 9. Multiple ChoiceIdentify the bordered object (not where the arrow is pointing)Quick Access Tool BarControl BoxObject PaneRibbon
- 10. Multiple ChoiceThis is the Object PaneTrueFalseMaybeNone
- 11. Multiple ChoiceData type where the field can contain only monetary data.CurrencyNumberTextField
- 12. Multiple ChoiceContains a list of all the objects in the database.Navigation PaneObject PaneDatasheet ViewAccess Work Area
- 13. Multiple ChoiceIdentify the bordered object at the bottom (not where the arrow is pointing)Ready BarStatus BarOptional BarRibbon Bar
- 14. Multiple ChoiceWhat is a Relationship in an MS Access Database?It makes the data easier to enterIt prevents data from being entered incorrectlyIt makes you feel closer to the computer and it's capabilitiesIt connects two tables so that they can be used as one table
- 15. Multiple ChoiceWhen designing a table, what are two things that you must assign to every field?Field Name and Data TypeField Name and Field SizeField Color and Data TypeField Size and Field Color
- 16. Multiple ChoiceWhich view should you use to enter records into a table displayed in rows and columns?Design ViewLayout ViewDatasheet ViewPrint Preview
- 17. Multiple ChoiceIf you delete a record from an Access table, can you click undo and retrieve the record?YESNO
- 18. Multiple ChoiceValues in an AutoNumber field are automatically created by Access.TrueFalse
- 19. Multiple ChoicePress [Esc] once to undo a change to the current field.TrueFalse
- 20. Multiple ChoiceMicrosoft Access 2016 can best be described as ____ software.spreadsheetpresentationdatabasesystems
- 21. Multiple ChoiceWhich is NOT true about Access?It can be used to create formsIt relates lists of information in a relational database.Reporting is limited to 20 saved reports.Multiple users can simultaneously enter and update data within Access.
- 22. Multiple ChoiceTables, queries, and forms are examples of Access ____.entitiesobjectsvaluescontrols
- 23. Multiple ChoiceEach object in an Access database application displays at the left side of the Access window in the ____.Navigation PaneObjects BarObjects TabPinned space
- 24. Multiple ChoiceWhich Access object contains all of the raw data within the database?formtablequerymodule
- 25. Multiple ChoiceWhich of the following is NOT a data type?Date/TimeFormulaNumberShort Text
- 26. Multiple ChoiceWhich data type stores only one of two values?AttachmentHyperlinkNullYes/No
- 27. Multiple ChoiceWhich data type links files created in other programs such as pictures or documents?AttachmentLink WizardLookupYes/No
- 28. Multiple ChoiceA specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.fieldobjectrecordtable
- 29. Multiple ChoiceA group of related fields, such as all the demographic information for one customer, is called a(n) ____.databaseobjectrecordtable
- 30. Multiple ChoiceHannah wants to create a record keeping system to track the inventory needed to efficiently run her lawn and landscape business, such as spare parts, gas cans, string trimmers, etc. Her crew manager will also be using the system. Hannah is considering whether to use Excel or Access. Which one of the following is NOT a benefit of using Access?More data storage
Multiuser capabilityEasier setupAdditional reporting features - Answer choicesTagsAnswer choicesTags