MIS Access Exam Questions and
Answers6
Subform - ANSWERS -records displayed that are related to records in a main form
Unbound Control - ANSWERS -A control not tied to a specific field
Guidance User Interface (GUI) - ANSWERS -Allows for the click and drag interaction ins tread of
coding
Datasheet View - ANSWERS -View that enables you to add,edit, and delete the records of a
table
Design View - ANSWERS -View that enables you to create tables, add and delete fields, and
modify field properties
Field - ANSWERS -The smallest data element in a table, such as first name, last name, address or
phone number
Filter by Form - ANSWERS -A filtering method that displays records based on multiple criteria
Filter by Section - ANSWERS -A filtering method that displays only records that match selected
criteria
Form - ANSWERS -An Access object that enables you to enter, modify, or delete table data
, Navigation Pane - ANSWERS -An Access interface element that organizes and lists the database
objects in a database
Object - ANSWERS -A main component that is created and used to make a database function
Primary Key - ANSWERS -The field (or combination of fields) that uniquely identifies each record
in a table
Query - ANSWERS -A question you ask that can help you find an retrieve table data meeting
conditions you specify
Record - ANSWERS -Complete set of all the fields (data elements) about one person, place,
event or concept
Relational database management system (RDBMS) - ANSWERS -A system that uses the
relational model to manage groups of data (tables) and rules (relationships) between tables
Relationship - ANSWERS -A connection between two tables using a common field
Repot - ANSWERS -An object that contains professional-looking formatted information from
underlying tables or queries
Sort - ANSWERS -A method of listing records in a specific sequence
Table - ANSWERS -An object used to store data, and the foundation of every database
Criteria Row - ANSWERS -A row in the Query Design view that determines which records will be
selected
Answers6
Subform - ANSWERS -records displayed that are related to records in a main form
Unbound Control - ANSWERS -A control not tied to a specific field
Guidance User Interface (GUI) - ANSWERS -Allows for the click and drag interaction ins tread of
coding
Datasheet View - ANSWERS -View that enables you to add,edit, and delete the records of a
table
Design View - ANSWERS -View that enables you to create tables, add and delete fields, and
modify field properties
Field - ANSWERS -The smallest data element in a table, such as first name, last name, address or
phone number
Filter by Form - ANSWERS -A filtering method that displays records based on multiple criteria
Filter by Section - ANSWERS -A filtering method that displays only records that match selected
criteria
Form - ANSWERS -An Access object that enables you to enter, modify, or delete table data
, Navigation Pane - ANSWERS -An Access interface element that organizes and lists the database
objects in a database
Object - ANSWERS -A main component that is created and used to make a database function
Primary Key - ANSWERS -The field (or combination of fields) that uniquely identifies each record
in a table
Query - ANSWERS -A question you ask that can help you find an retrieve table data meeting
conditions you specify
Record - ANSWERS -Complete set of all the fields (data elements) about one person, place,
event or concept
Relational database management system (RDBMS) - ANSWERS -A system that uses the
relational model to manage groups of data (tables) and rules (relationships) between tables
Relationship - ANSWERS -A connection between two tables using a common field
Repot - ANSWERS -An object that contains professional-looking formatted information from
underlying tables or queries
Sort - ANSWERS -A method of listing records in a specific sequence
Table - ANSWERS -An object used to store data, and the foundation of every database
Criteria Row - ANSWERS -A row in the Query Design view that determines which records will be
selected
