--- type: Quiz title: "MS Access Quiz: 60 MCQs for OSSC, CGL, RRB & Govt Exams" canonical: "https://www.easy2crack.com/mcqs/computer/ms-access-quiz-lP8zI7qb" subject: computer questions: 60 free: true updated: null tags: ["mcq", "practice", "computer"] --- # MS Access Quiz: 60 MCQs for OSSC, CGL, RRB & Govt Exams 60 multiple-choice questions with answers. ## Q1. What is Microsoft Access? A. A word processing software B. A relational database management system C. A spreadsheet application D. A presentation software **Answer:** b ## Q2. What is the file extension for an Access 2007 and later database? A. .mdb B. .accdb C. .xlsx D. .dbf **Answer:** b ## Q3. Which object in Access is used to store data? A. Query B. Form C. Table D. Report **Answer:** c ## Q4. What is a field in a database table? A. A row of data B. A column representing a category of data C. The entire table D. A database file **Answer:** b ## Q5. What is a record in a database table? A. A column of data B. A single row containing related data C. The table name D. A database query **Answer:** b ## Q6. Which data type would you use to store a person's name? A. Number B. Date/Time C. Short Text D. Currency **Answer:** c ## Q7. What is a Primary Key? A. The first field in a table B. A field that uniquely identifies each record C. The password to open the database D. A field that contains numbers only **Answer:** b ## Q8. Which view is used to modify the structure of a table? A. Datasheet View B. Design View C. Form View D. Print Preview **Answer:** b ## Q9. What is the purpose of a Form in Access? A. To print data B. To provide a user-friendly interface for data entry C. To calculate totals D. To delete records **Answer:** b ## Q10. What is the purpose of a Query in Access? A. To store data permanently B. To retrieve and manipulate data based on criteria C. To print reports D. To create charts **Answer:** b ## Q11. What is a Report in Access used for? A. Entering new data B. Formatting and printing data for presentation C. Creating tables D. Writing macros **Answer:** b ## Q12. Which data type is used to store monetary values? A. Number B. Short Text C. Currency D. Long Text **Answer:** c ## Q13. What does the AutoNumber data type do? A. Automatically formats numbers B. Generates a unique sequential number for each new record C. Counts the total records D. Calculates averages **Answer:** b ## Q14. How do you add a new record in Datasheet View? A. Press Ctrl+N B. Click on the blank row at the bottom of the table C. Right-click and select 'Add Table' D. Go to File menu and select New **Answer:** b ## Q15. What is the Navigation Pane in Access? A. A tool for creating queries B. A panel that displays all database objects C. A form design tool D. A report generator **Answer:** b ## Q16. Which keyboard shortcut saves the current object in Access? A. Ctrl+P B. Ctrl+S C. Ctrl+O D. Ctrl+N **Answer:** b ## Q17. What is the Yes/No data type used for? A. Storing long paragraphs B. Storing Boolean values (true/false) C. Storing dates D. Storing images **Answer:** b ## Q18. What is a database template in Access? A. A blank database B. A pre-designed database with tables and objects for specific purposes C. A backup file D. A printed report **Answer:** b ## Q19. How do you delete a record in Datasheet View? A. Press the Delete key B. Select the record and press Ctrl+Minus or right-click and delete C. Close the database D. Use the Backspace key **Answer:** b ## Q20. What is the Attachment data type used for? A. Attaching tables to queries B. Storing files like images, documents, or spreadsheets C. Linking forms to reports D. Connecting to external databases **Answer:** b ## Q21. What is Datasheet View? A. A view for designing forms B. A spreadsheet-like view for viewing and editing data C. A view for writing code D. A view for printing **Answer:** b ## Q22. What happens when you compact and repair a database? A. It creates a backup B. It removes deleted space and fixes minor corruption C. It encrypts the database D. It splits the database **Answer:** b ## Q23. Which data type would you use for a field that stores dates? A. Short Text B. Number C. Date/Time D. Long Text **Answer:** c ## Q24. What is the maximum number of characters that Short Text can hold? A. 50 characters B. 255 characters C. 1000 characters D. Unlimited **Answer:** b ## Q25. What is a blank database? A. A database with corrupted data B. An empty database with no pre-defined objects C. A database with only queries D. A read-only database **Answer:** b ## Q26. How do you rename a table in Access? A. Double-click on the table name B. Right-click the table and select Rename C. Press F5 D. Use the Format menu **Answer:** b ## Q27. What is the Long Text data type used for? A. Storing numbers B. Storing large amounts of text like descriptions or notes C. Storing dates D. Storing currency **Answer:** b ## Q28. What does the OLE Object data type store? A. Only text B. Objects from other applications like Word or Excel C. Only numbers D. Only dates **Answer:** b ## Q29. Which symbol indicates a Primary Key field in Design View? A. A star B. A key icon C. A lock icon D. An arrow **Answer:** b ## Q30. What is the purpose of field properties in Access? A. To delete fields B. To define characteristics and rules for a field C. To create relationships D. To run queries **Answer:** b ## Q31. What is a Select Query? A. A query that deletes records B. A query that retrieves data from tables based on criteria C. A query that creates new tables D. A query that updates records **Answer:** b ## Q32. What is a one-to-many relationship? A. One record in Table A relates to one record in Table B B. One record in Table A relates to multiple records in Table B C. Multiple records in both tables relate to each other D. No relationship exists between tables **Answer:** b ## Q33. What is referential integrity? A. A password protection feature B. Rules that ensure valid relationships between tables C. A backup system D. A data encryption method **Answer:** b ## Q34. What is a Foreign Key? A. The primary key of the current table B. A field that references the primary key of another table C. An encrypted field D. A calculated field **Answer:** b ## Q35. What is a Parameter Query? A. A query with fixed criteria B. A query that prompts the user to enter criteria when run C. A query that creates tables D. A query that cannot be modified **Answer:** b ## Q36. What does the asterisk (*) wildcard represent in a query? A. A single character B. Zero or more characters C. A number only D. An exact match **Answer:** b ## Q37. What does the question mark (?) wildcard represent in a query? A. Zero or more characters B. Exactly one character C. A number D. An optional field **Answer:** b ## Q38. What is an Action Query? A. A query that only displays data B. A query that makes changes to data (update, delete, append, make-table) C. A query that creates forms D. A query that generates reports **Answer:** b ## Q39. What is an Update Query used for? A. Adding new records B. Modifying existing data in one or more records C. Deleting records D. Creating new tables **Answer:** b ## Q40. What is an Append Query? A. A query that deletes records B. A query that adds records from one table to another C. A query that modifies field names D. A query that creates relationships **Answer:** b ## Q41. What is a Make-Table Query? A. A query that updates tables B. A query that creates a new table from query results C. A query that deletes tables D. A query that renames tables **Answer:** b ## Q42. What is a Crosstab Query? A. A query that crosses out data B. A query that displays summarized data in a spreadsheet-like format C. A query that creates forms D. A query that links external data **Answer:** b ## Q43. What is an Inner Join? A. Returns all records from both tables B. Returns only records where the joined fields match in both tables C. Returns records from the left table only D. Returns records from the right table only **Answer:** b ## Q44. What is a Left Outer Join? A. Returns only matching records B. Returns all records from the left table and matching records from the right C. Returns all records from the right table D. Returns no records **Answer:** b ## Q45. What is a calculated field in a query? A. A field that stores static values B. A field that computes values using expressions C. A field that only holds dates D. A field that cannot be modified **Answer:** b ## Q46. What is the purpose of the GROUP BY clause in a query? A. To sort records alphabetically B. To group records for aggregate calculations C. To delete duplicate records D. To create new fields **Answer:** b ## Q47. Which aggregate function counts the number of records? A. Sum B. Avg C. Count D. Max **Answer:** c ## Q48. What is a subform? A. A small-sized form B. A form embedded within another form to show related records C. A hidden form D. A backup form **Answer:** b ## Q49. What is the Relationships window used for? A. Creating queries B. Viewing and creating relationships between tables C. Designing forms D. Printing reports **Answer:** b ## Q50. What is Cascade Update Related Fields? A. Deletes related records automatically B. Updates foreign key values when the primary key is changed C. Creates new relationships D. Backs up the database **Answer:** b ## Q51. What is Cascade Delete Related Records? A. Deletes duplicate records B. Automatically deletes related records when the parent record is deleted C. Updates field values D. Creates backup copies **Answer:** b ## Q52. What is an Input Mask? A. A security feature B. A pattern that controls how data is entered into a field C. A display format D. A filter for queries **Answer:** b ## Q53. What is a Validation Rule? A. A rule that deletes invalid data B. An expression that limits the values accepted in a field C. A formatting option D. A query filter **Answer:** b ## Q54. What is the difference between Form View and Layout View? A. Form View is for data entry; Layout View is for design with live data B. They are the same C. Layout View is for data entry; Form View is for design D. Neither allows data entry **Answer:** a ## Q55. What is a Lookup field? A. A field that searches the database B. A field that displays values from another table or a list C. A primary key field D. A calculated field **Answer:** b ## Q56. What is the SQL View in queries? A. A view for creating forms B. A view showing the SQL code behind the query C. A view for designing reports D. A view for entering data **Answer:** b ## Q57. What is the HAVING clause used for? A. Filtering records before grouping B. Filtering grouped records after aggregation C. Sorting records D. Joining tables **Answer:** b ## Q58. What is a many-to-many relationship? A. One record in each table relates to one record in the other B. Multiple records in both tables can relate to each other C. No relationship exists D. One table relates to itself **Answer:** b ## Q59. What is a junction table? A. A table that stores images B. An intermediate table that resolves many-to-many relationships C. A backup table D. A table for queries only **Answer:** b ## Q60. What is the BETWEEN operator used for in queries? A. Joining two tables B. Specifying a range of values in criteria C. Calculating differences D. Creating relationships **Answer:** b --- Source: https://www.easy2crack.com/mcqs/computer/ms-access-quiz-lP8zI7qb Site: https://www.easy2crack.com · Machine index: https://www.easy2crack.com/llms.txt · MCP: https://www.easy2crack.com/mcp