Databases make data - easy to store, organise and search, A database is a - collection of data organised, You can think of a database like an - electronic filing system, A database will exist even when - the power is off or the system has a failure, Data is organised into a - table structure, A table consists of - a number of records, A table is sometimes referred to as - a flat file, A record is represented as - a row in a table, A field is part of - a record, A field stores - a single data item, represented by a column, A key field uniquely - identifies one record, A query - searches and filters data in a database, A query is used to find - an answer to a question, A database allows you to - interact, extract and present information that is required, The key field is also known as - the primary key, An example of a key field would be - a customer ID, To create a query - criteria are added to one or more fields in the table, A form is used to - enter a new record, modify an existing record and view records already stored in the table, A form is a user-friendly interface that - hides complexity from the end user, A form is a common way to - collect data from people, When data is added to a form - it is automatically added to the specified table, Forms can be customised to include - a logo and colour, A report allows tables and results from queries - to be presented in a user-friendly way, A macro is - a small program written to perform a repetitive task automatically, Macros add - functionality to forms and reports, Using a macro means - the user can click on one button, instead of entering multiple instructions, You can link two tables together in a database - by using a relationship, To create a database relationship, there must be - a common field, Relationships can be classified as - ONE to ONE, ONE to MANY or MANY to MANY, A non-key field is known as - a foreign key,
0%
Database Applications (Part 1)
Поделиться
от
Atennyson556
CCEA GCSE Digital Tech Software
Редактировать контент
Печать
Внедрить
Больше
Задания
Таблица лидеров
Показать больше
Показать меньше
Эта таблица лидеров в настоящее время является частной. Нажмите
Поделиться
, чтобы сделать ее общедоступной.
Эта таблица лидеров была отключена владельцем ресурса.
Эта таблица лидеров отключена, так как у вас и у владельца ресурса разные значения параметров.
Варианты отмены изменения
Сопоставить
— это открытый шаблон. Он не создает баллы для таблицы лидеров.
Требуется вход в систему
Визуальный стиль
Шрифты
Требуется подписка
Параметры
Переключить шаблон
Показать все
Дополнительные форматы будут отображаться при выполнении занятия.
Открыть результаты
Скопировать ссылку
QR-код
Удалить
Восстановить автоматически сохраненное:
?