MICROSOFT ACCESS EXAM
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.? - Correct Answer - Data
Which term refers to a usually large collection of data organized especially for rapid
search? - Correct Answer - database
Which term refers to a "collection of programs that manage the database structure and
controls access to the stored data in the database"? - Correct Answer - database
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? - Correct Answer - entity
T or F: A field refers to a "single characteristic or attribute of a person, place, object
(etc)" - Correct Answer - True
Which term refers to the "specific value or content of a field"? - Correct Answer - field
value
What is the term for "a set of field values for an individual entity"? - Correct Answer -
record/tuple
What refers to "a collection of fields that describes a person, place, object etc. about
which a database stores data"? - Correct Answer - table/relation
What is the term for "a collection of records concerning a collection of entities of the
same type" - Correct Answer - table/relation
What refers to "a collection of related tables (relations)" ? - Correct Answer - database
T or F: in a table (relation), rows correspond to records (tuples) and columns
correspond to fields - Correct Answer - True
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) -
Correct Answer - primary 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"? - Correct Answer - foreign key
What is the default file extension for a file created in Access 2016 - Correct Answer -
accdb
T or F: In Access 2016, tapping the z key while holding CTRL undoes your last action -
Correct Answer - False
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 - Correct Answer - True
T or F: In database design, it is considered good form to avoid the use of spaces in
names of fields and tables - Correct Answer - true
Which data type assigns an automatic serial # to records and often used as an artificial
key - Correct Answer - AutoNumber
Which data type is intended to store up to 255 letters digits and other characters and
which is appropriate for ID numbers which are not used in calculations? - Correct
Answer - Short text
Which data type is intended for amounts of money, is implemented as decimal numbers
and follows the rounding conventions from accounting and is automatically formatted by
default to use the currency simple, separator into decimal places? - Correct Answer -
Currency
Which data type is intended to store dates and times? - Correct Answer - Date/time
Which of the following is not a predefined numeric data type in access tables? - Correct
Answer - Phone
A stored question about data in the database which generates a table from one or more
other tables is called which of the following? - Correct Answer - query
A custom dialogue box created to allow the user to view enter or edit one or more
records in a database is called which of the following? - Correct Answer - form
A collection of records from a table query which has been formatted so it may be printed
is called which of the following? - Correct Answer - Report
Which property of the field is set to determine what values you can enter or what other
properties the field will have? - Correct Answer - data type
Which property of the field will designate the length of text field in characters or the
class (subtypes) of number and autonumber fields - Correct Answer - field Size
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.? - Correct Answer - Data
Which term refers to a usually large collection of data organized especially for rapid
search? - Correct Answer - database
Which term refers to a "collection of programs that manage the database structure and
controls access to the stored data in the database"? - Correct Answer - database
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? - Correct Answer - entity
T or F: A field refers to a "single characteristic or attribute of a person, place, object
(etc)" - Correct Answer - True
Which term refers to the "specific value or content of a field"? - Correct Answer - field
value
What is the term for "a set of field values for an individual entity"? - Correct Answer -
record/tuple
What refers to "a collection of fields that describes a person, place, object etc. about
which a database stores data"? - Correct Answer - table/relation
What is the term for "a collection of records concerning a collection of entities of the
same type" - Correct Answer - table/relation
What refers to "a collection of related tables (relations)" ? - Correct Answer - database
T or F: in a table (relation), rows correspond to records (tuples) and columns
correspond to fields - Correct Answer - True
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) -
Correct Answer - primary 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"? - Correct Answer - foreign key
What is the default file extension for a file created in Access 2016 - Correct Answer -
accdb
T or F: In Access 2016, tapping the z key while holding CTRL undoes your last action -
Correct Answer - False
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 - Correct Answer - True
T or F: In database design, it is considered good form to avoid the use of spaces in
names of fields and tables - Correct Answer - true
Which data type assigns an automatic serial # to records and often used as an artificial
key - Correct Answer - AutoNumber
Which data type is intended to store up to 255 letters digits and other characters and
which is appropriate for ID numbers which are not used in calculations? - Correct
Answer - Short text
Which data type is intended for amounts of money, is implemented as decimal numbers
and follows the rounding conventions from accounting and is automatically formatted by
default to use the currency simple, separator into decimal places? - Correct Answer -
Currency
Which data type is intended to store dates and times? - Correct Answer - Date/time
Which of the following is not a predefined numeric data type in access tables? - Correct
Answer - Phone
A stored question about data in the database which generates a table from one or more
other tables is called which of the following? - Correct Answer - query
A custom dialogue box created to allow the user to view enter or edit one or more
records in a database is called which of the following? - Correct Answer - form
A collection of records from a table query which has been formatted so it may be printed
is called which of the following? - Correct Answer - Report
Which property of the field is set to determine what values you can enter or what other
properties the field will have? - Correct Answer - data type
Which property of the field will designate the length of text field in characters or the
class (subtypes) of number and autonumber fields - Correct Answer - field Size
