ACCESS EXAM 2 WITH CORRECT QUESTIONS AND ANSWERS 2025

ACCESS EXAM 2 WITH CORRECT
QUESTIONS AND ANSWERS 2025


Access 2021 databases are stored with a - CORRECT-ANSWERS.accdb file extension



the advantage of using a RDBMS such as Access versus a flat file system is that data is not -



CORRECT-ANSWERSduplicated



the navigation pane on the left side of an Access window can be used to list all the objects in



the database - CORRECT-ANSWERStrue



an access table object must be - CORRECT-ANSWERScreated before you can create any other



objects, and its therefore known as the primary object



the data type defined in table design view - CORRECT-ANSWERSdetermines what field values



are allowed and what other properties the field will have



The autonumber data type will always ensure that a primary key value will be unique -



CORRECT-ANSWERStrue

, clicking the save button on the database toolbar in access allows you to save the entire access



database you are working on - CORRECT-ANSWERSfalse



when entering records into an access table the... - CORRECT-ANSWERSpencil symbol at the



beginning of a record indicates a record being edited



the asterisk symbol displays a potential new record



input masks, validation rules, and lookup fields all help maintain data accuracy - CORRECT-



ANSWERStrue



referential integrity is - CORRECT-ANSWERSa feature built in to access to prevent data



inconsistency in related tables



primary and foreign keys used to make up relationships must be given the same field name -



CORRECT-ANSWERStrue