1. Microsoft Access is a .............. Database Management Application.
2. In Excel, we call the vertical structure "Column" while in Access we call it a ...............
3. If the Navigation Pane in Access is totally hidden, then you can show it by using the shortcut:...
4. To get answers to questions about a business, we create a .............
5. The developer names of fields in Access follow a certain convention. Although they might be difficult for the user, but we can provide a user friendly version of the name by typing a ..........
6. When sorting 2 fields simultaneously, precedence is ............. (3 words)
7. When creating a field to store comments the proper data type to use is a ............... field
8. A database object that shows a single record at a time is called..
9. A field that serves as a unique identifier and is used to create relationships between tables is called the.
10. Enforcing referential integrity prevents creating .......... records
11. The maximum size of a short text field is.. a) 128 b) 255 c) 500 d) 288
12. Creating relationships is a matter of dragging the primary key field from one table to the .......... in the second table. a) Similar field b) First position c) Foreign key d) Last position
13. The maximum size of an Access database is.. a) 5 inch b) Unlimited c)500 MB d) 4GB
14. When you change a value in a Form then close it, this change is automatically communicated to the....... a) Source Table b)Other form c) The data base administrator d) Query
15. The types of relationships in Access include the following except: a) One to Many b) One to one C) Many to Many d) Identical
16. An infinity symbol on one side of the relationship means a (n) ......... relationship. a) Invalid b) Many c) Missing d) Strong
17. We do not get any benefit from a database until we......... a) Create relationships b) Save it c) Export it to excel d) create report
18. To create a Many to Many Relationships we need a (n)............ a) Junction table b)Matching query c) Short text data type d)Shared database
19. When creating an Address field in Datasheet view, it's easier to use....... a) Quick parts b) Template c) Macro d) Copy and Paste
20. A field property that specifies the type, size and format of that field is called a) Input Mask b)Append only c) Caption d) Default