Microsoft Access 2013 for Beginners: Start Your Database Journey – Course Assessment Answers

Posted on by

Microsoft Access 2013 for Beginners: Start Your Database Journey – Course Assessment Answers

This course assessment will now enable you to review your learning so you can determine your knowledge and understanding of the course Microsoft Access 2013 for Beginners: Start Your Database Journey

You will be assessed on the following learning outcomes:
• Discuss navigating Microsoft Access using the ribbon and toolbar.
• Recognize how to customize Access for your specific requirements.
• Discuss the use of the desktop or web app versions.
• Identify how to create tables and create relationships between those data tables.
• Identify how to sort, filter, enter and find data in your databases.
• Discuss correctly designing an Access table including using Design View and Field properties.
• Recognise how to create, design and edit Forms.

To effectively use this website to answer your alison questions with ease, checkout this short tutorial I put together to help you in the video below.

https://www.youtube.com/watch?v=Dw2UxUpf7Ng

1. True or False: The shortcut buttons on the right of the Access 2013 status bar vary depending on the object selected.
True
False
Ans: True

2. Which of the following is NOT a valid Access 2013 data type? Choose one.
Memo
Short text
Long text
Currency
Ans: Memo

3. Fill in the Blank: In design view a form is divided into three sections form Header, ________, and form Footer.
Ans: Detail

4. Which is the keyboard shortcut for creating a new record in a table. Drag correct answer to box.
Ctrl+Enter
Ctrl+Insert
Ctrl++
Ctrl+=
Ans: Ctrl++

5. Fill in Blank: When making a Access Web App database the data in the database has to reside in a _______. Location
Ans: Central

6. True or False: In Access 2013 the keyboard shortcut for accessing online help is F1.
True
False
Ans: True

7. True or False: The Short Text data type in Access 2013 was known as the Memo data type in earlier versions of Access.
True
False
Ans: False

8. Fill in the Blank: An _______ speed up searches and sorting on a field.
Ans: Index

9. Which table field property is a label for the field when used in a view? Drag correct answer to box.
Input Mask
Indexed
Caption
Default value
Ans: Caption

10. There are how many main ways of creating a form in Access. Type your answer in numeric form.
Ans: 4

11. On which tab on the Access 2013 ribbon would you find the Relationships group? Choose one.
Database Tools
External Data
Create
Home
Ans: Database Tools

12. Which of the following is NOT one of the available options for ScreenTip style in Access 2013? Choose one.
Show feature descriptions in ScreenTips
Show ScreenTips
Don’t show ScreenTips
Don’t show feature descriptions in ScreenTips
Ans: Show ScreenTips

13. Which of these keys would you press to see the KeyTips on the Access 2013 ribbon? Choose one.
Shift
F1
Alt
Ctrl
Ans: Alt

14. Which of the following is the standard type of value used for an AutoNumber field? Choose one.
Decimal
Long integer
Short integer
Byte
Ans: Long integer

15. True or False: The Access 2013 Quick Access Toolbar always appears above the ribbon.
True
False
Ans: False

16. Fill in the Blank: To create a look up field in your Access data base you set the fields data type to be a Lookup ________.
Ans: Wizard

17. True or False: In Access 2013 it is possible to undo the deletion of a record using the Undo command.
True
False
Ans: False

18. Select the layouts that you can use when creating a form. Choose four
Browser
Tabular
Columnar
Datasheet
Justified
Table
Ans: Tabular, Columnar, Datasheet, Justified

19. True or False: An Access 2013 lookup field can get its values from another table in the database.
True
False
Ans: True

20. Fill in the Blank: Filtering in access is very _________ as it depends on the type of data in the column.
Ans: Contextual

21. On which of these tabs on the Access 2013 ribbon would you find the Clipboard group? Choose one.
Home
Create
Format
Database Tools
Ans: Home

22. Fill in the Blank: The ______ key is what links two different tables together with a relationship.
Ans: Foreign

23. Which of these number types would be the best to use in Access 2013 for integers that range from -32,768 to +32,767? Choose one.
Integer
Single
Decimal
Byte
Ans: Integer

24. True or False: Two fields can be used as a primary key together.
True
False
Ans: True

25. True or False: The Long Text data type in Access 2013 was known as the Memo data type in earlier versions of Access.
True
False
Ans: True

26. Which table field property has the description of “A pattern for all data to be entered in this field”? Drag correct answer to box.
Format
Default Value
Input Mask
Required
Ans: Input Mask

27. Which of the following is NOT one of the possible values for the Indexed property of a field in a table in an Access 2013 database? Choose one.
Yes
Yes (No Duplicates)
Yes (Duplicates OK)
No (Duplicates OK)
Ans: No (Duplicates OK)

28. What is the keyboard shortcut for saving a record just after you enter it? Drag correct answer to box.
Shift+Enter
Ctrl+Enter
Tab
Ctrl+Shift
Ans: Shift+Enter

29. True or False: Access 2013 is supported on Windows Vista, Windows 7 and Windows 8 but not on Windows XP.
True
False
Ans: False

30. Fill in the Blank: The general idea of field _________ is to set rules or constraints on what data can be entered in data field.
Ans: Validation

31. True or False: One of the options when creating a relationship in Access 2013 is whether to enforce referential integrity.
True
False
Ans: True

32. Which of these is NOT a standard Access 2013 Text Filter? Choose one.
Contains…
Equals…
Ends with…
Between…
Ans: Between…

33. True or False: Single Form and Continuous Forms are two of the options for the Default View of a form in Access 2013.
True
False
Ans: True

34. Which of the following is NOT one of the tabs that comprise the Form Design Tools in Access 2013? Choose one.
Design
Format
Arrange
Datasheet
Ans: Datasheet

35. True or False: An Access 2013 lookup field can get its values from another table in the database.
True
False
Ans: True

36. Fill in the Blank: The _____ key is what is used to identify table records uniquely.
Ans: Primary

37. Which of the following is the standard file extension for an Access 2013 database? Choose one.
acc
accessdb
mdb
accdb
Ans: accdb

38. True or False: When using the Access 2013 Column Width dialog in Datasheet View there is a Best Fit option.
True
False
Ans: True