CGS 2100 Access Exam | UPDATED Questions with 100%
Verified Answers
Q1: Access
A: A database program you use to enter, organize, display, and retrieve related information
Q2: Access window
A: The program window that appear when you start the Access program to create a new
database or open an existing database
Q3: Add & Delete group
A: A group on the Fields tab in the Table Datasheet view that contains options for adding
different types of fields to a table
Q4: All access Objects
A: The default category in the Navigation Pane; it lists all the objects in the database
grouped by type (tables, queries, forms, reports, and so on)
Q5: AutoNumber
A: An Access data type that automatically assigns a unique number to a record
Q6: Backing up
A: Making a copy of a database file to protect your database against loss or damage
Q7: Click to Add column
A: In Datasheet view for a table, the datasheet column you can use to create a new field in
the table
Q8: Column Selector
A: In a datasheet, the column heading (also called the field selector) that you click to select
the entire column
Q9: Common field
A: A field that appears in more than one table, allowing you to connect the records in the
separate tables
Q10: Compacting
A: A process that rearranges the data and objects in a database to decrease its file size,
thereby making more space available on your disk and letting you open and close the
database more quickly
, Q11: Create tab
A: A tab on the Ribbon that provides options for creating various database objects,
including tables, forms, and report
Q12: Current Record box
A: The box that appears at the bottom of a datasheet or form and that indicates the current
record and total number of records displayed
Q13: Data type
A: The field property that determines what field values you can enter for the field and what
other properties the field will have
Q14: Database
A: A collection of related tables stored in the same file
Q15: Database management system (DBMS)
A: A software program that lets you create databases and then manipulate data in them
Q16: Datasheet
A: The display of a table's content in rows and columns
Q17: Datasheet selector
A: A box in the upper-left corner of a datasheet that lets you select the entire datasheet
Q18: Datasheet view (for a table)
A: The Access view that shows a table's contents as a datasheet in rows and columns
Q19: Field
A: A single characteristic or attribute of a person, place, object, event, or idea
Q20: Field selector
A: In a datasheet the column heading (also called the column selector) that you click to
select the entire column
Q21: Field value
A: The specific value, or content, of a field in a record
Q22: Fields tab
A: A tab on the ribbon that provides options for adding, removing, and formatting the fields
in a table
Verified Answers
Q1: Access
A: A database program you use to enter, organize, display, and retrieve related information
Q2: Access window
A: The program window that appear when you start the Access program to create a new
database or open an existing database
Q3: Add & Delete group
A: A group on the Fields tab in the Table Datasheet view that contains options for adding
different types of fields to a table
Q4: All access Objects
A: The default category in the Navigation Pane; it lists all the objects in the database
grouped by type (tables, queries, forms, reports, and so on)
Q5: AutoNumber
A: An Access data type that automatically assigns a unique number to a record
Q6: Backing up
A: Making a copy of a database file to protect your database against loss or damage
Q7: Click to Add column
A: In Datasheet view for a table, the datasheet column you can use to create a new field in
the table
Q8: Column Selector
A: In a datasheet, the column heading (also called the field selector) that you click to select
the entire column
Q9: Common field
A: A field that appears in more than one table, allowing you to connect the records in the
separate tables
Q10: Compacting
A: A process that rearranges the data and objects in a database to decrease its file size,
thereby making more space available on your disk and letting you open and close the
database more quickly
, Q11: Create tab
A: A tab on the Ribbon that provides options for creating various database objects,
including tables, forms, and report
Q12: Current Record box
A: The box that appears at the bottom of a datasheet or form and that indicates the current
record and total number of records displayed
Q13: Data type
A: The field property that determines what field values you can enter for the field and what
other properties the field will have
Q14: Database
A: A collection of related tables stored in the same file
Q15: Database management system (DBMS)
A: A software program that lets you create databases and then manipulate data in them
Q16: Datasheet
A: The display of a table's content in rows and columns
Q17: Datasheet selector
A: A box in the upper-left corner of a datasheet that lets you select the entire datasheet
Q18: Datasheet view (for a table)
A: The Access view that shows a table's contents as a datasheet in rows and columns
Q19: Field
A: A single characteristic or attribute of a person, place, object, event, or idea
Q20: Field selector
A: In a datasheet the column heading (also called the column selector) that you click to
select the entire column
Q21: Field value
A: The specific value, or content, of a field in a record
Q22: Fields tab
A: A tab on the ribbon that provides options for adding, removing, and formatting the fields
in a table
