ITM FINAL EXAM questions with answers
|\ |\ |\ |\ |\
Database - CORRECT ANSWERS ✔✔A collection of data
|\ |\ |\ |\ |\ |\ |\ |\
organized as meaningful information that can be
|\ |\ |\ |\ |\ |\ |\
accessed, managed, stored, queried, sorted, and
|\ |\ |\ |\ |\ |\
reported.
6 Objects of a Database - CORRECT ANSWERS ✔✔1. Table
|\ |\ |\ |\ |\ |\ |\ |\ |\
2. Forms
|\
3. Queries
|\
4. Reports
|\
5. Macros
|\
6. Modules
|\
Table Views - CORRECT ANSWERS ✔✔1. Design View
|\ |\ |\ |\ |\ |\ |\ |\
2. Datasheet View
|\ |\
Datasheet View (Table) - CORRECT ANSWERS ✔✔A grid
|\ |\ |\ |\ |\ |\ |\ |\
containing Fields (Columns) and Records (Rows). You can
|\ |\ |\ |\ |\ |\ |\ |\
view, add, edit and delete records in this view.
|\ |\ |\ |\ |\ |\ |\ |\
Design View (Table) - CORRECT ANSWERS ✔✔Detailed
|\ |\ |\ |\ |\ |\ |\
view of the table's structure and is used to create and
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
,modify a table's design by specifying the fields it will
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
contain.
Primary Key - CORRECT ANSWERS ✔✔The field (or
|\ |\ |\ |\ |\ |\ |\ |\
combination of fields) that uniquely identifies each record |\ |\ |\ |\ |\ |\ |\
in a table.
|\ |\ |\
Foreign Key - CORRECT ANSWERS ✔✔A field in one table
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
that is also a primary key of another table.
|\ |\ |\ |\ |\ |\ |\ |\
Storage - CORRECT ANSWERS ✔✔Access works primarily
|\ |\ |\ |\ |\ |\ |\
from this. |\
As you enter and update the data in an Access database,
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the changes are automatically saved to the ________
|\ |\ |\ |\ |\ |\ |\ |\
location you specified when you saved the database.
|\ |\ |\ |\ |\ |\ |\
Memory - CORRECT ANSWERS ✔✔Microsoft Word, Excel,
|\ |\ |\ |\ |\ |\ |\
and Powerpoint work form this.
|\ |\ |\ |\
Your work is not automatically saved to your storage
|\ |\ |\ |\ |\ |\ |\ |\ |\
location.
, Compact & Repair Tool - CORRECT ANSWERS ✔✔An |\ |\ |\ |\ |\ |\ |\ |\
access utility that reduces the size of the database and
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
repair a corrupt database.|\ |\ |\
Back Up Database Tool - CORRECT ANSWERS ✔✔An
|\ |\ |\ |\ |\ |\ |\ |\
access utility that creates a duplicate copy of the
|\ |\ |\ |\ |\ |\ |\ |\ |\
database.
Sort - CORRECT ANSWERS ✔✔The process of listing
|\ |\ |\ |\ |\ |\ |\ |\
records or text in a specific sequence, such as
|\ |\ |\ |\ |\ |\ |\ |\ |\
alphabetically by last name. |\ |\ |\
Filter by Selection - CORRECT ANSWERS ✔✔A filtering
|\ |\ |\ |\ |\ |\ |\ |\
method that displays only records that match selected
|\ |\ |\ |\ |\ |\ |\ |\
criteria.
Filter by Form - CORRECT ANSWERS ✔✔A filtering method
|\ |\ |\ |\ |\ |\ |\ |\
that displays records based on multiple criteria.
|\ |\ |\ |\ |\ |\ |\
Access vs. Excel - CORRECT ANSWERS ✔✔Excel:
|\ |\ |\ |\ |\ |\
|\ - Only one worksheet
|\ |\ |\
|\ - Number data
|\ |\
Access:
|\ |\ |\ |\ |\
Database - CORRECT ANSWERS ✔✔A collection of data
|\ |\ |\ |\ |\ |\ |\ |\
organized as meaningful information that can be
|\ |\ |\ |\ |\ |\ |\
accessed, managed, stored, queried, sorted, and
|\ |\ |\ |\ |\ |\
reported.
6 Objects of a Database - CORRECT ANSWERS ✔✔1. Table
|\ |\ |\ |\ |\ |\ |\ |\ |\
2. Forms
|\
3. Queries
|\
4. Reports
|\
5. Macros
|\
6. Modules
|\
Table Views - CORRECT ANSWERS ✔✔1. Design View
|\ |\ |\ |\ |\ |\ |\ |\
2. Datasheet View
|\ |\
Datasheet View (Table) - CORRECT ANSWERS ✔✔A grid
|\ |\ |\ |\ |\ |\ |\ |\
containing Fields (Columns) and Records (Rows). You can
|\ |\ |\ |\ |\ |\ |\ |\
view, add, edit and delete records in this view.
|\ |\ |\ |\ |\ |\ |\ |\
Design View (Table) - CORRECT ANSWERS ✔✔Detailed
|\ |\ |\ |\ |\ |\ |\
view of the table's structure and is used to create and
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
,modify a table's design by specifying the fields it will
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
contain.
Primary Key - CORRECT ANSWERS ✔✔The field (or
|\ |\ |\ |\ |\ |\ |\ |\
combination of fields) that uniquely identifies each record |\ |\ |\ |\ |\ |\ |\
in a table.
|\ |\ |\
Foreign Key - CORRECT ANSWERS ✔✔A field in one table
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
that is also a primary key of another table.
|\ |\ |\ |\ |\ |\ |\ |\
Storage - CORRECT ANSWERS ✔✔Access works primarily
|\ |\ |\ |\ |\ |\ |\
from this. |\
As you enter and update the data in an Access database,
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the changes are automatically saved to the ________
|\ |\ |\ |\ |\ |\ |\ |\
location you specified when you saved the database.
|\ |\ |\ |\ |\ |\ |\
Memory - CORRECT ANSWERS ✔✔Microsoft Word, Excel,
|\ |\ |\ |\ |\ |\ |\
and Powerpoint work form this.
|\ |\ |\ |\
Your work is not automatically saved to your storage
|\ |\ |\ |\ |\ |\ |\ |\ |\
location.
, Compact & Repair Tool - CORRECT ANSWERS ✔✔An |\ |\ |\ |\ |\ |\ |\ |\
access utility that reduces the size of the database and
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
repair a corrupt database.|\ |\ |\
Back Up Database Tool - CORRECT ANSWERS ✔✔An
|\ |\ |\ |\ |\ |\ |\ |\
access utility that creates a duplicate copy of the
|\ |\ |\ |\ |\ |\ |\ |\ |\
database.
Sort - CORRECT ANSWERS ✔✔The process of listing
|\ |\ |\ |\ |\ |\ |\ |\
records or text in a specific sequence, such as
|\ |\ |\ |\ |\ |\ |\ |\ |\
alphabetically by last name. |\ |\ |\
Filter by Selection - CORRECT ANSWERS ✔✔A filtering
|\ |\ |\ |\ |\ |\ |\ |\
method that displays only records that match selected
|\ |\ |\ |\ |\ |\ |\ |\
criteria.
Filter by Form - CORRECT ANSWERS ✔✔A filtering method
|\ |\ |\ |\ |\ |\ |\ |\
that displays records based on multiple criteria.
|\ |\ |\ |\ |\ |\ |\
Access vs. Excel - CORRECT ANSWERS ✔✔Excel:
|\ |\ |\ |\ |\ |\
|\ - Only one worksheet
|\ |\ |\
|\ - Number data
|\ |\
Access:
