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
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
