No Comments Welcome to your MS Access Mock Test Name Email Phone 1. A file containing relatively permanent data is Random file Master file Sequential file Transaction file 2. Which of the following is not a type of Microsoft access database object? Macros Worksheets Table Modules 3. The checking operation performed on input data is called the Validation of data Cross check Control of data Verification of data 4. A part of database that stores complete information about an entity such as employee, sales, orders etc. Field Record File Query 5. In Access, ____ are used to store the data. Form Table Report Query 6. Which of the following is not a valid Data Type in MS Access? Memo Picture AutoNumber Currency 7. Press _____ to quit MS Access. Ctrl +F4 Tab +F4 Esc+ W Alt+F4 8. ____ is not a valid data type in MS Access. Memo Auto number Currency Picture 9. This form displays multiple records, one per row, in the form window Justified Tabular Datasheet Columnar 10. Open the Save As dialog box F1 F12 F6 F10 11. In MS Access, OLE objects Data type can store Sounds Microsoft Excel Spreadsheets Microsoft Word documents All options are correct 12. A _____ is an area reserved for a specific piece of data. Field Key Record Report 13. A search value can be exact value or it can be Wild card character Comparison operation Relationship Logical operator 14. The default and maximum size of text field in access 288 characters and 6880 characters 299 characters and 6499 characters 266 characters and 6400 characters 50 and 255 characters 15. A subset of characters within a data field is known as Record Data string File Byte 16. What is the maximum length a text field can be? 75 265 255 120 17. The columns in a Microsoft Access table are called as ____ (A) Fields Columns Macro Fields Records 18. Microsoft Access is a _____ OODBMS ORDBMS Network Database Model RDBMS 19. In Access table, column is also known as ____ Type Record Data Field 20. To create a table in MS Access Table can be created using Table Templates All options are true You should allow at least one Primary key in a table Database should be created before creating a table You cannot switch tabs while taking this quiz!You are not allowed to switch tabs violation has been recorded.you cannot minimize full screen mode!You are not allowed to minimize full screen while taking this quiz, violation has been recorded.Access denied! To begin the quiz, please grant this quiz access to your camera.