IT Fundamentals+ Module 2 Unit 4 Using Databases

Compile information for printing.

Display and maintain records.

Extract and change data.

Share data between databases.

Filters

Forms

Queries

Reports

Compile information for printing.

Display and maintain records.

Extract and analyse data.

Store records and fields.

A database administrator.

A database architect.

A database end user.

A database specialist.

A database administrator.

A database architect.

A database specialist.

Database users.

Database administrators.

Database architects.

Database specialists.

Database users.

A database administrator.

A database architect.

A database end user.

A database specialist.

Because it prevents related data from being changed or deleted.

Because it stops creation of duplicate data.

Because it will make searches in the related tables faster.

Because it reduces the need to index related tables.

A query

A relationship

An index.

A data type

To enable faster data searches.

To minimise duplication of data.

To optimise filtering of records.

To prevent the need for using queries.

Data could be lost.

Fields could be removed.

Records could be hidden.

Tables could be locked.

A form.

A primary key.

A validation rule.

An index.

A default value.

A filter.

A primary key.

A validation rule.

Caption

Default value

Field size

Format

AutoNumber

Number

Short Text

Memo

Each field in a table should contain a primary key.

Each field in a table should contain only one type of data.

Each field in a table should use the same data type.

Each field in a table should use the same field size.

A form should enter data into multiple tables.

A query should only fetch data from a single table.

A report should contain records based on a single data type.

A table should contain data related to a single subject type.

Storing and accessing bank account records.

Storing and accessing bookmarks in a Web browser.

Storing and accessing contacts in a mobile phone.

Storing and accessing videos on a hard drive.

A database contains forms and reports stored in tables.

A database contains indexes and criteria stored in tables.

A database contains reports and fields stored in tables.

A database contains fields and records stored in tables.

A data structure that improves search operations in a table.

A program for creating online forms.

A set of instructions used when retrieving data from a table.

A structured collection of records or data.