ACCESS THEORY TEST- FINAL EXAM
WITH CORRECT QUESTIONS AND
ANSWERS 2025
access is a ______. - CORRECT-ANSWERSdatabase management system
in a _____ database such as those maintained by Access, a database consists of a collection of
tables, each of which contains information on a specific subject - CORRECT-
ANSWERSrelational
a _____ contains information about a given person, product, or event - CORRECT-
ANSWERSrecord
______ words are words that have a special meaning to Access and cannot be used for the
names of record - CORRECT-ANSWERSreserved
in access, table and field names can be up to ___ characters in length - CORRECT-ANSWERS64
a field whose data type is ____- can contain any characters - CORRECT-ANSWERSshort text
, a _____ datatype can store a variable amount of text or combination of text and numbers
where the total number of characters may exceed 255 - CORRECT-ANSWERSlong text
a field with the _____ data type can contain an attached file, such as an image, document,
chart, or spreadsheet - CORRECT-ANSWERSAttachment
a field with the ______ data type can store a unique sequential that Access assigns to a record.
access will increment the number by 1 as each new record is added - CORRECT-
ANSWERSAutoNumber
a field whose data type is _____ can store an OLE object, which is an object linked to or
embedded in the table - CORRECT-ANSWERSOLE object
a field whose data type is _____ can store text that can be used as a hyperlink address. -
CORRECT-ANSWERShyperlink
when you assign a ______ to a field, Access will display the value you assign, rather than the
field name, in datasheets and in forms - CORRECT-ANSWERScaption
WITH CORRECT QUESTIONS AND
ANSWERS 2025
access is a ______. - CORRECT-ANSWERSdatabase management system
in a _____ database such as those maintained by Access, a database consists of a collection of
tables, each of which contains information on a specific subject - CORRECT-
ANSWERSrelational
a _____ contains information about a given person, product, or event - CORRECT-
ANSWERSrecord
______ words are words that have a special meaning to Access and cannot be used for the
names of record - CORRECT-ANSWERSreserved
in access, table and field names can be up to ___ characters in length - CORRECT-ANSWERS64
a field whose data type is ____- can contain any characters - CORRECT-ANSWERSshort text
, a _____ datatype can store a variable amount of text or combination of text and numbers
where the total number of characters may exceed 255 - CORRECT-ANSWERSlong text
a field with the _____ data type can contain an attached file, such as an image, document,
chart, or spreadsheet - CORRECT-ANSWERSAttachment
a field with the ______ data type can store a unique sequential that Access assigns to a record.
access will increment the number by 1 as each new record is added - CORRECT-
ANSWERSAutoNumber
a field whose data type is _____ can store an OLE object, which is an object linked to or
embedded in the table - CORRECT-ANSWERSOLE object
a field whose data type is _____ can store text that can be used as a hyperlink address. -
CORRECT-ANSWERShyperlink
when you assign a ______ to a field, Access will display the value you assign, rather than the
field name, in datasheets and in forms - CORRECT-ANSWERScaption
