Home > Information Technology (IT) Support Executive > Quizzes > Database System Assistant Practice Test: Microsoft Access
Database System Assistant Practice Test: Microsoft Access
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 84% Most missed: “What is the maximum length of the field name in Access?”
Database System Assistant Practice Test: Microsoft Access
Time left 00:00
18 Questions

1. What is allowed the input mark symbol # in Access?
2. Which key stroke moves the active cell towards left in Access table?
3. Which combination of key allows user to move to the first field in the first record in Access table?
4. Which object stores information about related data?
5. What is the maximum number of characters allowed in text field in access?
6. What is the maximum length of the field name in Access?
7. What is the expansion of OLE in Access?
8. Which validation rule accepts only a - z letters for fields in Access?
9. Which key stroke is used to move the active cell towards right, in access table?
10. Which technique prevents invalid data being saved in Access table?
11. Which command quickly locates the data in Access table?
12. Which validation rule allows only positive numbers for fields in Access?
13. Which validation rule allows exactly digits for number fields in Access?
14. Which combination of key zooms the content of active cell in Access table?
15. Which of the following is a valid time format in Access?
16. Which validation rule allows only 0 - 9 for fields in Access?
17. Which view is used to arrange table data in different graphical layouts to summarize data?
18. Which view allows to modify table’s structure in Access?