MCQs (Microsoft Access)

Row in a database table

1. Field
2. Query
3. Record
4. Form

Tool for collecting and organizing information

1. Data type
2. Database
3. Record
4. Field

group of database tables that are connected or linked by a direct relationship that ties the information together

1. Network database
2. Relational database
3. Private database
4. Business database

Columns in a database that uniquely identify each row

1. Primary key
2. Secondary key
3. Foreign key
4. Private key

Column in a database table

1. Field
2. Query
3. Record
4. Form

Kind of information a field contains whether it is text, number, date/time, or some other type.

1. Field
2. Data type
3. Record
4. Form

A visual representation of the data contained in a table or the results returned by a query.

1. Database
2. Datasheet
3. Record
4. Query

Database object that simplifies the process of entering, editing, and displaying data

1. Field
2. Query
3. Record
4. Form

Database object that enables stored data to search and retrieve

1. Field
2. Query
3. Record
4. Form

A system for managing data that allows the user to store, retrieve and analyze the information.

1. Query
2. Record
3. Database management system (DBMS)
4. Field

duplicate information in a database

1. Secondary data
2. Primary data
3. Redundant data
4. Private data

Database object that asks a table a question

1. Field
2. Query
3. Record
4. Form

Elements in a database such as tables, queries, forms and reports.

1. Records
2. Objects
3. Datasheets
4. Data types

process of applying rules to a database designed to ensure that information is divided into the appropriate tables

1. Form
2. Record
3. Normalization
4. Query