ITM FINAL EXAM questions with answers.

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: