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)
Ibahagi
Ibahagi
Ibahagi
ni
Atennyson556
CCEA GCSE Digital Tech Software
I-edit ang Nilalaman
I-print
Naka-embed
Higit pa
Mga Assignment
Leaderboard
Magpakita pa
Huwag gaanong magpakita
Ang leaderboard na ito ay kasalukuyang pribado. I-click ang
ibahagi
upang gawin itong pampubliko.
Ang leaderboard na ito ay hindi pinagana ng may-ari ng aktibidad.
Hindi pinagana ang leaderboard na ito dahil ang iyong mga pagpipilian ay naiiba sa may-ari ng aktibidad..
Ibalik ang Opsyon
Pagtutugma
ay isang bukas na template. Hindi ito bumubuo ng mga marka para sa isang leaderboard.
Kailangan maglog-in
Estilo ng visual
Mga Font
Kailangan ang subscription
Mga pagpipilian
Magpalit ng template
Ipakita lahat
Mas marami pang format ang lilitaw habang nilalaro ang aktibidad.
Buksan ang mga resulta
Kopyahin ang link
QR code
Tanggalin
Ibalik ng awtomatikong pag-save:
?
