ICT 2 FINAL EXAM REVIEW QUESTIONS WITH 100% VERIFIED GUARANTEED A+ PASS.

Database - correct answer A file that consists of one or more tables and the supporting objects used to get data into and out of the fields Relational Database Software - correct answer A computer application, such as Microsoft Access, that is used to store data and convert it into useful information Relational Database Management System - correct answer Data is grouped into similar collections, called tables, and the relationships between tables are formed by using a common field. Flat or Non-Relational Data - correct answer Data contained in a single page or sheet Field - correct answer A basic entity, data element, or category, such as a book title or telephone number Column - correct answer The data field that you assign to group data vertically into columns Record - correct answer A complete set of all of the data about one person, place, event, or idea Row - correct answer The source field that you assign to group data horizontally in a crosstab query Table - correct answer A collection of records Primary key - correct answer The field that makes each record in a table unique Foreign Key - correct answer A field in one table that also is stored in a different table as a primary key Query - correct answer A database object that enables you to ask questions about the data stored in a database and returns the answers in the order from the records that match your instructions Form - correct answer An interface that enables you to enter or modify record data Report - correct answer A printed document that displays information professionally from a database Datasheet View - correct answer A grid containing columns and rows where you add, edit, and delete records in a database table Design View - correct answer Displays the infrastructure of a table, form, or report without displaying the data One-to-Many Relationship - correct answer Exists when each record in the first table may match one, more than one, or no records in the second table Text - correct answer Stores alphanumeric data, such as a student's name or address Number - correct answer Contains a value that can be used in a calculation, such as the number of credits a student has earned Autonumber - correct answer A special data type that Access used to assign the next consecutive number each time you add a record Date/Time - correct answer Hold formatted dates or times and allows the values to be used in date or time arithmetic Currency - correct answer Can be used in a calculation an