Microsoft Access Exam Review: Key Concepts and Definitions, Exams of
Computer Science
Access - ANSWERA database program you use to enter, organize, display, and
retrieve related information.
Access window - ANSWERThe program window that appears when you start
the Access program to create a new database or open an existing database.
Add & Delete group - ANSWERA group on the Fields tab in Table Datasheet
view that contains options for adding different types of fields to a table.
All Access Objects - ANSWERThe default category in the Navigation Pane; it
lists all the objects in the database grouped by type (tables, queries, forms,
reports, and so on).
AutoNumber - ANSWERAn Access data type that automatically assigns a
unique number to a record.
backing up - ANSWERMaking a copy of a database file to protect your
database against loss or damage.
,Click to Add column - ANSWERIn Datasheet view for a table, the datasheet
column you can use to create a new field in the table.
column selector - ANSWERIn a datasheet, the column heading (also called the
field selector) that you click to select the entire column.
common field - ANSWERA field that appears in more than one table, allowing
you to connect the records in the separate tables
compacting - ANSWERA 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.
Create tab - ANSWERA tab on the Ribbon that provides options for creating
various database objects, including tables, forms, and reports.
Current Record box - ANSWERThe box that appears at the bottom of a
datasheet or form and that indicates the current record and total number of
records displayed.
data type - ANSWERThe field property that determines what field values you
can enter for the field and what other properties the field will have.
database - ANSWERA collection of related tables stored in the same file.
database management system (DBMS) - ANSWERA software program that
lets you create databases and then manipulate data in them.
, datasheet - ANSWERThe display of a table's contents in rows and columns,
similar to a table or spreadsheet; each row is a separate record in the table,
and each column contains the field values for one field in the table.
datasheet selector - ANSWERA box in the upper-left corner of a datasheet
that lets you select the entire datasheet.
Datasheet view (for a table) - ANSWERThe Access view that shows a table's
contents as a datasheet in rows and columns.
field - ANSWERA single characteristic or attribute of a person, place, object,
event, or idea.
field selector - ANSWERIn a datasheet, the column heading (also called the
column selector)that you click to select the entire column.
field value - ANSWERThe specific value, or content, of a field in a record. (AC
4)
Fields tab - ANSWERtab on the Ribbon that provides options for adding,
removing, and formatting the fields in a table. (AC 2)
foreign key - ANSWERA primary key field from one table that you include as a
field in a second table to form a relationship between the two tables. (AC 5)
form - ANSWERA database object you can create and customize to maintain,
view, and print records in a database in different and useful ways. (AC 22)
Computer Science
Access - ANSWERA database program you use to enter, organize, display, and
retrieve related information.
Access window - ANSWERThe program window that appears when you start
the Access program to create a new database or open an existing database.
Add & Delete group - ANSWERA group on the Fields tab in Table Datasheet
view that contains options for adding different types of fields to a table.
All Access Objects - ANSWERThe default category in the Navigation Pane; it
lists all the objects in the database grouped by type (tables, queries, forms,
reports, and so on).
AutoNumber - ANSWERAn Access data type that automatically assigns a
unique number to a record.
backing up - ANSWERMaking a copy of a database file to protect your
database against loss or damage.
,Click to Add column - ANSWERIn Datasheet view for a table, the datasheet
column you can use to create a new field in the table.
column selector - ANSWERIn a datasheet, the column heading (also called the
field selector) that you click to select the entire column.
common field - ANSWERA field that appears in more than one table, allowing
you to connect the records in the separate tables
compacting - ANSWERA 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.
Create tab - ANSWERA tab on the Ribbon that provides options for creating
various database objects, including tables, forms, and reports.
Current Record box - ANSWERThe box that appears at the bottom of a
datasheet or form and that indicates the current record and total number of
records displayed.
data type - ANSWERThe field property that determines what field values you
can enter for the field and what other properties the field will have.
database - ANSWERA collection of related tables stored in the same file.
database management system (DBMS) - ANSWERA software program that
lets you create databases and then manipulate data in them.
, datasheet - ANSWERThe display of a table's contents in rows and columns,
similar to a table or spreadsheet; each row is a separate record in the table,
and each column contains the field values for one field in the table.
datasheet selector - ANSWERA box in the upper-left corner of a datasheet
that lets you select the entire datasheet.
Datasheet view (for a table) - ANSWERThe Access view that shows a table's
contents as a datasheet in rows and columns.
field - ANSWERA single characteristic or attribute of a person, place, object,
event, or idea.
field selector - ANSWERIn a datasheet, the column heading (also called the
column selector)that you click to select the entire column.
field value - ANSWERThe specific value, or content, of a field in a record. (AC
4)
Fields tab - ANSWERtab on the Ribbon that provides options for adding,
removing, and formatting the fields in a table. (AC 2)
foreign key - ANSWERA primary key field from one table that you include as a
field in a second table to form a relationship between the two tables. (AC 5)
form - ANSWERA database object you can create and customize to maintain,
view, and print records in a database in different and useful ways. (AC 22)
