Home > Microsoft Office > Quizzes > Microsoft Access (MS Access) Practice Test
Microsoft Access (MS Access) Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 24% • Most missed: “Two tables can be linked with relationship so that the data integrity can be enf…”

Microsoft Access is a database management system from Microsoft that combines the relational Access Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications.

Excel vs Access: Access is better for managing data: helping you keep it organized, easy to search, and available to multiple simultaneous users. Excel is generally better for analyzing data: performing complex calculations, exploring possible outcomes, and producing high quality charts.

Microsoft Access (MS Access) Practice Test
Time left 00:00
25 Questions

1. The command center of access file that appears when you create or open the MS Access database file.
2. To apply an AutoFormat to an entire Form, what must you select first?
3. In Access to switch between Edit mode (with insertion point displaye(D)
4. In Access to open an existing database press
5. The following database object can you import from one Microsoft Access database to another?
6. You view the properties of a form
7. The default and maximum size of text field in Access
8. The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors.
9. The___ operator will cause a record to be selected only if two or more conditions are satisfied
10. Press the following keys in Access to Save a database object
11. Which of the following store command to retrieve data from database?
12. If you need to edit a relationship
13. in MS Access, which data type is appropriate to store large text and numbers?
14. Which of the following can a Report Wizard NOT do?
15. The Allow _____ property controls whether new records can be added through the form.
16. Which data type is better to use for storing the price of an item?
17. In Access press to Open the Choose Builder dialog box (Design view window of forms and reports)
18. In Access press …………………….to Copy the selected control to the Clipboard
19. In Access to increase the width of the selected control
20. What is the use of Cascade Delete Option in MS Access?
21. Which of the following views is used to graphically summarize and analyze data in a recordset?
22. To create relationship between two tables
23. It is a database object to view, change, and analyze data in different ways
24. The page count of a report can be determined by clicking the _______ button.
25. A(n) ____ is the default control for a Yes/No field.

⚡ Recently practiced quizzes in this topic
Live quiz activity
Microsoft Outlook Word Processing Test Microsoft Paint (MS Paint) Practice Test Microsoft Outlook Test Office 365 Microsoft Word (MS Word) Practice Test: All Topics Microsoft Office Vocab Microsoft Word Practice Test Windows Notepad Practice Test Microsoft PowerPoint Practice Test
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.