Database Concepts Flashcards

Front

Identify the components of a database.

Back

Components include tables, fields, records, and keys.

Front

Distinguish between fields and records in a database.

Back

Fields are individual pieces of data; records are collections of fields.

Front

Describe the basic data types and formats used in a database.

Back

Common data types include text, number, date, and boolean.

Front

Distinguish between a table and a query.

Back

A table stores data; a query retrieves data based on criteria.

Front

Identify database keys, including primary and foreign.

Back

Primary keys uniquely identify records; foreign keys link tables.

Front

Identify the relationships between tables in a database.

Back

Relationships include one-to-one, one-to-many, and many-to-many.

Front

Distinguish between a query and a report.

Back

A query retrieves data; a report presents data in a formatted way.

Front

Identify various report types.

Back

Report types include summary, detail, and grouped reports.

Front

Data type

Back

Defines the kind of data a field can hold, such as text or number.

Front

Datasheet View

Back

A view that displays data in a table format.