Microsoft Access Exam
Study Questions &
Answers
What is the generic term used to refer to raw facts which have not been processed and will be
used as a basis for reasoning, discussion, etc.? - ANSWERSData
Which term refers to a usually large collection of data organized especially for rapid search? -
ANSWERSdatabase
Which term refers to a "collection of programs that manage the database structure and controls
access to the stored data in the database"? - ANSWERSdatabase managment system (DBMS)
What is the term used to refer to an individual person, place, object, event or idea about which
a database stores data? - ANSWERSentity
T or F: A field refers to a "single characteristic or attribute of a person, place, object (etc)" -
ANSWERSTrue
Which term refers to the "specific value or content of a field"? - ANSWERSfield value
What is the term for "a set of field values for an individual entity"? - ANSWERSrecord/tuple
What refers to "a collection of fields that describes a person, place, object etc. about which a
database stores data"? - ANSWERStable/relation
, What is the term for "a collection of records concerning a collection of entities of the same
type" - ANSWERStable/relation
What refers to "a collection of related tables (relations)" ? - ANSWERSdatabase
T or F: in a table (relation), rows correspond to records (tuples) and columns correspond to
fields - ANSWERSTrue
Which is the term for a SELECTED field or fields whose values are used to uniquely identify rows
in a table (I.e no two rows can have the same value in this column) - ANSWERSprimary key
Which term refers to a "primary key from another table, stored in a table, in order to form a
relationship between the two tables"? - ANSWERSforeign key
What is the default file extension for a file created in Access 2016 - ANSWERSaccdb
T or F: In Access 2016, tapping the z key while holding CTRL undoes your last action -
ANSWERSFalse
T or F: In Access 2016 field names may be up to 64 characters, include any characters except
commas, ! , grace accents and a square braces - ANSWERSTrue
T or F: In database design, it is considered good form to avoid the use of spaces in names of
fields and tables - ANSWERStrue
Which data type assigns an automatic serial # to records and often used as an artificial key -
ANSWERSAutoNumber
Study Questions &
Answers
What is the generic term used to refer to raw facts which have not been processed and will be
used as a basis for reasoning, discussion, etc.? - ANSWERSData
Which term refers to a usually large collection of data organized especially for rapid search? -
ANSWERSdatabase
Which term refers to a "collection of programs that manage the database structure and controls
access to the stored data in the database"? - ANSWERSdatabase managment system (DBMS)
What is the term used to refer to an individual person, place, object, event or idea about which
a database stores data? - ANSWERSentity
T or F: A field refers to a "single characteristic or attribute of a person, place, object (etc)" -
ANSWERSTrue
Which term refers to the "specific value or content of a field"? - ANSWERSfield value
What is the term for "a set of field values for an individual entity"? - ANSWERSrecord/tuple
What refers to "a collection of fields that describes a person, place, object etc. about which a
database stores data"? - ANSWERStable/relation
, What is the term for "a collection of records concerning a collection of entities of the same
type" - ANSWERStable/relation
What refers to "a collection of related tables (relations)" ? - ANSWERSdatabase
T or F: in a table (relation), rows correspond to records (tuples) and columns correspond to
fields - ANSWERSTrue
Which is the term for a SELECTED field or fields whose values are used to uniquely identify rows
in a table (I.e no two rows can have the same value in this column) - ANSWERSprimary key
Which term refers to a "primary key from another table, stored in a table, in order to form a
relationship between the two tables"? - ANSWERSforeign key
What is the default file extension for a file created in Access 2016 - ANSWERSaccdb
T or F: In Access 2016, tapping the z key while holding CTRL undoes your last action -
ANSWERSFalse
T or F: In Access 2016 field names may be up to 64 characters, include any characters except
commas, ! , grace accents and a square braces - ANSWERSTrue
T or F: In database design, it is considered good form to avoid the use of spaces in names of
fields and tables - ANSWERStrue
Which data type assigns an automatic serial # to records and often used as an artificial key -
ANSWERSAutoNumber
